Connection String does not work?
I just purchased this software and cannot get this to work. I have posted in the Data Assist forum and just noticed that, So I am posting here.
I am using CS4, I always used the Server.Map path and had no problem. Now you guys or Adobe changed something and I cannot get this to work. Just sped $ 150 for a software this is NOT WORKING !!!
I checked with my ISP and they tell me that all the server components are working and I am using the wrong connection ASP code. I do not know who is write or wrong here, I just need to get this working.
Here again is the connection strings I tried:
'MM_email_Con_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/access_db101/test.mdb")
MM_email_Con_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" D:/Hosting/6005018/html/access_db101/test.mdb
In dreamweaver when I test the Server.MapPath I connect fine, on the V-Hosting I am getting 500 server error.
When hand code the ASP code I can get the data from the Database here is the code:
Dim sSQL,rs,cnn,success,showaccount,addsuccess
Set rs = Server.CreateObject("ADODB.RecordSet")
Set cnn=Server.CreateObject("ADODB.Connection")
sSQL = "SELECT * FROM admin"
When I use this Junk I get the 500 error message:
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_email_Con_STRING
Recordset1_cmd.CommandText = "SELECT * FROM admin"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
Why is this happening? Help Please.