Wolfgang on You verified you have the right user name and password and other settings. I think the article we have listed above has the newer driver name to reference. But the answer isn’t any less correct. Open a new query window in Management Studio, select the world database and execute the following commands:. Tuesday, February 23, – We can see the driver is for PostgreSQL 9.

Uploader: Kern
Date Added: 11 April 2006
File Size: 56.94 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 29652
Price: Free* [*Free Regsitration Required]

Sign up using Facebook.

In the dialog box that pops-up, provide a name and description for the data source, specify the database name, server’s IP address, port, user name and password as connection parameters.

But be careful, when you are using ODBC, there is a 32bits and a 64bits version.

Sign up using Email and Password. In this case we have used the built-in Postgres super user account to keep things simple. Hello, I had the same problem and I found the solution and post it to my Blog here: We can see the driver is for PostgreSQL 9. The free version will give you your basic ADO.


In my Developer envoriontment It works without problem. So now we have it. Still stumbling with all the various data type conversions, specially arrays, bytea, etc.

Email Required, but never shown. What makes most of these “connectors” cost?

SQL Server and PostgreSQL Linked Server Configuration – Part 2

After I created frse DSN, with the download from http: Sign up or log in Sign up using Google. I think the article we have listed above has the newer driver name to reference 5. Arthur Thomas 4, 1 19 They do have a ODBC connector too. Can we use the linked postgre tables directly in our views and stored procedures?

Thanks for the report. Select type of offense: Based on the steps from your first tip, how can we take the next steps to setup the data access? Thanks for a great article.

To see if that is the issue, try selecting a couple of columns that are simple like just varchar and integer. Can you provide me a list of the.


PostgreSQL OLE DB Provider

Promote cracked software, or other illegal content. Blog Administration Open postres screen. I answered this a long time ago. Stradas 1, 14 But the answer isn’t any less correct.

Download PostgreSQL OLE DB Native Provider bit (Developer’s License) Free

The data source should be the one we just created: Tuesday, December 13, – 7: Read our newer article on this: Enter in the “msi” folder for the installer. OleDb class data providers. We have opedb 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.