View Single Post
  #1 (permalink)  
Old February 10th, 2004, 06:39 PM
phungleon phungleon is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , .
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connection String

I have always manually typed in connection strings in my ASP pages, which looks like this:

<%
Set conn = Server.CreateObject("ADODB.Connection")
cnpath="DBQ=" & server.mappath("classifications_studies.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
%>

I am now trying to use DreamWeaver MX's database tool to do this. The Wrox book I bought ask me to type this:

"Provider =microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\database_name"

in the "Connection String" textbox when the "Custom Connection String" window pops up. The problem is, I have a remote server, instead of a local path. I tried incorporating my own string list above instead of the one shown in the book. But when I clicked on "Test COnnection," I get a path c:\hrftp\leont\..... path not found.

I don't get it. Is there another way to create a connection so DW MX can understand, instead of using their buil-in connection tool? If not, what should I type into the "Connection String" text box based on my connection string i have given u above?

Thank you.

Leon


Reply With Quote