in reply to What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?

blackadder:

I also use DBI with DBD::ODBC on Windows to talk with MS SQL Server 2008 from WinXP. It works just fine. I've heard complaints of "slow performance" from ODBC and SQL Server, but have seen no evidence of it in my applications for the last 10 years.

The others likely work fine too, but as I also do work on Linux, etc., I stick with the cross-platform tools...

...roboticus
  • Comment on Re: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?

Replies are listed 'Best First'.
Re^2: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?
by blackadder (Hermit) on Oct 12, 2009 at 13:13 UTC
    Ok it seams to work - only a little bit thu - but I get this error!! 
    U:\Doccuments\Scripts\Start>db2.pl
DBI connect('dsnname;Server=ABCB00062\Dev;Database=ukdevxxxx;UID=uk_gg
+g\\xyz12345;
PWD=7seven7','',...) failed: [Microsoft][ODBC Driver Manager] Data sou
+rce
name not found and no default driver specified (SQL-IM002) at U:\Doccu
+ments\Scri
pts\Start\db2.pl line 32

    [download]
    How do I over come this driver error? What do I need to do?

    Thanks
    Blackadder
[reply]
[d/l]

      Do not post your personal database connection details!



      Update your post.
[reply]
        The connection details are all made up!

        Thanks to all for your help

        I have found out why it wasn't working. Its to do with authentication. MSSQL authentication differs from Windows authentication. I asked the DBA admin guys to set me up with an SQL account to access the server rather than Windows account

        Blackadder
[reply]

In Section Seekers of Perl Wisdom