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:

WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Nested tags count question (1997) Further on formula.db failure to calculate shipCost (1997) Shopping Cart Directory (2000) Banners and sort of random display (1997) [PROTECT] Problem (2003) RE: Credit card processing - UK (1997) Is there an alternative to emailer? (1999) test (2003) Bug? (1997) Running 2 two WebCatalog.acgi's (1996) Problem with HTML email (2003) Get current URL with Variables (2005) WebCatalog for guestbook ? (1997) Re:E-Mailer (WebCatb15acgiMac) (1997) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) Test! (2003) SetHeader (1997) is there a [purchase]? (1998) ShippingCosts (1998)