hi

I try to Linked server in SQL server to postgreSQL 6.5. I got the error message when I 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