I have a linked server configured for a Postgres server on my MS SQL 2005 server. I use this server quite often to receive data for queries and reports but the server response is to slow and need an alternative solution. The ODBC provider I'm using is PGNP on the linked server. I thought of using openrowset so I could only return the data I need but not sure how to specify the IP Address, Port number, username or password. Please could anyone help. To query the linked server currently I use SELECT * FROM [LinkedServer].[DatabaseName].[Public].[tablename] WHERE (Statement)
asked Sep 21 '10 at 06:07 AM in Default
You would use something along these lines:
You then would need to substitute ProviderName and ConnectionString with the relevant details for your PostGres client. I am not sure what they are though. However, this page has some good examples.
answered Sep 21 '10 at 06:17 AM
Matt Whitfield ♦♦