Hi This seems to work fine for me following the steps given (thanks
i now have a query issue
I did a count on a table in the postgresAdmin the returned close to a million rows
the same query using open query does not run at all. the count errors
so i did a select query query
OPENQUERY (PG_ClientDB, 'SELECT customer_id FROM customers;
Cannot process the object "SELECT customer_id FROM customers;
". The OLE DB provider "MSDASQL" for linked server "PG_ClientDB" indicates that either the object has no columns or the current user does not have permissions on that object.
strange error behavior from here because if i add ' LIMIT 400000' (or upto that value) This returns the select query back with the 400000 rows
any thing higher and it fails
Then wen i check the catalog folder for my pg database it has vanished 3 minutes later i then comes back ????????
is there a limitation on the odbc driver or using Open Query causing this to happen ?
Thanks in advance it would be really great to get this solved