From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Christian Schaer <chris.schaer@datacomm.ch>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Approach can't open ...
Date: Tue, 08 Feb 2000 20:03:29 -0500
Message-ID: <38A0BCE1.31D4409F@home.com> (raw)
References: <200002072025.MAA27467@www.geocrawler.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, chris.schaer@datacomm.ch, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Approach can't open ...
In-Reply-To: <38A0BCE1.31D4409F@home.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox