Routine with Problems

chulett · Post by **chulett** » Mon Sep 08, 2008 3:34 pm

How long had this been working before it stopped? I ask because the ODBC drivers only work for 30 days outside of the ODBC stage and then they want you to buy a license for them.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2008 3:49 pm

Whenever the result of a BCI function is other than SQL.SUCCESS or SQL.NO.DATA.FOUND you must use SQLError() to remove the associated information (including code and error text) from the handle. If you do this you will discover the root cause of the problem.

jguerrero · Post by **jguerrero** » Mon Sep 08, 2008 7:51 pm

Thanks

I don't think is a license problem, we have another customer with the same routine and driver runing almost 2 years. Any way Im gonna use SQLError() to obtain more detail and share with you.

Be happy!