Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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


in reply to Re^3: 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?

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

Replies are listed 'Best First'.
Re^5: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?
by mje (Curate) on Oct 12, 2009 at 20:05 UTC

    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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://800757]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2024-04-16 14:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found