Newbie problem connecting to MS SQL Server



I am trying to connect to an MS SQL Server database, running on a Win2k
server, from a Solaris 5.8 system using Perl 5.6.1. I have installed
DBI and Bundle::DBD, but I can't get a connection. I have read the
READMEs, but am still unable to get the connection made.



I get the following message when installing DBD::ODBC:



The DBD::ODBC module needs to link with an ODBC 'Driver Manager'.

(The Driver Manager, in turn, needs one or more database specific ODBC
drivers.

The DBD::ODBC module does _not_ include any ODBC drivers!)



You need to indicate where your ODBC Driver Manager is installed.

You can do this ether by setting the ODBCHOME environment variable

or by runing 'perl Makefile.PL -o odbcdir'.



If you do not have an ODBC Driver Manager you can try building

the free iODBC Driver Manager in the iodbcsrc directory.



cpan> install iodbcsrc

Warning: Cannot install iodbcsrc, don't know what it is.

Try the command



i /iodbcsrc/



to find objects with matching identifiers.



cpan> i /iodbcsrc/

CPAN: Storable loaded ok

Going to read /.cpan/Metadata

Database was generated on Tue, 26 Apr 2005 23:05:12 GMT

No objects found of any type for argument /iodbcsrc/







Any and all help would be greatly appreciated.



My environment:

Solaris 5.8

Perl 5.6.1



MS SQL Server database is running on a Win 2k server.



Thanks,

Mark



Mark Vaughan

Programmer III



Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mark.vaughan@xxxxxxxxxxxx <mailto:mark.vaughan@xxxxxxxxxxxx>

Evolving Systems, Inc.

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com



This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at tis@xxxxxxxxxxxx and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments.

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112


Relevant Pages

  • dbi and filemaker 6
    ... I am trying to write a perl script to send sql commands to a filemaker ... I tried to install dbd:odbc to ... You need to indicate where your ODBC Driver Manager is installed. ...
    (comp.databases.filemaker)
  • Cannot find ODBC driver
    ... I have installed unixODBC for use as a driver manager for DBD::ODBC. ... Hmm...I cannot find an ODBC driver manager that I recognize. ... Make had some problems, won't install ...
    (perl.dbi.users)
  • AHHH M$Sql DBD unixODBC freetds
    ... Is there some secert handshake to get dbi to work with a microsoft sql 2000 ... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. ... If you do not have an ODBC Driver Manager you can try building the free iODBC Driver Manager in the iodbcsrc directory. ... Won't test Running make install ...
    (perl.beginners)
  • Instaling DBI 1.42 on Mac OS X Server version 10.2.4 I
    ... -1 after entering the command: Perl Makefile.PL I have obtained the following ... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. ... (The Driver Manager, in turn, needs one or more database specific ODBC drivers. ... I want to know what I should in order to resolve the problem and to install ...
    (perl.dbi.users)
  • Re: Newbie problem connecting to MS SQL Server
    ... > I am trying to connect to an MS SQL Server database, running on a Win2k ... but am still unable to get the connection made. ... You'll have to install the a Unix ODBC manager, ...
    (perl.dbi.users)