>I hope this is not a stupid question..
>I have some perl CGI scripts I wrote that are used on an NT based >front
page
>web server. These
>scripts use the Win32::ODBC functionality to manipulate an Access >database
>(Add, Retrieve, and
>delete data from some tables).
This is not possible. There is no access-compabitble database on UNIX. To
use ODBC you must have a database server running on UNIX that support ODBC
and know the ACCESS file structure.
> What I want to do is place these Access
>databases on a Unix file
>server and do the same thing from an apache based server on that >machine
>thus removing the NT
>system from the picture entirely. Can a unix based perl script use >SQL
calls
>to interact with an Access
>database residing on a Unix file system?
No. You must have an Access ODBC compatible server for UNIX. As far as I
know, it doesn't excist.
> The databases must still be
>readable to some NT workstations
>so switching to a different database is not an option.
I suggest you switch to postgresql. There is an ODBC driver for this
database, and it is fast. You can migrate your data to access with some
tools.
> The NT >workstations
>currently use Samba to access
>some other databases residing on the machine I want to migrate the >web
stuff
>to. Basically, I want to eliminate the resource-hogging
performance->lacking
>IIS web server.
>Thanks in advance,
>CC
Igmar
--
PLEASE read the Red Hat FAQ, Tips, Errata and the MAILING LIST ARCHIVES!
http://www.redhat.com/RedHat-FAQ /RedHat-Errata /RedHat-Tips /mailing-lists
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject.
