Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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 imbibing at the Monastery: (6)
As of 2014-10-01 18:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (34 votes), past polls