Forums
This topic is locked
Two connections to use if files are on server?
Posted 17 Sep 2005 18:26:03
1
has voted
17 Sep 2005 18:26:03 Didier Glorieux posted:
Hi guys,I do have a question about connection strings.
This because I have a small problem.
I have a server 2003 and a pc, they are bought on the same internal network(server is for testing).
on my pc I installed dreamweaver mx.
the problems is, if I want to use the build in bindings menu I have to use a connection string like this :
Mystring= "Driver={Microsoft Access Driver (*.mdb)};DBQ=z:\name of my site\data\mydatabase.mdb"
Z stands for a link I made from my computer to a shared folder on my server.
If I use this, I can use alle bindings option (I can see the tables, the properties,...).
But if I then test the page, I have an error.
Mystring = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../data/mydatabase.mdb" & ";"
then it workes on my testingserver thru IE, but in dreamweaver I can't make use of the bindings menu options (I get an error and can't see the tables.)
is there any solution to make this thing work for both?
hope somebody has an answer on this one.
greetz
Didier
Edited by - Pixellink on 17 Sep 2005 18:26:35