pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedApproach can't open ...
3+ messages / 3 participants
[nested] [flat]
* Approach can't open ...
@ 2000-02-07 20:25 Christian Schaer <archiver@db.geocrawler.com>
2000-02-08 07:23 ` Re: [INTERFACES] Approach can't open ... Jyry Kuukkanen <jyry@neutech.fi>
2000-02-09 01:03 ` Re: [INTERFACES] Approach can't open ... Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 2 replies; 3+ messages in thread
From: Christian Schaer @ 2000-02-07 20:25 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
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!
EXCERPT from SQL.LOG
--------------------
approach fffd46af:fffd0863 ENTER
SQLTablePrivilegesW
...
approach fffd46af:fffd0863 EXIT
SQLTablePrivilegesW with return code -1
(SQL_ERROR)
...
approach fffd46af:fffd0863 ENTER
SQLError
...
approach fffd46af:fffd0863 ENTER
SQLErrorW
...
approach fffd46af:fffd0863 EXIT
SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x00ec025c
HDBC 0x00ec4ee4
HSTMT 0x00ec5938
WCHAR * 0x009bc1a8
(NYI)
SDWORD * 0x009bc7ec (0)
WCHAR * 0x009bc1b4
[ 140] "[Microsoft][ODBC Driver Manager]
Driver does not support this function"
SWORD 1024
SWORD * 0x009bc7f2
(140)
approach fffd46af:fffd0863 EXIT
SQLError with return code 0 (SQL_SUCCESS)
HENV 0x00ec025c
HDBC 0x00ec4ee4
HSTMT 0x00ec5938
UCHAR * 0x009bc7e4
(NYI)
SDWORD * 0x009bc7ec (0)
UCHAR * 0x009bc5e4
[ 70] "[Microsoft][ODBC Driver Manager]
Driver does not support this function"
SWORD 512
SWORD * 0x009bc7f2
(70)
Geocrawler.com - The Knowledge Archive
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Approach can't open ...
2000-02-07 20:25 Approach can't open ... Christian Schaer <archiver@db.geocrawler.com>
@ 2000-02-08 07:23 ` Jyry Kuukkanen <jyry@neutech.fi>
1 sibling, 0 replies; 3+ messages in thread
From: Jyry Kuukkanen @ 2000-02-08 07:23 UTC (permalink / raw)
To: Christian Schaer <chris.schaer@datacomm.ch>; +Cc: pgsql-interfaces@hub.org
Actually, I only solved this a week ago by upgrading to Approach 9.5
It comes with the lastest release of/upgrade to Lotus SmartSuite.
> > 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!
>
>
> EXCERPT from SQL.LOG
> --------------------
> approach fffd46af:fffd0863 ENTER
> SQLTablePrivilegesW
> ...
> approach fffd46af:fffd0863 EXIT
> SQLTablePrivilegesW with return code -1
> (SQL_ERROR)
> ...
> approach fffd46af:fffd0863 ENTER
> SQLError
> ...
> approach fffd46af:fffd0863 ENTER
> SQLErrorW
> ...
> approach fffd46af:fffd0863 EXIT
> SQLErrorW with return code 0 (SQL_SUCCESS)
> HENV 0x00ec025c
> HDBC 0x00ec4ee4
> HSTMT 0x00ec5938
> WCHAR * 0x009bc1a8
> (NYI)
> SDWORD * 0x009bc7ec (0)
> WCHAR * 0x009bc1b4
> [ 140] "[Microsoft][ODBC Driver Manager]
> Driver does not support this function"
> SWORD 1024
> SWORD * 0x009bc7f2
> (140)
>
> approach fffd46af:fffd0863 EXIT
> SQLError with return code 0 (SQL_SUCCESS)
> HENV 0x00ec025c
> HDBC 0x00ec4ee4
> HSTMT 0x00ec5938
> UCHAR * 0x009bc7e4
> (NYI)
> SDWORD * 0x009bc7ec (0)
> UCHAR * 0x009bc5e4
> [ 70] "[Microsoft][ODBC Driver Manager]
> Driver does not support this function"
> SWORD 512
> SWORD * 0x009bc7f2
> (70)
>
>
> Geocrawler.com - The Knowledge Archive
>
> ************
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Approach can't open ...
2000-02-07 20:25 Approach can't open ... Christian Schaer <archiver@db.geocrawler.com>
@ 2000-02-09 01:03 ` Byron Nikolaidis <byron.nikolaidis@home.com>
1 sibling, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 2000-02-09 01:03 UTC (permalink / raw)
To: Christian Schaer <chris.schaer@datacomm.ch>; +Cc: pgsql-interfaces@hub.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-02-09 01:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-07 20:25 Approach can't open ... Christian Schaer <archiver@db.geocrawler.com>
2000-02-08 07:23 ` Jyry Kuukkanen <jyry@neutech.fi>
2000-02-09 01:03 ` Byron Nikolaidis <byron.nikolaidis@home.com>
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