Hi

I am trying to connect remote access 97 database form ASP.NET page from vb.net using this connection string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\cdrive\Dt\ct\ct.mdb;
I get this erro
"The Microsoft Jet database engine cannot open the file '\\ServerName\cdrive\Dt\ct\ct.mdb' It is already opened exclusively by another user, or you need permission to view its data

If I use with null pwd
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\cdrive\Dt\ct\ct.mdb;PWD=
I get this error "Could not find installable ISAM.

Some one please help
Thank
ashra

Try chaning ...Jet.OLEDB.4.0 to 3.51 - If you don't have
Office97 loaded on the computer, you may not have Jet
3.51, but Access97 uses Jet 3.51, could use 4.0 if you
load Mdac2.5 (obtainable at msdn.microsoft.com - or used
to be)

Rich


>-----Original Message-----
>Hi,
>
>I am trying to connect remote access 97 database form
ASP.NET page from vb.net using this connection string:
>"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\ServerName\cdrive\Dt\ct\ct.mdb;"
>I get this error
>"The Microsoft Jet database engine cannot open the
file '\\ServerName\cdrive\Dt\ct\ct.mdb' It is already
opened exclusively by another user, or you need permission
to view its data.
>
>If I use with null pwd:
>"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\ServerName\cdrive\Dt\ct\ct.mdb;PWD="
>I get this error "Could not find installable ISAM."
>
>Some one please help,
>Thanks
>ashraf
>
>
>.
>

Thanks for the reply. I tested with 3.51 but no luck. I get the same exact error. I do have mdac 2.5 installed on this machine

* =?Utf-8?B?YXNocmFm?= <(E-Mail Removed)> scripsit:
> I am trying to connect remote access 97 database form ASP.NET page from vb.net using this connection string:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\cdrive\Dt\ct\ct.mdb;"
> I get this error
> "The Microsoft Jet database engine cannot open the file '\\ServerName\cdrive\Dt\ct\ct.mdb' It is already opened exclusively by another user, or you need permission to view its data.
>
> If I use with null pwd:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\cdrive\Dt\ct\ct.mdb;PWD="
> I get this error "Could not find installable ISAM."

Are you sure, MDAC are installed?

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>
Website Address Changed!

Yes. Absolutely. There are other VB applications running on this which are using MADC 2.5.

Thanks for the reply.

Try connect locally.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Dt\ct\ct.mdb;"

Because if you have in another computer, the server search local. or use a
map drive in the server.


"ashraf" <(E-Mail Removed)> escreveu na mensagem
news:93409425-3651-4AB7-A992-(E-Mail Removed)...
> Hi,
>
> I am trying to connect remote access 97 database form ASP.NET page from
vb.net using this connection string:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\ServerName\cdrive\Dt\ct\ct.mdb;"
> I get this error
> "The Microsoft Jet database engine cannot open the file
'\\ServerName\cdrive\Dt\ct\ct.mdb' It is already opened exclusively by
another user, or you need permission to view its data.
>
> If I use with null pwd:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\ServerName\cdrive\Dt\ct\ct.mdb;PWD="
> I get this error "Could not find installable ISAM."
>
> Some one please help,
> Thanks
> ashraf
>
>

Thanks for the reply, I have no problem opening a local Access database or databse located on other server with maped drive. But I have to open remote database as there are numerous databses located on several servers and mapping their drives is not a practical option.
Thanks again

Ashraf.