Arthur Thomas 4, 1 19 I am actually having trouble making a linked server to Postgres even with the bit server. In my Developer envoriontment It works without problem. I have read the privacy statement and understand I may unsubscribe at any time. I have a similiar problem on 32 bit. The posting of advertisements, profanity, or personal attacks is prohibited.

Uploader: Zuzuru
Date Added: 7 August 2011
File Size: 65.31 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 91753
Price: Free* [*Free Regsitration Required]

Roxana on Tuesday, December 13, – 7: Monday, June 29, – 7: ODBC doesn’t have a free version.

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Thanks for olfdb report.

SQL Server and PostgreSQL Linked Server Configuration – Part 2

Why would I ever use one over the standard? I think the article we have listed above has the newer driver name to reference 5. Flaming or offending other users. 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.

We’ll need to try ppstgres out ourselves and report on it. I cannot find it anywhere therefore cannot run it Google turns up empty, and the site that things link to is some Japanese site that you can no longer download frse driver Someone please help! I can not see the tables of Postgres in the Object Explorer. Thanks for a fdee article.


Connect to a PostgreSQL database (Power Query) – Excel

The free version will give you your basic ADO. Your article is very Worthy. We can see the driver is for PostgreSQL 9.

OleDb class data providers. Hello, I had the same problem and I found the solution and post it to my Iledb here: I downloaded and installed every link on the page, where the heck is the psqlodbcwAMD Sexually explicit or offensive language.

The provider can be used from bit and bit applications both native and. Serge, Haven’t tried the new bit driver yet, but on the psqlodbc site, there is now a bit ODBC driver. All comments are reviewed, so stay on subject or we may delete your comment. Soniya on Its flexible architecture allows emulation of various databases SQL flavors Enterprise edition and saves customer from rewriting applications that originally developed for other databases. Good piece frde informaitons.

PostgreSQL OLE DB Provider

They do have a ODBC connector too. Trackback specific URI for this entry. Email Required, but never shown. If you believe this comment is offensive or violates the CNET’s Site Terms of Useyou can report it below this will not automatically remove the comment.


This is to retrieve some of the columns from a table. We have created an ODBC connection against the remote PostgreSQL instance, created a linked server on top of it and then executed two commands to copy across the data.

Oostgres that can be implemented, you can use a command like this:. Give that one a try http: I have read the privacy statement and understand I may unsubscribe at any time.