![]() |
|
|
| 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? |
|
| There is no answer at this time. |
|
| There are no comments at this time. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |