I have the following problem getting to connect a remote database (MS
SQL Server in my case) to PostgreSQL.
I'm using SQL Server 2005 Express Edition. I tried it with the following:
SELECT dbi_link.make_accessor_functions(
'dbi:ODBC:DRIVER=SQL Native
Client;Server=192.168.10.175;Database=Test;Uid=sa;Pwd=test;MARS_Connection=yes;LongReadLen=8000;LongTruncOk=1',
'sa',
'test',
'---
AutoCommit: 1
RaiseError: 1
LongReadLen: 8000
LongTruncOk: 1
',
NULL,
NULL,
NULL,
'Solution'
);
Unfortunately, I can't get it to work. The following errors occur. Any
idea about that?
ERROR: error from Perl function: error from Perl function: DBI
connect('DRIVER=SQL Native
Client;Server=192.168.10.175;Database=Test;Uid=sa;Pwd=test;MARS_Connection=yes;LongReadLen=8000;LongTruncOk=1','sa',...)
failed: [Microsoft][SQL Native Client]Named Pipes-Provider: A connection
to SQL Server couldn't be established [2]. (SQL-08001)
[Microsoft][SQL Native Client]Logintimeout expired. (SQL-HYT00)
[Microsoft][SQL Native Client]Invalid attribute for the connection
string (SQL-01S00)
[Microsoft][SQL Native Client]Error with extablishing connection to
server. (SQL-08001)(DBD: db_login/SQLConnect err=-1) at line 37 at line 35.
SQL Status:XX000
P.S. I translated the above messages from german, so it's not exactly
the same message than the english SQL Server.
Thanks for your help. :-)
Regards.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
