View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Connection String does not work?

Thread began 9/18/2009 11:10 pm by fred306789 | Last modified 9/19/2009 12:34 pm by fred306789 | 803 views | 1 replies


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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...