Re: [INTERFACES] Approach can't open ...

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
>
> ************
>
>