I.T. Discussion Community!
-Collapse +Expand
VB Classic
Search VB Classic Group:

Advanced
-Collapse +Expand VB Classic Store

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyVisual Basic Classic Board   Print This     

VB Classic Database Tasks Topic

Single user, multi-user, client server and n-tier database applications.

 

 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Parthasarathi N
Error :: SQL Server Backup & Restore From VB
I am using SQLDMO for Backup & Restore. When i use the SQLDMO objects in ASP its working fine. But when I tried it in VB (not a VB Component, but in the project), for both Backup & Restore, Im getting the following error message. , , [b]Run-time error '-2147221499 (80040005)': , , [SQL-DMO]Code execution exception: , EXCEPTION_ACCESS_VIOLATION [/b], , , Can anyone tell me whats wrong.
18 years ago
1 Reply:

Adob.T
{Too Long!}
5 months ago
Nothing New Since Your Last Visit
1255
Hits

Thread 24 of 25
Thread Starter  

mandruch
Data Environment Designer?
I'm using Windows 98 and VB 6 Enterpirse edition. I can't get the Data Environment Designer to load. Am I missing something? It worked for me in class. Just can't get it to work at home? Please help..., , Thanks,, , Mike A Confused
17 years ago
1 Reply:

Richard.r2
{Too Long!}
10 months ago
Nothing New Since Your Last Visit
2023
Hits

Thread 23 of 25
Thread Starter  

dmwilson34
VB - FileNET ADO DB Leak
{Too Long!}
18 years ago
3 replies. Last post:

Kirkland.J
It permits you to arrange as well as see your pictures, video clips, as well as songs. kodi | open source home theatre software You need to modify the resources as well as include a brand-new resource. 
14 months ago
Nothing New Since Your Last Visit
1842
Hits

Thread 22 of 25
Thread Starter  

Peter Buckthorp
Using Visual Basic 6 to connect with Interbase
Delphi with Interbase I have mastered but I have been asked to write a VB6 front end to address an existing Interbase database. Bought a copy of VB6 and several books ~ spent many hours studying the limited information available ( none relating to Interbase )and trying to write a coded connection without success. I would be most grateful if someone could end my frustration by providing the solution.
18 years ago
7 replies. Last post:

Brodie.J
Various other motion pictures could be enjoyed mobdro apk file pictures, information, sports & TV channels.
20 months ago
Nothing New Since Your Last Visit
2994
Hits

Thread 21 of 25
Thread Starter  

khatib_b
No Subject
Hi every body I was able to designate an access Database as a custom source to a textbox to accomlish autocomplete property of the textbox. The problem is when I enter the first letter of a word I get about 15 autocomplete suggestions while in the DB there are more than 50 words beginning with that letter. Is there a way to make the whole words displayed in the autocomplete pop up box. Thanks for your help
10 years ago
Nothing New Since Your Last Visit
4629
Hits

Thread 20 of 25
Thread Starter  

ssharrock
Bind param based stored proc recordset to dbgrid u
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2301
Hits

Thread 19 of 25
Thread Starter  

Naresh Panta
Trapping Oracle Error Message from Visual Basic
How can i trap the error message returned by oracle in visual basic., , Thanks , , Naresh
18 years ago
3 replies. Last post:

Mayo134.m
good Mobdro App is an application which is extremely valuable for mobdro app various other point you have to do i.e. just download  great.
25 months ago
Nothing New Since Your Last Visit
1363
Hits

Thread 18 of 25
Thread Starter  

jason_robertson
Query Access 2.0 from VB6
Hi I am new to Classic vb I have a really challenging problem, and I would be very grateful for any help ideas suggestions that any of you gun vb6 developers might have I need to read data out of an Access 2.0 file format file from VB6 this has to be compiled and redistributed as part of a database upgrader, licensing constraints and the end user desktops prevent the use of a VBA runtime. Thanks in advance
11 years ago
Nothing New Since Your Last Visit
3225
Hits

Thread 17 of 25
Thread Starter  

gilgal
how to write script (correct my script) for MSFlex
{Too Long!}
13 years ago
1 Reply:

mprestwood
Instead of doing rs("FieldNameHere"), you should do rs.Fields("FieldNameHere"). I actually prefer specifying the .value property on the end too.
12 years ago
Nothing New Since Your Last Visit
3045
Hits

