Re: [OT] ODBC between IIS and remote Access problem

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 27517
interpreted = N
texte = Nicolas - This is typically caused by a rights issue between the user running the Perlscript locally to the web server and the much more limited rights typicallygranted to the web server account (typically SYSTEM).Be sure that you are using a System Datasource, not a User Datasource. Makesure that the web server user has rights to the remote drive where the Accessdatabase is located. All Access files operate via a shared file motif; there isno server process to manage the file access.It is frequently easier to move the physical file to the web server machine andthen have any remote users drive map that directory, rather than the other wayaround. It is much easier to stomach creating a public drive share on the webserver than to give the web server access to internal resources. Make sure youblock UDP ports 137-138 in your firewall, so that people outside your networkcannot see the public shares (although they would still need to log in to accessthem).You can also easily webify the perl script so that you can run it as a CGI; Ibet it will not operate when run as the lower security web user.Hope this helpsJohn Peacock____________________Reply Separator____________________Subject: [OT] ODBC between IIS and remote Access problem Author: (WebCatalog Talk)Date: 2/14/00 12:52 PMHas anybody been able to find how to solve the problem when trying toconnect to a remote Access database via ODBC on IIS?Although a Perl script will access the database, no CGI script on IIS would.I cannot find anything related to any solution on Microsoft.com ...-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Associated Messages, from the most recent to the oldest:

Re: [OT] ODBC between IIS and remote Access problem (jpeacock@univpress.com 2000)

Nicolas - This is typically caused by a rights issue between the user running the Perlscript locally to the web server and the much more limited rights typicallygranted to the web server account (typically SYSTEM).Be sure that you are using a System Datasource, not a User Datasource. Makesure that the web server user has rights to the remote drive where the Accessdatabase is located. All Access files operate via a shared file motif; there isno server process to manage the file access.It is frequently easier to move the physical file to the web server machine andthen have any remote users drive map that directory, rather than the other wayaround. It is much easier to stomach creating a public drive share on the webserver than to give the web server access to internal resources. Make sure youblock UDP ports 137-138 in your firewall, so that people outside your networkcannot see the public shares (although they would still need to log in to accessthem).You can also easily webify the perl script so that you can run it as a CGI; Ibet it will not operate when run as the lower security web user.Hope this helpsJohn Peacock____________________Reply Separator____________________Subject: [OT] ODBC between IIS and remote Access problem Author: (WebCatalog Talk)Date: 2/14/00 12:52 PMHas anybody been able to find how to solve the problem when trying toconnect to a remote Access database via ODBC on IIS?Although a Perl script will access the database, no CGI script on IIS would.I cannot find anything related to any solution on Microsoft.com ...-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  jpeacock@univpress.com

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebCat2 several catalogs? (1997) Searching for the end (1998) repost: sending a down arrow (2000) Trigger: executes every N days (2001) ShowNext (1997) More on the email templates (1997) Lookup Notfound (1998) [WebDNA] Test (2011) Javascript/WebCatalog form population (2001) Add command creates new cart but I'm passing existing cart...? (2000) serial number dishing (1997) [WebDNA] webdna site down? (2011) NT vs Mac (1997) 3 card formulas! (1999) No comment (1997) Hard Questions ? (1997) RE: Ongoing group search problems ... (1997) Help! WebCat2 bug (1997) Problems with command=replace in realm (2000) [OT] Redhat 6.1 (2003)