dbi_link and dbi:ODBC
От | Hermann Muster |
---|---|
Тема | dbi_link and dbi:ODBC |
Дата | |
Msg-id | fq19v8$lbe$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: dbi_link and dbi:ODBC
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: