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

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 ( #800712=note: print w/ replies, xml ) Need Help??

Comment on Re^3: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?
Re^4: 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 17:18 UTC
    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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (11)
As of 2014-12-17 20:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (32 votes), past polls