Thread 16 of 25
Thread Starter  

raj74
How to save the data from MSFlexGrid into a databa
My doubt is i am using MSFlexGrid to display the invoice details (detail table data).User can able to see the invoice data and also to edit the present data in the MSFlexGrid and also user can add new data (rows) in the MSFlexGrid.How i can do that?.I also like to know how user can delete a row from MSFlexGrid?
17 years ago
3 replies. Last post:

mprestwood
My understanding is that Microsoft recommends you use an auxiliary Edit control for doing the task. When you want to edit the text in a cell, you retieve the cell's rectangle and place an edit control over it. It's a bit complex but here's a tutorial:, , [URL=http://www.codeguru.com/Cpp/controls/controls/gridcontrol/article.php/c5291/]MSFlexGrid Edit Tutorial[/URL], , Is there a reason you can't use a DataGrid?
15 years ago
Nothing New Since Your Last Visit
8873
Hits

Thread 15 of 25
Thread Starter  

akom
Dbase 7
I need to connect to a database that is in Dbase 7 can I do that from Visual Basic 6?
16 years ago
1 Reply:

cheddar
this is way late but maybe someone else can use it. You should be able to find what you need here: http://www.dbase.com
15 years ago
Nothing New Since Your Last Visit
2776
Hits

Thread 14 of 25
Thread Starter  

davidsplace
Text field remains blank
I'm working on a database program using VB6. The database has a field called ID which is an auto-incriment field. My problem is when I press a button to insert a new record the ID field in the database is auto-incrimented but the text field on the form isn't. The number will not show in the text field until I exit the program and restart it. Can anyone help?
16 years ago
Nothing New Since Your Last Visit
2333
Hits

Thread 13 of 25
Thread Starter  

Glenn.G
Replacing characters in a large file
I have a SQL server table that has been exported using bcp with the -n native option. I need to search through the file for carriage returns and linefeeds and replace them with a space., The file is a large address file (approx. 20,000 records). Does anyone have a utility to do this or can assist with the code?, The CR&LF cause problems with the bulk upload to our web site., Thanks, Glenn
17 years ago
3 replies. Last post:

cheddar
Use replace as you copy the data to a temp table. Then bcp the temp table. This way you do not modify the existing. , , Insert into TempTable SELECT Field1, Replace(Field2, CRLF, '') from Table, , or something like that
17 years ago
Nothing New Since Your Last Visit
2845
Hits

Thread 12 of 25
Thread Starter  

Zapotec
Crystal Reports and Recordsets in VB
cr_Report.Database.SetDataSource rs_Report, , Using that line returns the entire contents of the query table instead of the items in the query., , If I assign the recordset to an array the array contains ONLY the items I requested but when I assign the same recordset to the crystal report it contains ALL the items in the table., , Any help would be greatly appreciated., , Thanks,, , Mike
17 years ago
1 Reply:

southland
In order to get the right result from the table., I would write a stored procedure. CR would show the data base on this stored procedure. , , If it works, use VB to call this CR. Good luck
17 years ago
Nothing New Since Your Last Visit
2917
Hits

Thread 11 of 25
Thread Starter  

rajeshjay
password character in input box
Before closing a particular form, i am using an input box to enter the password, and validate authentication. but how do i use password characters like '*', for the data entered in the Input box., Thanks., the present code is ->, Private Sub Form_Unload(Cancel As Integer), , Screen.MousePointer = vbDefault, Dim pwd As String, pwd = InputBox("Please enter the Password"), If (pwd = "raj") Then, Cancel = 0, Else, Cancel = 1, MsgBox "Sorry you dont have the authority to close this", endif
17 years ago
1 Reply:

dhoyle
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
4581
Hits

Thread 10 of 25
Thread Starter  

Salman Hussain
Database Encryption or hiding from user...
I have developed a database program in Visual Basic 6, using Access to persist the data. How can I encrypt my Access Database so that no one can open my database to modify except me. Because by double clicking on the database, opens it in Access.
17 years ago
1 Reply:

jdschram
password lock the database...., TOOLS -> SECURITY -> SET DATABASE PASSWORD, , you need to open the DB Exclusively, , also you can hide the tables by , TOOLS -> OPTIONS -> view tab, and uncheck all boxes in the show area, This really isnt secure, but if someone happens to guess the DB password they still have to know how to make the tables visible...
17 years ago
Nothing New Since Your Last Visit
1933
Hits

