Approach can't open ...

This message was sent from Geocrawler.com by "Christian Schaer" <chris(dot)schaer(at)datacomm(dot)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