I'm a novice Visual Basic programmer and I need to connect to an
application's database that uses SQL Adaptive Server driver. Below is an
example of code I use to connect to a MS SQLExpress database:

***********************
Sub Open_SQL_Connection()

Dim db_connection As ADODB.Connection

If db_connection Is Nothing Then
Set db_connection = New ADODB.Connection
db_connection.Open "Provider='SQLOLEDB';Data
Source='MyMachineName\SQLEXPRESS';" & _
"Initial Catalog='Timeclock';Integrated Security='SSPI';"
End If

End Sub
***********************

Can someone give me the equivalent for SQL Adaptive Server? The database I'm
connecting to is "ss.db" and the full path is "C:\TPC\ss.db". If needed, the
tables I'm connecting to are "posj_event" and "posj_raw_journal".

Thank you,

Barry