[snip]
>
> C:\Inetpub\scripts\brian\lbc>perl mx.pl id=123
> DBI connect('driver={SQL
> Server};Server=XXX.XXX.XXX.XXX,1433;database=LBC_research_
> test;uid=NALD_Admin;pwd=XXXXXXXXXX;','',...) failed:
> [Microsoft][ODBC SQL Server Driver]Client unable to
> establish connection (SQL-08001) [Microsoft][ODBC SQL Server
> Driver][Named Pipes]ConnectionOpen (CreateFile()). (
> SQL-01000)(DBD: db_login/SQLConnect err=-1) at mx.pl line 25
> [Microsoft][ODBC SQL Server Driver]Client unable to establish
> connection (SQL-08
> 001)
> [Microsoft][ODBC SQL Server Driver][Named
> Pipes]ConnectionOpen (CreateFile()). (
> SQL-01000)(DBD: db_login/SQLConnect err=-1) at mx.pl line 25.
This is inside the ODBC driver. I'd suggest checking which port it's
really using and ensuring that can go through the firewall from the
outside.
Also, not knowing a great deal about SQL Server connect strings, I
looked up the docs and it seems that you might want to use ADDRESS=
instead of or in addition to SERVER=
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql
/od_odbc_bcp_1a43.asp
Jeff
