Upon attempting to create an OLE DB connection to an Access database in Dreamweaver 8, I cannot view any tables in the db. When building the OLE DB connection, it tests successfully, but when I test the connection when it is under my database connections, the connection fails stating an invalid path to my database file. Any thoughts?

I am not sure about your problem , but DWCS3 have a function to generated OLEDB by using Application>databases>customstringconnection ,for me it's test ok on localhost and realhost.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connBlog_STRING
MM_connBlog_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/myfoldername/mydataname/mydatafolderbasename.mdb"
%>







Edited by - happyraedygo on 26 Jul 2007 18:55:45

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am not sure about your problem , but DWCS3 have a function to generated OLEDB by using Application&gt;databases&gt;customstringconnection ,for me it's test ok on localhost and realhost.

&lt;%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connBlog_STRING
MM_connBlog_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/myfoldername/mydataname/mydatafolderbasename.mdb"
%&gt;

In my DW/CS3 - My attempts to create a connection using Server.MapPath never works. I have to use an absolute address instead - which causes all kinds of other problems. Is there more insight here??

Ron





Edited by - happyraedygo on 26 Jul 2007 18:55:45
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Edited by - rontev on 30 Jul 2007 02:27:57

do you mean the database was not found only when using Sever.mappath method?

1.Is The database on your database folder in your rootsite?
Server.MapPath method is just look for database via dynamic address.
While Absolute method is look for database via static address.

2. forgot first "/"?
("/myfoldername/mydatabasefolder/mydatabasename.mdb" not equal to
("myfoldername/mydatabasefolder/mydatabasename.mdb" at all.