PostgreSQL In SQL Server

[coolwater]

hi

I try to Linked server in SQL server to postgreSQL 6.5. I got the error message when I make a query.

The error message : invalid schema or catalog specified for provider 'MSDASQL'.

1. I already set up ODBC data Source in Control panal.
2. On the sql server, i create the link server with the following field
MS OLE DB provider for ODBC driver , link server name and ODBC datasourse name.
3. I checked the box "Be made without using a security context" under Security Tab.
4. Nothing under "local server login to remote server login mappings"
5. In the server option, only checked on "DataAccess" and "User remote collection"

Afterthat, I can see all the tables name in my postgreSQL database

I guess, If I can view all the table, it means that the setting is corrected. isn't it?

Is it something else that I need to do to make it works?
When I setup the linked server, Do I have to provide info for location , catalog , provider string ???

I try to query with 4 part - servername.database.owner.table
but I got this error too.
Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.

Thanks for help. I am appreciated that.


yours,
Florence Lai

 

[RahulGade]

Dear coolwater,
Have u installed the ODBC driver for PostgreSQL with proper version(imp). Because i have done it already in Linux - Windows Combination,
for that i need to start the server using option -i.
and i need to configure in PostgreSQL ODBC Driver,ie. username, password and port address.



Rahul
If you think you can't do it,You will never be able to do it.