Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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




  Return to Index