|
 |
aspx_beginners thread: dsn on the network
Message #1 by "Tareq A. Abdeen" <tabdeen@c...> on Thu, 21 Feb 2002 15:12:03 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0018_01C1BAEA.1E3E5680
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I have built a site with the web server the and dsn on the my
production machine.
That was fun!!!
I have moved my web templates to our web server.
and the access database data source to the database server.
i am not having fun at all now ..
What is the procedure to make the site work with a dsn accross the
network?
thank you very much .. mercy boco ... mui gracias ..
Regards
Tareq
Message #2 by "ajit goel" <ajitgoel@h...> on Thu, 21 Feb 2002 17:57:44 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00FB_01C1BB01.43646960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message
Create the dsn on the web server which will point to the database
server.The web server should have network connectivity to the database
server.
Regards;
Ajit Goel
----- Original Message -----
From: Tareq A. Abdeen
To: aspx_beginners
Sent: Thursday, February 21, 2002 12:12 PM
Subject: [aspx_beginners] dsn on the network
Hi,
I have built a site with the web server the and dsn on the my
production machine.
That was fun!!!
I have moved my web templates to our web server.
and the access database data source to the database server.
i am not having fun at all now ..
What is the procedure to make the site work with a dsn accross the
network?
thank you very much .. mercy boco ... mui gracias ..
Regards
Tareq
$subst('Email.Unsub').
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 22 Feb 2002 14:05:35 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tareq A. Abdeen" <tabdeen@c...>
Subject: [aspx_beginners] dsn on the network
: I have moved my web templates to our web server.
: and the access database data source to the database server.
:
: i am not having fun at all now ..
:
: What is the procedure to make the site work with a dsn accross the
: network?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If the IIS machine isn't a Windows Domain Controller, then the default
anonymous internet user account (IUSR_<machinename>) is a local account and
doesn't have permission to remote resources (eg an Access database located
on a file share on another machine.
Probably the quickest way to get this to work would be to change the
anonymous internet user account to be a domain account. Give this domain
account appropriate permissions to the remote access database (eg the file
share).
In the DSN use UNC paths to reference the remote share since using mapped
drive letters are only mapped for the logged on user, not all users.
Cheers
Ken
|
|
 |