Skip site navigation (1) Skip section navigation (2)

postgresql and MS server 2000

From: "Florence Lai" <florlai(at)hotmail(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: postgresql and MS server 2000
Date: 2001-11-14 21:24:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
<html><div style='background-color:'><DIV><FONT color=#800080 size=2>
<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>&nbsp;</P></FONT><FONT color=#800080 size=2>
<P>Florence Lai</P></FONT><BR><BR><BR>Florence :&gt; </DIV>smile:&gt; 
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href=''></a><br></html>

Attachment: unknown_filename
Description: text/html (1.8 KB)

pgsql-interfaces by date

Next:From: Tom LaneDate: 2001-11-15 00:26:25
Subject: Re: about the magic(?) of palloc() and variable-length user-defined data type
Previous:From: Seung Hyun JeongDate: 2001-11-14 20:23:57
Subject: about the magic(?) of palloc() and variable-length user-defined data type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group