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