|
 |
asp_web_howto thread: Problem with connecting a database on the- network.
Message #1 by "Li Wu" <liwu@g...> on Tue, 27 Feb 2001 13:04:10 -0500
|
|
Hi all,
I created the web pages to get the data from a database through the
Intranet. The client browser can get the data if the database is stored on
the web server. But if the database is moved to a data server in the
network, I got an error message: "The Microsoft Jet database engine connot
open the file 'L:\mydatabase.cal'. It is already opened exclusively by
another user, or you need permission to view its data". But I can open
this remote database and get the data in VB using same ADO code.
So my question is why the same ADO code I used in my asp files only works
if the database is stored on the web server but the same ADO code works in
VB regardless where to store the database?
The database we used is a kind of Access database.
Thanks in advance!
Li
Message #2 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Wed, 28 Feb 2001 17:13:52 -0000
|
|
in the DSN, try using a UNC path rather than a mapped drive
-----Original Message-----
From: Li Wu [mailto:liwu@g...]
Sent: Tuesday, February 27, 2001 6:04 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Problem with connecting a database on the
network.
Hi all,
I created the web pages to get the data from a database through the
Intranet. The client browser can get the data if the database is stored on
the web server. But if the database is moved to a data server in the
network, I got an error message: "The Microsoft Jet database engine connot
open the file 'L:\mydatabase.cal'. It is already opened exclusively by
another user, or you need permission to view its data". But I can open this
remote database and get the data in VB using same ADO code.
So my question is why the same ADO code I used in my asp files only works if
the database is stored on the web server but the same ADO code works in VB
regardless where to store the database?
The database we used is a kind of Access database.
Thanks in advance!
Li
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
Message #3 by "Drew, Ron" <RDrew@B...> on Wed, 28 Feb 2001 16:18:13 -0500
|
|
I sometimes use Access and I am on Windows 2000. SQL 7.0 is alot better for
many reasons. Back to your question. If you are using Windows 2000, open
the database and do a TOOLS,OPTIONS and I believe on the Advanced tab is
where you use a radio button to indicate the database will be opened in a
shared mode. Again, not sure this is your problem.
-----Original Message-----
From: Li Wu [mailto:liwu@g...]
Sent: Tuesday, February 27, 2001 1:04 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Problem with connecting a database on the
network.
Hi all,
I created the web pages to get the data from a database through the
Intranet. The client browser can get the data if the database is stored on
the web server. But if the database is moved to a data server in the
network, I got an error message: "The Microsoft Jet database engine connot
open the file 'L:\mydatabase.cal'. It is already opened exclusively by
another user, or you need permission to view its data". But I can open this
remote database and get the data in VB using same ADO code.
So my question is why the same ADO code I used in my asp files only works if
the database is stored on the web server but the same ADO code works in VB
regardless where to store the database?
The database we used is a kind of Access database.
Thanks in advance!
Li
|
|
|
View Cart
