Access dbase connection string errors

[J. Muenchbourg]

I keep getting
"Unable to open registry key 'Temporary (volatile) Jet DSN "
errors pointing to my connection string when the same connection string
is working for a few of my other pages. The MSAccess database does have
the right permissions configured. Below is code I'm using:

<%
dbcon="DBQ=" & Server.Mappath("diary.mdb") & ";Driver={Microsoft Access
Driver (*.mdb)};"
Set calConn = Server.CreateObject("ADODB.Connection")
calConn.Open dbcon%>
<%dim freetsql,rsfree
freetsql = "select text_field from diary where dte ='" & dfm & "'"
set rsfree = Server.CreateObject("ADODB.Recordset")
rsfree.Open freetsql,calConn,3 %>


???
Muench

 

[Ray at]

Try this connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.Mappath("diary.mdb")
OLEDB

Then, after that's all working, go to
http://yoursite.com/TheDirectoryWithTheDB/diary.mdb and notice that you are
prompted to download your database. Anyone would be able to download your
database that way.

For further information on the error you received, read
http://www.aspfaq.com/2009.

Ray at work

 

[Mats]

Then, after that's all working, go to
http://yoursite.com/TheDirectoryWithTheDB/diary.mdb and notice that you are
prompted to download your database. Anyone would be able to download your
database that way.
Yes, just checked. How could we avoid that?
Mats

 

[Ray at]

Do not keep your mdb file in your website's directory structure. I.E.


Physical path on server to .htm/.asp files:
D:\Websites\Website1


Put mdb databases elsewhere, like:
D:\Databases\Website1\diary.mdb

When you do that, your Server.MapPath will no longer work, since that will
no longer be the path to your DB, but I think that's a minor tradeoff. You
could keep the path to your DB in an application variable or a global
constant. More on this topic can be found at:
http://www.aspfaq.com/2454
http://groups.google.com/[email protected]

Ray at work