connecting remore access 97 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
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
Click to expand...
file '\\ServerName\cdrive\Dt\ct\ct.mdb' It is already
opened exclusively by another user, or you need permission
to view its data.
 
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?= said:
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."
Click to expand...

Are you sure, MDAC are installed?
 
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 said:
Hi,

I am trying to connect remote access 97 database form ASP.NET page from
Click to expand...
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
Click to expand...
'\\ServerName\cdrive\Dt\ct\ct.mdb' It is already opened exclusively by
another user, or you need permission to view its data.
 
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.
 
Back
Top