Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: DBI on Windows 2000 / NT

    Hi,

    I am new to Perl and DBI too, I installed Perl 5.8 on my PC , SQL Server 2000 is it possible to installed DBI on Windows and use in Perl to connect to SQL Server ?

    Please please help. Like to learn Perl programming using - DBI . amy help URL info will also help.

    Thanks,
    Ram

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: DBI on Windows 2000 / NT

    I am new to Perl and DBI too, I installed Perl 5.8 on my PC , SQL Server 2000 is it possible to installed DBI on Windows and use in Perl to connect to SQL Server ?
    I assume you mean MS SQL Server?

    Yes it is possible.
    But you need a C compiler.

    As far as I know, it is not possible to access SQL Server with the Sybase client libraries (once it was, that changed with version 7.0).
    So you have to use FreeTDS, a free implementation of the TDS protocol, used to talk to SQL Server.
    Get it at www.freetds.org.

    You may get DBI from activestate (www.activestate.com) for version 5.8.
    If not, go to CPAN and search for DBI (search.cpan.org).

    You also need DBD:ybase, and that's not on activestate at the moment. So you have to compile this on your own.
    Go to Michael Pepplers site for this: www.mbay.net/~mpeppler/

  3. #3
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89
    OTOH,

    You used to be able to use ODBC to connect to MS-SQL Server. I think it works on MS-SQL Server 2K.

    Try configuring ODBC to connect to one of your MS-SQL Server databases. If that works, use PPM and install DBD::ODBC.

    HTH

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I use the Win32::ODBC interface all of the time. The DBD::ODBC interface works nicely too, but it isn't "blessed" for production use in our shop.

    -PatP

  5. #5
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89
    I know of a "shop" like that --- they would rather be unable to solve the problem than use a method that hasn't been "blessed!"

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You gotta love that... Or at least it helps if you can pretend like you do.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •