NET new in postgresql oobase other dbms db2 Dbase firebird informix ms access mysql netezza oracle sql server sqlite terradata pgadmin pgagent pl programming plcoffee plLiveScript plperl plpgsql plpython PLR plv8js sql functions postgis postgresql versions 10 11 8. This is what I have done so far: Subscribe to this entry. I have a similiar problem on 32 bit. Display comments as Linear Threaded.

Uploader: Fezragore
Date Added: 6 April 2018
File Size: 60.72 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 88415
Price: Free* [*Free Regsitration Required]

Postgres OnLine Journal Tracked: The newere driver doesn’t seem to handle data type conversion quite as well as the older. I downloaded and installed the I am actually having trouble making a linked server to Postgres even with the bit server.

Sign in to vote. Daniel Costa 15 Daniel Costa Homepage on I can see both variations here in the registry: We’ll need to try this out ourselves and report on it.

I downloaded and installed every link on the page, where the heck is the psqlodbcwAMD Read our newer article on this: The following messages pops up: Your comment will only be submitted if the strings match. After I created the DSN, with the download from http: Thursday, July 23, 8: I installed process monitor and I saw that before throwing the error SQL tries to get access to two paths: Net SqlClient Data Provider.


Entry’s Links Quicksearch Calendar. Archives December November October Recent Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Sign up or log in Sign up using Google. Remove From My Forums.

When to use MSDASQL and when to use MSDASQL.1?

Hi All I am stuck with a problem. Friday, July 24, 6: Email Required, but never shown. You don’t want to reboot a prod server, but you didn’t test it first on another server?

Display comments as Linear Threaded.

Setting up PostgreSQL as a Linked Server in Microsoft SQL Server bit – Postgres OnLine Journal

msrasql Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Without another server to test on, I’d recommend biting the bullet and seeing if that does the trick. Home Questions Tags Users Unanswered.


I used eventually a different server to setup the Linked Server on a Windows server. Linked Servers and replication are working very well with the provider see example at http: Thursday, August 6, 9: Leo on I can mssdasql see the tables of Postgres in the Object Explorer.

Thursday, July 23, 7: