speaking to MS SQL Server using the ODBC module

[Chris Radcliff]

~sdpm~


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.

~chris

~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.