Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access -- >SQL Provider Syntax
- Thread starter jurgen
- Start date
SQL Server 7 or 2000 ???
' ---------- DSN less ------------------
Dim Conn As ADODB.Connection
Dim Rs1 As ADODB.Recordset
Set Conn = New ADODB.Connection
Set Rs1 = New ADODB.Recordset
Conn.Open "driver=SQL Server;server=yourSQLdatabase;uid=sa;pwd=;database=yourdatabase;"
Dim SQLCode As String
SQLCode = "Select ....."
Rs1.Open SQLCode, Conn, adOpenStatic, adLockOptimistic
'Do some stuff with the recordset
Set Rs1 = Nothing
Set Conn = Nothing
'''
I use this everywhere.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
' ---------- DSN less ------------------
Dim Conn As ADODB.Connection
Dim Rs1 As ADODB.Recordset
Set Conn = New ADODB.Connection
Set Rs1 = New ADODB.Recordset
Conn.Open "driver=SQL Server;server=yourSQLdatabase;uid=sa;pwd=;database=yourdatabase;"
Dim SQLCode As String
SQLCode = "Select ....."
Rs1.Open SQLCode, Conn, adOpenStatic, adLockOptimistic
'Do some stuff with the recordset
Set Rs1 = Nothing
Set Conn = Nothing
'''
I use this everywhere.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Thread starter
- #3
- Status
Similar threads
- Question
- Question
- Locked
- Question
- Locked
- Question