Re^2: 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
[download]

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.	[reply]
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	[reply]
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.	[reply]

Do not post your personal database connection details!