Re^3: connecting Perl with MS SQL Server on NT using ODBC

Replies are listed 'Best First'.
Re^4: connecting Perl with MS SQL Server on NT using ODBC by Secalles (Initiate) on Dec 29, 2011 at 17:26 UTC
I still get an error DBI connect('driver={SQL Server};server=localhost\WHATSUP;tcpip=3477;d +atabase=equip;uid=rodrigo;pwd= 123456','',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]S +QL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect() +). (SQL-01000) [state was 0100 0 now 01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute + (SQL-01S00) at C:\fsecali\con nectDB.pl line 9 Couldn't open database: [Microsoft][ODBC SQL Server Driver][DBNETLIB]S +QL Server does not exist or ac cess denied. (SQL-08001) [state was 08001 now 01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect() +). (SQL-01000) [state was 0100 0 now 01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute + (SQL-01S00) [download] Thanks	[reply] [d/l]
Re^5: connecting Perl with MS SQL Server on NT using ODBC by poj (Abbot) on Dec 29, 2011 at 17:40 UTC
Different error `SQL Server does not exist or access denied.` I suggest using Control Panel / Administrative Tools / ODBC Data Source Administrator to test your connection parameters poj	[reply] [d/l]
Re^6: connecting Perl with MS SQL Server on NT using ODBC by Secalles (Initiate) on Dec 29, 2011 at 17:47 UTC
I open it and i have no Data Source configured here. I configured a SQL Server called MSSQL (in System DSN) and it worked ( the test was successful )and i'm still getting "access denied" Should i change my code?	[reply]
Re^7: connecting Perl with MS SQL Server on NT using ODBC by poj (Abbot) on Dec 29, 2011 at 17:56 UTC
Re^8: connecting Perl with MS SQL Server on NT using ODBC by Secalles (Initiate) on Dec 29, 2011 at 18:02 UTC


Perl-Sensitive Sunglasses
	PerlMonks