Printable View
I am working with ".mdb" file & DAO successfully (VB6).
But for 2 problem I have to work with SQL I think.
_1. data security
_2. using more PC with same database.
_and also 3. using large database
Now I cannot start programing with SQL(SQL 2000) from VB6.
I need ......
__(1) code to store a data (a row) to SQL database
__(2) code view data (a row) from SQL database
using any Connection method & Provider, what is best for me for Data security & using lan networking.
Welcome to the forum!
Here's a link showing a connection routine.
You should use ADO with MS SQL.
http://www.vbforums.com/showthread.p...39#post1804439
Also - there are threads at the top of the DB forum here that have tutorials and other info on SQL - but still, feel free to ask!
btw - in our shop we never use Bound controls and always use STORED PROCEDURES...
If you know how to insert and fetch records using DAO then you would do just fine in SQL since they use the same SQL...Quote:
Originally Posted by r_amin
you mean, I can use DAO with SQL?Quote:
Originally Posted by dee-u
First - you should remove your e-mail address from your other thread - it will be picked up by bots and you will get spammed!
Second - you should use ADO to connect to MS SQL server. I gave you a link with VB code for a connection - but here it is anyway:
This will establish a connection to the DB.Code:If strDriver = "" Then
strDriver = "SQLOLEDB"
End If
'Create a connection to the database
Set gCn = New ADODB.Connection
gCn.Provider = strDriver
gCn.Properties("Data Source").Value = strServer
gCn.Properties("Initial Catalog").Value = strDatabase
If gstrUser <> "" Then
gCn.Properties("User Id").Value = gstrUser
gCn.Properties("Password").Value = gstrPassWord
Else
gCn.Properties("Integrated Security").Value = "SSPI"
End If
gCn.CommandTimeout = 300
gCn.Open
'Check the connection state
If gCn.State = adStateOpen Then
EstablishConnection = True
Else
EstablishConnection = False
End If
Third - use the SEARCH feature of this forum - and search for "GCN" - this is my global connection variable. You will find dozens of threads with all kinds of examples of working with SQL from VB.
No, as Szlamany suggested you should use ADO. What I meant was the DML's, the AddNew, etc are basically the same or with very minimal difference...Quote:
Originally Posted by r_amin