HELP VB6 and SQL how to's

[wakarooh]

---

vb6 is object based PL so dali ra pagconnect to virtually any database, basta naa available na object to do that. Pareha sa MS ADO. Add lang reference to it then create an adodb object.

Public con As New Adodb.Connection

Sub Main()
   con.Open [connection string] 'visit http://connectionstrings.com for info
End Sub

[uzumaki]

in my case mas ganahan ko sa connection string through codes not on data link properties

[wakarooh]

pure codes bitaw na..no ocx needed

[wakarooh]

Pag .NET nalang bro...(VB.NET or C#)., vb6 is pretty old technology.

yes it is! but admit it, most companies now are still using vb6.
VB6 written programs might be slower than programs written in .net or C but the later takes more time and is more bug prone. For the recent machines (dual-core, quad-core etc), your time coding is more precious than execution speed of your compiled program.

[The_Undertaker]

thanks for all ur help here bros... it really helped alot! I was able to get a good answer from a new friend and i was able to resolve many of my questions about databases.

[Dakouten]

this is a sample program.
Eto yung connection string ko...

Public Const sqlCon = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=ServerAddress;DATABASE=databaseName ;USER=User;PASSWORD=Password"

Note: Mysql ang database na gamit ko dito, so para maka connect ka sa mysql you need Mysql ODBC Driver.

Then:

Dim adoConn As ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str as string

Set adoConn = New ADODB.Connection
adoConn.ConnectionString = sqlCon
adoConn.Open

Set rs = New ADODB.Recordset
str = "Select * from Table"

rs.ActiveConnection = adoConn
rs.LockType = adLockOptimistic
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.Open str


hope this helps.