Problem with OLEDB connection string with password in ASP

[jonathanfrascella]

Apologies if this should be in an ASP forum, I wasn't sure so I tossed a coin and "Access Other.." won.

I've got an Access DB which I'm trying to connect to via an ASP page. The DB has a password, but no username and opens fine locally - it prompts me for a password, then opens the DB.

When I use the following connection string I get a "Could not find installable ISAM" error.

<%
Set oConn = Server.CreateObject(&quot;ADODB.Connection&quot;)
strConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & Server.MapPath(&quot;data/myDB.mdb&quot;) & &quot;;UID=;PWD=myPassword&quot;
oConn.Open strConn
%>

I've updated both the server and my client machines to run MDAC 2.7 and everything else runs fine. I can connect to a copy of the same DB with the password removed, but for my purposes I need to connect to the protected version.

 

[DanJR]

hi there,

try this: use "Jet OLEDBatabase Password=" instead of "pwd="

Set oConn = Server.CreateObject("ADODB.Connection&quot
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/myDB.mdb&quot & "Jet OLEDBatabase Password=myPassword"
oConn.Open strConn

In the past this message has caused me a number of hours of frustration...The error message you are getting (to me) seems to be a generic one. For example, some people have reported this message when they put 'DataSource' instead of 'Data Source' (spelling mistake). Other times, it occur when you specify the wrong data provider in the connection string. Other times, its a MS bug (e.g. search MSDN).

Does this help?

Cheers,
Dan


P.S. A good site on connection strings OLE DB providers is:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForODBCDatabases

 

[jonathanfrascella]

Excellent - that code snippet was spot on.

Before you replied, I tried changing "PWD=" to "Password=" which gave an alternative error, but that's irrelevant now, thanks.