ODBC failure

[Djblois]

Sometimes my Access Program has an ODBC fail, requiring my users to restart the program. Is there a way I can Restart the ODBC connection programmaticely, so my users do not have to restart the program?

[CreganTur]

Can you provide a little more information about this issue? What kind of error message are they getting? Are they using Windows NT Authentication for the ODBC connection or a hard coded username/password? Are you sure that the data source is available when this error occurs? What kind of data source are you trying to connect to via ODBC?

[Djblois]

What kind of error message are they getting?


ODBC--call failed.

[Oracle][ODBC][Ora]ORA-00001: unique constraint (WMS.PKO_HDP1) violated
(#1)
Error#3146


Are they using Windows NT Authentication for the ODBC connection or a hard coded username/password?

Hardcoded

Are you sure that the data source is available when this error occurs?

It should be - it is available than it crashes.

What kind of data source are you trying to connect to via ODBC?

Oracle

[CreganTur]

Sorry, I have no Oracel experience. I know a few of the other guys do, so one of them might be able to help you with this. I've never had an ODBC call fail with SQL Server unless the target data source was unavailable for some reason.