http://www.perlmonks.org?node_id=37883

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

Thank you for answering my last question "How do I connect to Microsoft SQL server 6.5?" but now I have downloaded it and need to install it but all of the instructions seem to be for UNIX and I am using NT. Help me please!!!!! Looking for even more enlightenment Sparkie

Originally posted as a Categorized Question.

Replies are listed 'Best First'.
Re: How do I install the DBD::ODBC on NT
by lhoward (Vicar) on Oct 23, 2000 at 16:50 UTC
    ActiveState perl comes with DBD::ODBC pre-installed. You shouldn't need to re-install it.
Re: How do I install the DBD::ODBC on NT
by Lexicon (Chaplain) on Oct 25, 2000 at 12:33 UTC
    However, ActiveStatePerl does not have DBI preinstalled. You'll need to use the Perl Package Module to get it. Type "ppm" at a command prompt or find the file in your Perl/Bin/ppm.bat directory. It will bring up the installer. In that, type "install dbi" and watch it go. Actually, it does very little and very slowly for a while, but trust me, it's working. I did it just today actually.

    My current problem is that I can't seem to make a connection to my database through ODBC. Which wouldn't be so bad, except that I'm working at a Japanese company and can't read the SQL server dialog boxes to go fix anything. ;)

Re: How do I install the DBD::ODBC on NT
by wardk (Deacon) on Oct 25, 2000 at 21:25 UTC

    Have you downloaded Win32::ODBC?

    Win32::ODBC along with the MS MDAC 2.1 drivers and ActiveState should get you setup to use Perl/ODBC/SqlServer on NT.