Connection String to MS ACCESS
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
|