connecting remore access 97 database

[Guest]

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

 

[Rich]

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.

 

[Guest]

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

 

[Herfried K. Wagner [MVP]]

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?

 

[Guest]

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

Thanks for the reply.

 

[nTn]

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.

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.

 

[Guest]

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.