- MS Access
strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & _
"C:\Program Files\Microsoft Visual Studio\VB98\nwind.mdb;"
- MS SQL Server
strConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=YOUR_SERVER_NAME;" & _
"Database=YOUR_DATABASE;User ID=YOUR_USERNAME;Password=YOUR_PASSWORD;"
- mySQL Database
strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=YOUR_DATABASE;" & _
"SERVER=YOUR_SERVER_NAME;UID=YOUR_USERNAME;PASSWORD=YOUR_PASSWORD;PORT=;OPTION=0;STMT=;"
|