dbi_link and dbi:ODBC

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.

Responses

Browse pgsql-general by date

  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