Subject Re: [IBO] TIB_Connection.SchemaCacheDir Exception
Author Helen Borrie
At 09:45 PM 13/04/2005 +0000, you wrote:


>My app uses a local connection and in starting up I find that there is
>about a 0.5 second reduction in startup time if I set the connections
>SchemaCacheDir--which is nice. But it also always raises an exception
>in the IDE:
>
>---------------------------
>Debugger Exception Notification
>---------------------------
>Project TRAK.exe raised exception class EIB_ISCError with message 'ISC
>ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -204
>Table unknown
>IBO$SCHEMA_VERSION
>At line 3, column 1.
>'. Process stopped. Use Step or Run to continue.
>---------------------------
>OK Help
>---------------------------
>
>which makes it a pain when just trying to run the application. Besides
>not setting the property in the IDE, is there a way to get around the
>exception?

Answering a question with two questions:

1. Do you see any exception message in the application if you choose Run
to continue?
2. What happens when you run the app outside the IDE?

I ask this because, AFAIR, the exception is deliberate - if
IBO$SCHEMA_VERSION doesn't exist, i.e. the exception occurs, then IBO
handles the exception by proceeding to create it and populate the table,
before going on to create the cache files.

Could you report back, please?

Helen