Google Answers Logo
View Question
 
Q: Dreamweaver MX define connection DSN less using server.mappath ( No Answer,   0 Comments )
Question  
Subject: Dreamweaver MX define connection DSN less using server.mappath
Category: Computers > Programming
Asked by: nickyb-ga
List Price: $25.00
Posted: 10 Aug 2002 20:37 PDT
Expires: 28 Aug 2002 13:13 PDT
Question ID: 53134
I am using Dreamweaver MX and am trying to develop some sites for
school using DSN less connections using the function server.mappath. 
I have done this before, but now I would like to automate the process
using DW MX's capabilities.  My previous connection strings read:

Set conn = Server.CreateObject("ADODB.Connection")
set rs = server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DBQ=" &
Server.Mappath("database/investing.mdb") & ";Driver={Microsoft Access
Driver (*.mdb)};"
conn.open

This works fine on every page I've tried it on.  However, now I'm
trying to go into "Server
Behaviors"=>"+Recordset(RS)"=>"Define...(Connection"=>"New/Custom
Connection String"=>then putting the "conn.ConnectionString = "DBQ=" &
Server.Mappath("database/investing.mdb") & ";Driver={Microsoft Access
Driver (*.mdb)};" into the field where it asks for "Connection
String".  When I test it, I recieve the error "Format of the
initilization string does not conform to the OLE DB specifications."

What do I need to do to set up Dreamweaver MX with my DSN-less
server.mappath connection properly?
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy