MsSQL database connection with VB6 using DAO

[kamaphosa]

how do i connect, open and update records in an SQL database using VB6 and DAO?

[RhinoBull]

DAO (and even RDO) these days is a complete obsolete. Can't you use ADO? It's much more robust and flexible. We have tons of samples available throughout the forums.

[kamaphosa]

had an application running on DAO in MsAccess but will certainly change to ADO.
thanx

[asd9001]

thes Code To Connect In Ado

Dim cn As New ADODB.Connection
Dim X As String
X = "Provider=MSDASQL;DRIVER=MySQL ODBC 3.51 Driver;Server=localhost;database=agc;Option=16387"
cn.ConnectionString = X
cn.Open