Re: Managing ODBC Connections

[larrytafelski]

Hi, I am looking into creating a production object
interface to a SQL database and was thinking of using the
built in DB function. What problems are you seeing? What
platform are you running on?

Thanks,

Larry Tafelski

> To all developers using an ODBC connection to access a
> database from Impact. I'm interested in your methods to
> manage the ODBC connection from within a prod object in an
> SFM. How do you detect the loss of a ODBC connection to
> prevent a messages from canceling?
>
> I've given up on using the Built-in DB function and now
> attempting to use the exec() function in a custom filter.
> Works great but if the ODBC connection is lost (ex.
> database restart), the exec stmt will fail and the message
> is canceled. The rv can be inspected from the exec stmt
> and a connectStr() function issued to re-connect but the
> message cancels immediately when exec() fails. I'm trying
> to prevent the canceling of the message.
>
> Looking for a method to determine the health of the ODBC
> connection prior to issuing an exec()function so that a
> new connection can be made if necessary.
>
> Anyone aware of ODBC options that would auto reconnect?