Hi,
Running VB 2008 Express and would programmatically write a connection to a sql database.
Will I also need to reference something?
VB6 would be something like this but not sure about VB 2008.
Dim rs as New ADODB.Recordset
Dim Conn As New ADODB.Connection
Public Sub DBConnect()
With
.CursorLocation = adUseClient
.ConnectionString = "Provider=Microsoft.Jet.OL
EDB.4.0;Da
ta Source = C:\Program Files\Microsoft Visual Studio\VB98 \Database Editor\DBEditor.mdb"
.Open
End With
rs.Open "SELECT * FROM MT",Conn,adOpenDynamic,adL
ockOptimis
tic,adcmdT
ext
End Sub
Start Free Trial