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: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 -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
