|
 |
aspx thread: How to connect to MS Access 2000 database (over a LAN) using .NET code?
Message #1 by "David FAROI" <david.faroi@a...> on Wed, 1 Aug 2001 08:53:52
|
|
I'm a french .net beginner.
Your help will be very appreciate.
I would like to make an oledb connection to an Access 2000 database which
is store on an other server on my office LAN.
I tried the following connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=admin;Data
Source=Y:\sav-ms.mdb;"
Where Y is a map drive to my server over my LAN
I received the following error message:
"Y:\sav-ms.mdb' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which the
file resides".
Maybe the above provider do not allow access to network resource?
I knew the MDASQL is not supported by .Net.
How could I do this connection ? Which provider to use ?
Message #2 by "Mohit Navare (CTS)" <MohitN@p...> on Wed, 1 Aug 2001 13:53:34 +0530
|
|
Probably try giving the data source as : "Y:\\sav-ms.mdb;"
Mohit Navare
Cognizant Tech Solns
Pune.
India.
-----Original Message-----
From: David FAROI [mailto:david.faroi@a...]
Sent: Wednesday, August 01, 2001 2:24 PM
To: ASP+
Subject: [aspx] How to connect to MS Access 2000 database (over a LAN)
using .NET code?
I'm a french .net beginner.
Your help will be very appreciate.
I would like to make an oledb connection to an Access 2000 database which
is store on an other server on my office LAN.
I tried the following connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=admin;Data
Source=Y:\sav-ms.mdb;"
Where Y is a map drive to my server over my LAN
I received the following error message:
"Y:\sav-ms.mdb' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which the
file resides".
Maybe the above provider do not allow access to network resource?
I knew the MDASQL is not supported by .Net.
How could I do this connection ? Which provider to use ?
---
Message #3 by "FAROI, David" <David.FAROI@A...> on Wed, 1 Aug 2001 10:45:48 +0200
|
|
I tried but I still received the same error message
-----Original Message-----
From: Mohit Navare (CTS) [mailto:MohitN@p...]
Sent: mercredi 1 ao=FBt 2001 10:24
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
Probably try giving the data source as : "Y:\\sav-ms.mdb;"
Mohit Navare
Cognizant Tech Solns
Pune.
India.
-----Original Message-----
From: David FAROI [mailto:david.faroi@a...]
Sent: Wednesday, August 01, 2001 2:24 PM
To: ASP+
Subject: [aspx] How to connect to MS Access 2000 database (over a LAN)
using .NET code?
I'm a french .net beginner.
Your help will be very appreciate.
I would like to make an oledb connection to an Access 2000 database
which
is store on an other server on my office LAN.
I tried the following connection string:
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Password=3D;User ID=3Dadmin;Data
Source=3DY:\sav-ms.mdb;"
Where Y is a map drive to my server over my LAN
=09
I received the following error message:
"Y:\sav-ms.mdb' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which the
file resides".
Maybe the above provider do not allow access to network resource?
I knew the MDASQL is not supported by .Net.
How could I do this connection ? Which provider to use ?
Message #4 by "Joe Fawcett" <joefawcett@h...> on Wed, 01 Aug 2001 12:37:08 +0100
|
|
Your IIS server needs to have a Y: drive. (Rather than your workstation
having one). This must be to a WinNT machine, if both of these are true let me know and we'll dig deeper.
Regards
Joe Fawcett
>From: "FAROI, David" <David.FAROI@A...>
>Reply-To: "ASP+" <aspx@p...>
>To: "ASP+" <aspx@p...>
>Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
>using .NET code?
>Date: Wed, 1 Aug 2001 10:45:48 +0200
>
>I tried but I still received the same error message
>
>-----Original Message-----
>From: Mohit Navare (CTS) [mailto:MohitN@p...]
>Sent: mercredi 1 août 2001 10:24
>To: ASP+
>Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
>LAN) using .NET code?
>
>
>Probably try giving the data source as : "Y:\\sav-ms.mdb;"
>
>
> Mohit Navare
> Cognizant Tech Solns
> Pune.
> India.
>
>
>-----Original Message-----
>From: David FAROI [mailto:david.faroi@a...]
>Sent: Wednesday, August 01, 2001 2:24 PM
>To: ASP+
>Subject: [aspx] How to connect to MS Access 2000 database (over a LAN)
>using .NET code?
>
>
>I'm a french .net beginner.
>Your help will be very appreciate.
>
>I would like to make an oledb connection to an Access 2000 database which
>is store on an other server on my office LAN.
>I tried the following connection string:
>
>"Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=admin;Data
>Source=Y:\sav-ms.mdb;"
>Where Y is a map drive to my server over my LAN
>
>I received the following error message:
>
>"Y:\sav-ms.mdb' is not a valid path. Make sure that the path name is
>spelled correctly and that you are connected to the server on which the
>file resides".
>
>Maybe the above provider do not allow access to network resource?
>I knew the MDASQL is not supported by .Net.
>
>How could I do this connection ? Which provider to use ?
Message #5 by "FAROI, David" <David.FAROI@A...> on Fri, 3 Aug 2001 10:28:15 +0200
|
|
Both of these are already true.
Does anybody already meet this problem and find a solution ?
Maybe I can link my Access tables to a SQL Database!!!!
I tried this solution but when I udpate/add a record in my Access
Database Table, the corresponding SQL Database table was not update at the
same time.
I have to open Access and use the "Link Table Manager" to update SQL
Database Table.
If my SQL database can be update at the same time and vice versa, this will
be a solution to prevent errors when trying to connect my Access Database
over the network.
Thanks for your help.
David FAROI
-----Original Message-----
From: Joe Fawcett [mailto:joefawcett@h...]
Sent: mercredi 1 ao=FBt 2001 13:37
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
Your IIS server needs to have a Y: drive. (Rather than your workstation
having one). This must be to a WinNT machine, if both of these are true let
me know and we'll dig deeper.
Regards
Joe Fawcett
>From: "FAROI, David" <David.FAROI@A...>
>Reply-To: "ASP+" <aspx@p...>
>To: "ASP+" <aspx@p...>
>Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
>using .NET code?
>Date: Wed, 1 Aug 2001 10:45:48 +0200
>
>I tried but I still received the same error message
>
>-----Original Message-----
>From: Mohit Navare (CTS) [mailto:MohitN@p...]
>Sent: mercredi 1 ao=FBt 2001 10:24
>To: ASP+
>Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
>LAN) using .NET code?
>
>
>Probably try giving the data source as : "Y:\\sav-ms.mdb;"
>
>
> Mohit Navare
> Cognizant Tech Solns
> Pune.
> India.
>
>
>-----Original Message-----
>From: David FAROI [mailto:david.faroi@a...]
>Sent: Wednesday, August 01, 2001 2:24 PM
>To: ASP+
>Subject: [aspx] How to connect to MS Access 2000 database (over a LAN)
>using .NET code?
>
>
>I'm a french .net beginner.
>Your help will be very appreciate.
>
>I would like to make an oledb connection to an Access 2000 database
which
>is store on an other server on my office LAN.
>I tried the following connection string:
>
>"Provider=3DMicrosoft.Jet.OLEDB.4.0;Password=3D;User ID=3Dadmin;Data
>Source=3DY:\sav-ms.mdb;"
>Where Y is a map drive to my server over my LAN
>
>I received the following error message:
>
>"Y:\sav-ms.mdb' is not a valid path. Make sure that the path name is
>spelled correctly and that you are connected to the server on which
the
>file resides".
>
>Maybe the above provider do not allow access to network resource?
>I knew the MDASQL is not supported by .Net.
>
>How could I do this connection ? Which provider to use ?
Message #6 by "dave 123aspx.com" <support@1...> on Fri, 3 Aug 2001 14:15:07 -0500
|
|
actually, "Y" drives have nothing to do with this, as a mapped drive is
specific to the logged in user.
you need to access your database through an UNC path such as
\\servername\sharename
however, make sure that the account (typically IUSR_SERVERNAME ) the website
is running under also has access to that share or else you won't get
anywhere.
Cheers!
dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.123aspx.com
The Largest ASP.NET Web Directory!
Find the latest ASP.NET resources --
Subscribe to our newsletter!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Joe Fawcett" <joefawcett@h...>
To: "ASP+" <aspx@p...>
Sent: Wednesday, August 01, 2001 6:37 AM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
using .NET code?
> Your IIS server needs to have a Y: drive. (Rather than your workstation
> having one). This must be to a WinNT machine, if both of these are true
let me know and we'll dig deeper.
>
> Regards
>
> Joe Fawcett
>
>
>
>
Message #7 by "Joe Fawcett" <joe@r...> on Sat, 4 Aug 2001 11:21:35 +0100
|
|
No, the questioner stated that the Y: drive is visible to the server, i.e.
mapped on the server itself. The point is the IUSR_ account may not have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> http://www.123aspx.com
> The Largest ASP.NET Web Directory!
> Find the latest ASP.NET resources --
> Subscribe to our newsletter!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
> using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your workstation
> > having one). This must be to a WinNT machine, if both of these are true
> let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
> >
> >
Message #8 by "FAROI, David" <David.FAROI@A...> on Mon, 6 Aug 2001 09:24:49 +0200
|
|
I checked that the IUSR_account have admin rights on my server.
I get back the sames error message "'Y:\Base Sav\sav.mdb' is not a
valid
path. Make sure that the path name is spelled correctly and that you
are
connected to the server on which the file resides".
I think the Microsoft Provider "Microsoft.Jet.OLEDB.4.0" is not able to
browse the network.
Maybe Can I try an other oledb provider to access to my access
database?
Thanks for help.
David.
-----Original Message-----
From: Joe Fawcett [mailto:joe@r...]
Sent: samedi 4 ao=FBt 2001 12:22
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
No, the questioner stated that the Y: drive is visible to the server,
i.e.
mapped on the server itself. The point is the IUSR_ account may not
have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN)
using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive
is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> http://www.123aspx.com
> The Largest ASP.NET Web Directory!
> Find the latest ASP.NET resources --
> Subscribe to our newsletter!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN)
> using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your
workstation
> > having one). This must be to a WinNT machine, if both of these are
true
> let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
Message #9 by "FAROI, David" <David.FAROI@A...> on Mon, 6 Aug 2001 09:33:37 +0200
|
|
When I use the following connection string:
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D\\172.31.100.93\Base
Sav\sav.mdb;User ID=3Dadmin;"
The error message below was return by IE:
"The Microsoft Jet database engine cannot open the file
'\\172.31.100.93\Base Sav\sav.mdb'. It is already opened exclusively by
another user, or you need permission to view its data".
Any idea
david
-----Original Message-----
From: Joe Fawcett [mailto:joe@r...]
Sent: samedi 4 ao=FBt 2001 12:22
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
No, the questioner stated that the Y: drive is visible to the server,
i.e.
mapped on the server itself. The point is the IUSR_ account may not
have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN)
using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive
is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> http://www.123aspx.com
> The Largest ASP.NET Web Directory!
> Find the latest ASP.NET resources --
> Subscribe to our newsletter!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN)
> using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your
workstation
> > having one). This must be to a WinNT machine, if both of these are
true
> let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
Message #10 by Wim Hollebrandse <Wim.Hollebrandse@c...> on Mon, 6 Aug 2001 10:27:37 +0100
|
|
That means it can find the MDB now - so you're on the right track. You have
to make sure that you don't have the DB open in Access, since that will
open the database exclusively, hence the error.
-----Original Message-----
From: FAROI, David [mailto:David.FAROI@A...]
Sent: 06 August 2001 08:34
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
When I use the following connection string:
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D\\172.31.100.93\Base
Sav\sav.mdb;User ID=3Dadmin;"
The error message below was return by IE:
"The Microsoft Jet database engine cannot open the file
'\\172.31.100.93\Base Sav\sav.mdb'. It is already opened exclusively by
another user, or you need permission to view its data".
Any idea
david
-----Original Message-----
From: Joe Fawcett [mailto:joe@r...]
Sent: samedi 4 ao=FBt 2001 12:22
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
No, the questioner stated that the Y: drive is visible to the server, i.e.
mapped on the server itself. The point is the IUSR_ account may not have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> http://www.123aspx.com
> The Largest ASP.NET Web Directory!
> Find the latest ASP.NET resources --
> Subscribe to our newsletter!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN)
> using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your
workstation
> > having one). This must be to a WinNT machine, if both of these are
true
> let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
Message #11 by "FAROI, David" <David.FAROI@A...> on Mon, 6 Aug 2001 11:27:39 +0200
|
|
Everybody, today is my last message because I found solution to resolve my
problem.
I just modified the "TMP" and "TEMP" value to this (C:\TEMP) on the Windows
Environment Variables.
After I reboot my server, I give to IUSR_account all rights to these folders.
Now it works fine.
I would like to thank all people who help me.
I hope I will be able to help someone on this site.
Thanks a lot again.
David FAROI
-----Original Message-----
From: Joe Fawcett [mailto:joe@r...]
Sent: samedi 4 ao=FBt 2001 12:22
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
No, the questioner stated that the Y: drive is visible to the server, i.e.
mapped on the server itself. The point is the IUSR_ account may not have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN)
using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> http://www.123aspx.com
> The Largest ASP.NET Web Directory!
> Find the latest ASP.NET resources --
> Subscribe to our newsletter!
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a LAN) using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your workstation
> > having one). This must be to a WinNT machine, if both of these are true
> > let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
Message #12 by "FAROI, David" <David.FAROI@A...> on Mon, 6 Aug 2001 11:58:06 +0200
|
|
Although my database is close I've got the same error.
As I said in my last message, I found the solution.
Thanks for your help
David
-----Original Message-----
From: Wim Hollebrandse [mailto:Wim.Hollebrandse@c...]
Sent: lundi 6 ao=FBt 2001 11:28
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
That means it can find the MDB now - so you're on the right track. You have
to make sure that you don't have the DB open in Access, since that will
open the database exclusively, hence the error.
-----Original Message-----
From: FAROI, David [mailto:David.FAROI@A...]
Sent: 06 August 2001 08:34
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
When I use the following connection string:
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D\\172.31.100.93\Base
Sav\sav.mdb;User ID=3Dadmin;"
The error message below was return by IE:
"The Microsoft Jet database engine cannot open the file
'\\172.31.100.93\Base Sav\sav.mdb'. It is already opened exclusively by
another user, or you need permission to view its data".
Any idea
david
-----Original Message-----
From: Joe Fawcett [mailto:joe@r...]
Sent: samedi 4 ao=FBt 2001 12:22
To: ASP+
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
No, the questioner stated that the Y: drive is visible to the server, i.e.
mapped on the server itself. The point is the IUSR_ account may not have
access to this mapped drive...
Joe
----- Original Message -----
From: "dave 123aspx.com" <support@1...>
To: "ASP+" <aspx@p...>
Sent: Friday, August 03, 2001 8:15 PM
Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
> actually, "Y" drives have nothing to do with this, as a mapped drive is
> specific to the logged in user.
>
> you need to access your database through an UNC path such as
> \\servername\sharename
>
> however, make sure that the account (typically IUSR_SERVERNAME ) the
website
> is running under also has access to that share or else you won't get
> anywhere.
>
> Cheers!
> dave
>
> ----- Original Message -----
> From: "Joe Fawcett" <joefawcett@h...>
> To: "ASP+" <aspx@p...>
> Sent: Wednesday, August 01, 2001 6:37 AM
> Subject: [aspx] RE: How to connect to MS Access 2000 database (over a
LAN) using .NET code?
>
>
> > Your IIS server needs to have a Y: drive. (Rather than your workstation
> > having one). This must be to a WinNT machine, if both of these are true
> > let me know and we'll dig deeper.
> >
> > Regards
> >
> > Joe Fawcett
|
|
|
View Cart
