AHHH M$Sql DBD unixODBC freetds

From: Paul D. Kraus (pkraus_at_pelsupply.com)
Date: 05/04/04

  • Next message: Madhu Reddy: "Re: SIMPLE SEARCH AND REPLACE"
    To: beginners@perl.org
    Date: Tue, 4 May 2004 13:54:19 -0400
    
    

    Is there some secert handshake to get dbi to work with a microsoft sql 2000
    server?

    I have followed the cryptic path and dug my way into installing unixODBC and
    freetds and I am able to connect to the servers with the isql command and the
    datamanager.

    But when i try and install the perl DBD::ODBC from cpan using perl -MCPAN -e
    shell

    install DBD::ODBC

    i get this error ... I have since then set the ODBCHOME variable to the
    /usr/local/lib/ since this is where the m$sql driver is and still when i
    complie i get almost the exact same error. Both are bellow.

    Please help :)

    PK

    ---
    Configuring DBD::ODBC ...
    >>>     Remember to actually *READ* the README file!
            And re-read it if you have any problems.
    Using DBI 1.37 installed in 
    /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI
    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.
    Makefile.PL aborted.
    Running make test
      Make had some problems, maybe interrupted? Won't test
    Running make install
      Make had some problems, maybe interrupted? Won't install
    After ODBC HOME IS SET
    ----
    Removing previously used /root/.cpan/build/DBD-ODBC-1.09
      CPAN.pm: Going to build J/JU/JURL/DBD-ODBC-1.09.tar.gz
    Useless use of private variable in void context at Makefile.PL line 430.
    Configuring DBD::ODBC ...
    >>>     Remember to actually *READ* the README file!
            And re-read it if you have any problems.
    Using DBI 1.37 installed in 
    /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI
    Using ODBC in /usr/lib/
    Use of uninitialized value in substitution (s///) at Makefile.PL line 154.
    Hmm...I cannot find an ODBC driver manager that I recognize.
    ...And I know about these drivers:
            Microsoft ODBC, adabas, easysoft, empress, esodbc, informix,
            intersolve, iodbc, sapdb, solid, udbc, unixodbc
    Running make test
      Make had some problems, maybe interrupted? Won't test
    Running make install
      Make had some problems, maybe interrupted? Won't install
    

  • Next message: Madhu Reddy: "Re: SIMPLE SEARCH AND REPLACE"

    Relevant Pages

    • DSNs
      ... I'm trying to debug an install for my DBD::ODBC module, ... is my first experiment with the DBI, I have a question on format/syntax. ... In order to install the ODBC driver, ...
      (perl.dbi.users)
    • Re: Need ODBC driver for DBF files for VISTA
      ... ¤ Does anyone know where to obtain the ODBC driver install file for DBF ... The 2 that I have will not install with VISTA. ... The ODBC driver that comes installed with VISTA is version 1.00.02.00 ...
      (microsoft.public.vb.database)
    • 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: Connect to MySQL
      ... I can now study basics operations on MySQL database ... I have also installed ODBC driver, ... instructions which tell you to install ODBC, as I'm darned sure it's not ...
      (comp.lang.php)
    • Newbie problem connecting to MS SQL Server
      ... I am trying to connect to an MS SQL Server database, ... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. ... You need to indicate where your ODBC Driver Manager is installed. ... Cannot install iodbcsrc, ...
      (perl.dbi.users)