Thread 9 of 25
Thread Starter  

Mike Rock
16-bit ODBC to sql server problem
I am trying to access Sql Server 6.5 and 7.0 using 16-bit ODBC (vb 3.0). The program uses two methods to execute stored procedures..., DB_SQLPASSTHROUGH - gets "invalid argument", SQLPREPARE --> SQLEXECUTE get "Stored Procedure" "not found", , I have tried using "dbmssoc3" and even "dbnmp3" as network libraries, but that did not help., , I expect that I have something wrong with my ODBC setup., , Any ideas? I have searched the web, but cannot find much help. Maybe an install of the latest version of 16-bit ODBC might help, but I cannot find it. I did install Access 2.0 attempting to get a more current 16-bit ODBC., , Help!
17 years ago
Nothing New Since Your Last Visit
1616
Hits

Thread 8 of 25
Thread Starter  

Peter Ferber
Assigning Bitmap to Access "OLE Object"
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2306
Hits

Thread 7 of 25
Thread Starter  

Peter Ferber
Using VB to assign bitmaps to OLE Object Field
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
3129
Hits

Thread 6 of 25
Thread Starter  

Evaristo
Vb+Access+Indexes
I need to use indexes in an VB Application that uses a ADO to access to an access 2000 database., To use de index and seek instructions I need to use de server side cursor location?, When I do these my recordset object loses all is potentialities like movefirst, movelast etc., How can I use permanent indexes (not the sort method with the optimize property) without losing the versatility of the recordsets., , If you can, please help me as soon as possible , , My best regards , Evaristo Figueiredo
17 years ago
Nothing New Since Your Last Visit
1658
Hits

Thread 5 of 25
Thread Starter  

olivern
Exporting separate Access Tables to tab delimited
Hello, I am trying to export separate MS ACCESS tables inot a tab delimited text file. Does anyone know how this can be accomplished?
17 years ago
Nothing New Since Your Last Visit
1888
Hits

Thread 4 of 25
Thread Starter  

dadrivr
Writing to/Deleting from a Database
Is there a way to write fields to/delete fields from the database in vb? Example:, I am creating a user login program. I want there to be an option to create a user, so I want to be able to write that user's information to the database. I also want to be able to delete a specific user from the database.
17 years ago
Nothing New Since Your Last Visit
1745
Hits

Thread 3 of 25
Thread Starter  

Shaul
Using Data Link File(.udl) in Data environment
Hi Everyone, , , I have designed a data report using the Visual Basic 6 Data report designer and the report works fine when I use a data environment. , My problem is that I have now moved the database to a remote PC on a LAN and I would like the flexibility to change the database location using a Microsoft Data Link(.udl) file. , I have created the udl file but do not know how to specify it as the source for connection parameters in thr data environment. It does not let me use "file name = myUdlFile.udl" anywhere - not in the ConnectionSource, not in the Data Environment Initialize method, NOWHERE! , Please can someone tell me how to use a udl file to specify the database location for a data report, either using it in the data environment or somewhere else. Can I just create some sort of data environment manually and the use the udl file? , , , Shaul
17 years ago
Nothing New Since Your Last Visit
2101
Hits

Thread 2 of 25
Thread Starter  

vearn21
vb+mysql
hi.., just wanna ask about vb+mysql db., i tried to update field that have datatype date but it not work., , dim mydate , dim mydate12 as date , , mydate12=format(now,"yyyy-mm-dd") , 'mydate12=2002-04-29 , , mydate=format(now,"yyyy-mm-dd") , 'mydate = 2002-04-29 , , sql = "UPDATE customer SET date_keyin=" & mydate & "," & "user_name=" & "'ihan'" , sql = sql & " WHERE (id_no =" & txtID & " AND ref_no=" & "'" & txtNoRef & "')" , conn.Execute sql , , i wanna update date_keyin field., if i use mydate variable, it insert null value but when i use mydate12 it work but it insert value 2000-00-01., why? how can i update the true date. using 'now' command. any suggestion?, , thanx
17 years ago
2 replies. Last post:

vearn21
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2221
Hits

Thread 1 of 25
Thread Starter  

RBC
Problem with VB for login
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1912
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,415 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech