I am getting an error message with my connection string. I am connecting to a different server and my connection string is below.

  Dim objConnPROP
  Set objConnPROP = Server.CreateObject("ADODB.Connection")
  objConnPROP.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\backdraft\administration\Programs and Database\Benefits\PROP.mdb"

Am I missing something else? Everytime I run the application I get an error message

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Below is the program that is trying to open the database:

strSQL = "SELECT * FROM Transaction_Detail " & _
              "WHERE SSN = " & Session("SSN") & " ORDER BY Tran_Seq_ID ASC;"
Set rsPROPInfo = Server.CreateObject("ADODB.Recordset")
rsPROPInfo.Open strSQL, objConnPROP


Please help me get this problem resolved.

Thanks

Try this site:

http://www.connectionstrings.com/

I already went to that site and used it. I am still getting the same error message.

What is the error message?

check your syntax for errors or spelling mistakes.