speaking to MS SQL Server using the ODBC module
chris at velocigen.com
Tue Feb 6 12:10:54 CST 2001
Chuck Phillips wrote:
> I'm curious about the ODBC module on CPAN. Can I just get that
> working on our Solaris Servers and then make calls to the MS SQL
> server? Has anyone had any experience with a similar setup? Is the
> ODBC module a pain to install? (I was playing with it on an BSD
> machine and the make died.)
Unfortunately, it's not that easy. The ODBC module relies on the server
having ODBC drivers installed, so you'll need to get an ODBC manager for
Solaris and install it before you make the Perl module.
Several companies make ODBC managers and drivers for Solaris, but I
don't remember any offhand.
Alternately, you can use DBD::Proxy on the Solaris box and run a
DBI::Proxy server on the Windows NT machine. The proxy server will
connect to MS-SQL via ODBC, and then the Solaris box can connect to it.
It's a little more overhead, but nothing really noticeable.
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:
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