From: | Hermann Muster <Hermann(dot)Muster(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | dbi_link and dbi:ODBC |
Date: | 2008-02-26 15:07:23 |
Message-ID: | fq19v8$lbe$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gordon | 2008-02-26 15:29:22 | Re: Query meltdown: caching results |
Previous Message | TJ O'Donnell | 2008-02-26 14:56:23 | Re: Deploying PostgreSQL on virtualized hardware |