Approach can't open ... - Mailing list pgsql-interfaces

From Christian Schaer
Subject Approach can't open ...
Date
Msg-id 200002072025.MAA27467@www.geocrawler.com
Whole thread Raw
Responses Re: [INTERFACES] Approach can't open ...  (Jyry Kuukkanen <jyry@neutech.fi>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Richard
Date:
Subject: Re: [INTERFACES] Bug in parser?
Next
From: Assaf Arkin
Date:
Subject: Re: [INTERFACES] ConnectionPoolDataSource (JDBC)