VBScript how to set the connection string

Answer 1

Try setting the provider in the connection string

conn.ConnectionString = "Provider=SQLOLEDB.1;Data Source=XXX;Initial Catalog=XXX;User ID=<XXX>;Password=<XXX>;"

Note: I haven't tested it but it should work

Answer 2

For all your connection string needs: http://www.connectionstrings.com/

Answer 3

With SQL Server you don't connect directly to the file. Access, being a file-based RDBMS is a little different.

Following your example, it would look something like this:

Dim conn, sql
sql = "SELECT * FROM tblOutbox"
Set conn = CreateObject("ADODB.Connection")
With conn
      .Mode = adModeReadWrite
      .ConnectionString = "Provider=SQLOLEDB;server=[servername];database=[databasename]uid=[insertuser];pwd=[insertpassword];"
      .Open 
End With
If conn.State = adStateOpen Then
      WScript.Echo "Connection was established."
End If
conn.Close
Set conn = Nothing

There's usually a more compact way of doing this, but without the context its hard to give a better example