June 16, 2008 at 12:05 am
iam using sql server 2005 express edition. i have to link the postgre sql from sql.i tried "spaddlinkedserver".this successfully executed but when i try for select query this shows cannot create initialization error....is there anyway?? if so pls explain it detail...
(i succeeded with ms access)
help me
June 17, 2008 at 7:26 am
Once upon a time I used to use DTS to connect an RMS database to a postgreSQL db. I think that was pgSQL 7.1 or perhaps earlier.
The biggest problem I ran into was finding the correct driver to use. The postgreSQL driver wasn't completely compliant and we were not able to make a direct OLE connection. We had to make the connection using ODBC. I'm not sure if the issues have been worked out, as that was a few revs back, but you could try it that way and see what happens.
Also, make sure you are appropriately passing the credentials, making sure you are connecting with a user that is either a) being impersonated correctly, or b) that you are connecting with the appropriate user.
This below link has some information that may be helpful. It deals with SQL 2000, but the concepts are all the same.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply