Q:
What is the best way to access an SQL server within a CGI script?
I am running Perl 5 on a Red Hat Linux 7.2 server trying to access a MS
SQL database on a Windows NT 4.0 Server.
Thanks for your help, and for making yourself available for these kinds of
questions.
*NAME-DELETED*
A:
I recommend that you use the DBI module and ODBC.
Regards,
Peter
Q:
I have been trying to get my server to connect to the SQL Database for a
few days now using these modules. Do you know the best way to set these up
and also the best way to test the connection. From the documentation I am
lookig at it seems like I need to install an iODBC driver manager as well
and it seems like OpenLink (www.iodbc.org) is the one that people are
using. I am just having a hard time understanding how they all work
together.
Thanks so much for your help.
*NAME-DELETED*
A:
Sorry *NAME-DELETED*,
but I have no direct experience with ODBC on UNIX. I only used ODBC on
Windows NT.
Regards,
Peter
[ back to toc ]