<html><div style='background-color:'><DIV><FONT color=#800080 size=2>
<P>hi</P>
<P>I try to Linked server in SQL server to postgreSQL 6.5. I got the error message when I query. </P>
<P>The error message : invalid schema or catalog specified for provider 'MSDASQL'.</P>
<P>1. I already set up ODBC data Source in Control panal. </P>
<P>2. On the sql server, i create the link server with the following field </P>
<P>MS OLE DB provider for ODBC driver , link server name and ODBC datasourse name.</P>
<P>3. I checked the box "Be made without using a security context" under Security Tab.</P>
<P>4. Nothing under "local server login to remote server login mappings"</P>
<P>5. In the server option, only checked on "DataAccess" and "User remote collection"</P>
<P>Afterthat, I can see all the tables name in my postgreSQL database</P>
<P>I guess, If I can view all the table, it means that the setting is corrected. isn't it?</P>
<P>Is it something else that I need to do to make it works?</P>
<P>When I setup the linked server, Do I have to provide info for location , catalog , provider string ???</P>
<P>I try to query with 4 part - servername.database.owner.table</P>
<P>but I got this error too. </P>
<P>Server: Msg 7312, Level 16, State 1, Line 1</P>
<P>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.</P></FONT><FONT face="Times New Roman">
<P>Thanks for help. I am appreciated that.</P>
<P> </P></FONT><FONT color=#800080 size=2>
<P>yours,</P>
<P>Florence Lai</P></FONT><BR><BR><BR>Florence :> </DIV>smile:>
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>