perl & ms access with liniked tables

Michael DeVicariis webtemp at ucsd-pps.ucsd.edu
Fri Sep 15 12:36:00 CDT 2000


~sdpm~
I have an MS Access database on our network.  I'm trying to query this
database and display the results on the web.  This query is run (via SQL) in
a perl/cgi script.

I currently have it setup with a local MS Access db with linked tables the
source db on the network.  I'm using perl and win32 ODBC to access the local
db which in turn redirects the query to the source db.

The problem is when I run the perl script I get the following error message:
---> Error: -1022[Microsoft][ODBC Microsoft Access 97 Driver] Disk or
network error.10

When I run the same script from the command line, I get the correct results.


Any help would be appreciated,
TIA


Michael DeVicariis
Web Administrator/Developer
Programmer/Analyst
UCSD Auxiliary & Plant Services
(858) 534-0700



~sdpm~

The posting address is: san-diego-pm-list at hfb.pm.org

List requests should be sent to: majordomo at hfb.pm.org

If you ever want to remove yourself from this mailing list,
you can send mail to <majordomo at happyfunball.pm.org> with the following
command in the body of your email message:

    unsubscribe san-diego-pm-list

If you ever need to get in contact with the owner of the list,
(if you have trouble unsubscribing, or have questions about the
list itself) send email to <owner-san-diego-pm-list at happyfunball.pm.org> .
This is the general rule for most mailing lists when you need
to contact a human.




More information about the San-Diego-pm mailing list