[URGENT] Unix perl script to connect to MS SQL Server 6.5

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: [det-URGENT] Unix perl script to connect to MS SQL Server 6.5 by toolic (Bishop) on Jul 07, 2011 at 15:04 UTC
It looks like you need to install DBD::ODBC. There is no indication from what you have posted that it is installed. None of those .pm files you show match `DBD/ODBC.pm` I linkified your url: How do I connect to Microsoft SQL server 6.5?	[reply] [d/l]
Re: [URGENT] Unix perl script to connect to MS SQL Server 6.5 by mje (Curate) on Jul 08, 2011 at 08:13 UTC
You appear to have WIN32::ODBC installed but not DBD::ODBC. They are not the same. BTW, I doubt you need to use DBD::ODBC. Also, whether you can define Driver as "SQL Server" will depend on whether you have actually installed an ODBC driver called "SQL Server" - if you haven't installing DBD::ODBC is not going to make a difference i.e., you need to install an ODBC driver for SQL Server in addition to DBD::ODBC.	[reply]
Re: [URGENT] Unix perl script to connect to MS SQL Server 6.5 by tokpela (Chaplain) on Jul 07, 2011 at 15:28 UTC
I did this a long time ago in another job using the dbiproxy script that is included in DBI.	[reply]