Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by roboticus (Chancellor)
on Oct 12, 2009 at 12:44 UTC ( [id://800699]=note: print w/replies, xml ) Need Help??


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

    Thanks
    Blackadder

      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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://800699]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (6)
As of 2024-04-24 10:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found