[VServer] OSX Client reconnect

Erich Geiersberger erichg at mcmm.com
Sat Jan 31 23:43:01 CST 2004


>  > >  > - When a database disconnect due to time limit of server occurs we
>  > >  > are getting severe crashes of the director app (error 9).
>  > >  > The question is: What do we need to do after such a disconnect on
>OSX?
>  > >
>  > >  > What procedure is needed to reconnect the client?
>  > >
>  > >Yes you can reconnect.


>When the client detected that server disconnected it due to the timeout,
>first of all it(client) closes connection to the server, and then sets error
>code 1023: Connection timed out.
>So to reconnect in such case you can simply open it again with the
>same set of parameters, i.e.
>     OpenDataBase(<the same database name>);
>But keep in mind, that all your stored references to all database objects
>(such like cursors, fields, tables) became invalid by that time, when you
>got 1023 error.

OK I try it that way.


>  > >
>  > >BTW, if you EXPECT to get long time on query, e.g. Db is big, query is
>  > >complex, you can simply set timeout much longer to avoid such disconnect.
>  > >V4MD have commend to change timeout on client.
>  >
>  > I would like to.
>  > But anytime the disconnect occurs, my App crashes, no matter what I try to
>do.
>  > I tried:
>  > - close database and shutdownvalentina
>  > - only shutdownvalentina
>  > - nothing


>You DO NOT need to call any of these routines since at this moment
>connection already closed.

OK.


>  >
>  > In each and any of these cases, before I even try to reconnect I get
>  > an error 9 and poof...
>What is error 9? It does not seems like a socket error code...
>Is this a MAC-specific error code?

This is possibly a result from an attempt to create a cursor while 
the connection has already been terminated by the host. I found some 
lines of code in a MIAW which might have caused this.

Erich



More information about the Valentina mailing list