Received: from mail.rdc1.md.home.com (imail@ha1.rdc1.md.home.com [24.2.2.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id UAA20901
	for <pgsql-interfaces@hub.org>; Tue, 8 Feb 2000 20:03:52 -0500 (EST)
	(envelope-from byron.nikolaidis@home.com)
Received: from home.com ([24.4.141.52]) by mail.rdc1.md.home.com
	(InterMail v4.01.01.00 201-229-111) with ESMTP
	id <20000209010351.PNSO21411.mail.rdc1.md.home.com@home.com>;
	Tue, 8 Feb 2000 17:03:51 -0800
Message-ID: <38A0BCE1.31D4409F@home.com>
Date: Tue, 08 Feb 2000 20:03:29 -0500
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
X-Mailer: Mozilla 4.5 [en]C-AtHome0405  (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Christian Schaer <chris.schaer@datacomm.ch>
CC: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Approach can't open ...
References: <200002072025.MAA27467@www.geocrawler.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Christian Schaer wrote:
> 
> This message was sent from Geocrawler.com by "Christian Schaer" <chris.schaer@datacomm.ch>
> Be sure to reply to that address.
> 
> Please let me repeat a problem already stated
> 05/05/97 by Jyry Kuukkanen:
> 
> Jyry Kuukkanen wrote:
> 
> > Hi
> >
> > This is it. I had it. I just can`t sort it out.
> >
> > I can create a table using Lotus Approach, but
> I can`t open it. It fails
> > with error code -7011 (Couldn`t open database
> blaah blaah) and then it
> > show another message saying:
> >
> > [Microsoft][ODBC Driver Manager] Driver does
> not support this function.
> >
> 
> I ran into the exactly the same problem recently.
> The following is an excerpt from my C:SQL.LOG
> file, that shows where the error occurs.
> 
> To me it looks as if a problem is encountered
> using the SQLTablePrivileges
> call (is this supported by the psqlODBC driver?).
> After this problem, Approach attempts to find out
> more by calling SQLError.
> This then leads to the error code -7011.
> Somewhere on the Web I found something about
> SQLError being replaced by
> SQLGetDiagRec and SQLGetDiagField in ODBC version
> 3. Does this have anything
> to do with it?
> 
> Any help greatly appreciated!

Hi,

SQLTablePrivileges is not supported in the driver, *however*, I posted a
new driver just now that returns an empty result set from SQLTablePriv.,
instead of an error.  According to Bill Gates, this is ok, and I quote
:)  "SQLTablePrivileges might not return privileges for all
tables...Applications can use any valid table, regardless of whether it
is returned by SQLTablePrivileges."

Try the new driver and let me know.

ftp://ftp.postgresql.org/pub/odbc/index.html

Byron