dbi_link and dbi:ODBC
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.
On Tue, Feb 26, 2008 at 04:07:23PM +0100, Hermann Muster wrote:
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',
Hermann,
I haven't tested MS SQL Server with the ODBC driver, but I have used
FreeTDS to good effect with that DBMS. If you have a test setup I can
use to diagnose this, that would be great. I have some time this
weekend. Let me know off-list.
By the way, you'll probably want to file a bug report against DBI-Link
<http://pgfoundry.org/projects/dbi-link/> and join the DBI-Link
mailing list to discuss this, as that's a more appropriate forum for
such discussions :)
Cheers,
David (author of DBI-Link)
'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:XX000P.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
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate