Couldn't find installable ISAM.

[Sensibilium]

I'm trying to connect to my Access 2K Database using Native OLEDB, but I receive the following error as a result of my useless code:

[tt]Microsoft JET Database Engine error '80004005'

Couldn't find installable ISAM.[/tt]

Following is my code (I suspect the SystemDB bit is the problem, but I can't find the solution anywhere):

[tt]<p>Fourth - Native OLEDBProvider<br>
<%
Dim oConn4
Dim oRS4
Dim vP 'Provider String
Set oConn4=Server.CreateObject(&quot;ADODB.Connection&quot
Set oRS4=Server.CreateObject(&quot;ADODB.Recordset&quot

vP = &quot;Provider=Microsoft.Jet.OLEDB.3.51; &quot;
vP = vP &amp; &quot;Data Source=C:\Inetpub\

http://wwwroot\Fairmont\db\fairprod.mdb;

&quot;
vP = vP &amp; &quot;SystemDB=C:\Inetpub\wwwroot\Fairmont\db\system.mdw; Userid=User; pwd=&quot;
oConn4.ConnectionString = vP
oConn4.Open
Response.Write oConn4.Provider

oRS4.ActiveConnection = oConn4
oRS4.Open strSQL
Response.Write &quot;<TABLE BORDER=1><TR><TD>&quot;
Response.Write oRS4.GetString(,-1,vCol,vRow,&quot;&amp;nbsp;&quot
Response.Write &quot;</TD></TR></TABLE>&quot;
oRS4.Close
Set oRS4=Nothing
oConn4.Close
Set oConn4=Nothing
%>[/tt]


Ahdkaw
&quot;What would you expect from a bunch of monkeys?&quot;

http://www.sensibilium.com

 

[Sensibilium]

Please Note: strSQL, vCol, and vRow in the code above are setup earlier in the code (not shown). Ahdkaw
&quot;What would you expect from a bunch of monkeys?&quot;

http://www.sensibilium.com

 

[Sensibilium]

I have changed the connection string above with the following code:

[tt]vP = &quot;Provider=Microsoft.Jet.OLEDB.4.0; &quot;
vP = vP &amp; &quot;Data Source=C:\Inetpub\

http://wwwroot\Fairmont\db\fairprod.mdb;

&quot;
vP = vP &amp; &quot;SystemDB=C:\Inetpub\

http://wwwroot\Fairmont\db\system.mdw;

User id=User; Password=&quot;[/tt]

But now I receive the following instead:

[tt]Microsoft JET Database Engine error '80040e4d'

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.[/tt]

The system DB exists in it's location as other types of connections work... Ahdkaw
&quot;What would you expect from a bunch of monkeys?&quot;

http://www.sensibilium.com