Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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 ( [id://800705] : note . print w/replies, xml ) Need Help??


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

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
How do I over come this driver error? What do I need to do?

Thanks
Blackadder
  • Comment on Re^2: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?
  • Download Code

Replies are listed 'Best First'.
Re^3: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?
by Zen (Deacon) on Oct 12, 2009 at 13:51 UTC

    Do not post your personal database connection details!



    Update your post.
      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

        That should not have made a difference to the code you posted since the error you were getting was datasource not found and not an authentication error. As a result I suspect you changed more than one thing. Windows authentication is very different from SQL Server authentication but that step comes after locating the driver or datasource. However, I am pleased you are up and running.