Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f2U21aK39633 for ; Thu, 29 Mar 2001 21:01:36 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from hotmail.com (f233.law11.hotmail.com [64.4.17.233]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SD4KU18205 for ; Wed, 28 Mar 2001 08:04:20 -0500 (EST) (envelope-from mdintekhabalam@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 28 Mar 2001 05:04:20 -0800 Received: from 210.81.12.98 by lw11fd.law11.hotmail.msn.com with HTTP; Wed, 28 Mar 2001 13:04:20 GMT X-Originating-IP: [210.81.12.98] From: "Md. Intekhab Alam" To: pgsql-sql@postgresql.org Date: Wed, 28 Mar 2001 18:34:20 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 28 Mar 2001 13:04:20.0334 (UTC) FILETIME=[9A4958E0:01C0B787] X-Archive-Number: 200103/623 X-Sequence-Number: 2294 Has anyone tried setting up Postgres as a linked server under Microsofts SQL Server 7 to connect with SQL 6.5 I am able to create the link correctly (see below) and see all the tables available in Postgres, but if I try querying anything in them I get the following error Server: Msg 7313, Level 16, State 1 Invalid schema or catalog specified for provider 'MSDASQL'. how should I correct this problem. I am in very critical position because of this problem. please help me out ASAP i will be thankfull for that. waiting eagarly for the reply with helpful suggetion. regards, Intekhab Alam _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.