|
 |
access_asp thread: MDB in one server and ASP at other
Message #1 by ademirk@n... on Tue, 20 Nov 2001 02:01:19
|
|
Hi,
I'm having a problem to connect to a MDB in a network File Server (AD),
because the webserver (that running ASP and have internet access) is
another machine, member server only.
Anyone have this running? How I do that?
I just try to use ODBC, putting usernames of many people, including
administrator, an it doesn't work.
Ademir Klauck
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 20 Nov 2001 15:37:59 +1100
|
|
The account that is being used for anonymous access (IUSR_Machinename)
probably doesn't have access to the remote machine.
Additionally, you can't assign permission for this account to the remote
machine because it is a local account.
Lastly, if you are trying to use a mapped drive letter, that wont work
either, because drive letters are mapped for the logged on user only (and
you didn't logon as IUSR_<machinename> to map the letter).
So, I suggest that you change the anonymous user to a domain account, and
give that account permission to the remote share, and connect like so:
Data Source=\\Dbserver\share\db1.mdb
Altertively, create an account on the DB server that has the same
username/password as the anonymous internet user account on the web server,
and give that account permissions to the share.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <ademirk@n...>
Subject: [access_asp] MDB in one server and ASP at other
: Hi,
:
: I'm having a problem to connect to a MDB in a network File Server (AD),
: because the webserver (that running ASP and have internet access) is
: another machine, member server only.
:
: Anyone have this running? How I do that?
: I just try to use ODBC, putting usernames of many people, including
: administrator, an it doesn't work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "sathish r" <sathish297@y...> on Tue, 20 Nov 2001 12:50:08 +0530
|
|
----- Original Message -----
From: "Ken Schaefer" <ken@a...>
To: "Access ASP" <access_asp@p...>
Sent: Tuesday, November 20, 2001 10:07 AM
Subject: [access_asp] Re: MDB in one server and ASP at other
> The account that is being used for anonymous access (IUSR_Machinename)
> probably doesn't have access to the remote machine.
>
> Additionally, you can't assign permission for this account to the remote
> machine because it is a local account.
>
> Lastly, if you are trying to use a mapped drive letter, that wont work
> either, because drive letters are mapped for the logged on user only (and
> you didn't logon as IUSR_<machinename> to map the letter).
>
> So, I suggest that you change the anonymous user to a domain account, and
> give that account permission to the remote share, and connect like so:
> Data Source=\\Dbserver\share\db1.mdb
>
> Altertively, create an account on the DB server that has the same
> username/password as the anonymous internet user account on the web
server,
> and give that account permissions to the share.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: <ademirk@n...>
> Subject: [access_asp] MDB in one server and ASP at other
>
>
> : Hi,
> :
> : I'm having a problem to connect to a MDB in a network File Server (AD),
> : because the webserver (that running ASP and have internet access) is
> : another machine, member server only.
> :
> : Anyone have this running? How I do that?
> : I just try to use ODBC, putting usernames of many people, including
> : administrator, an it doesn't work.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
|
|
|
View Cart
