I have an app that imports a text file to a Progress db. In my environment it works fine. In my clients environment it fails because the odbc connection is dropped. How do I determine what is causing the connection to drop?

We are both running the same version on Progress, the same os (Win 2000 server). I have traced the code and theirs matches mine exactly except at the same line of code:

-> rs.Open sql, g_cnn.ConnectionObject, adOpenDynamic, _
cls_DataConnection.ConnectionObject[Get]()
-> Set ConnectionObject

and then it stops.

I have run an ODBC Trace and had them do the same. All the code is exactly the same except theirs ends with

vanqu 660-748 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 01653290
UWORD 1

and mine will continue onto do a sql rollback before it closes. Now here is the weird thing. I have one version that will run in their environment. I could rebuild from that version but I would prefer what is wrong that the current version won't work. Any suggestions as to how I research this? I'm worried that if I just fudge it other clients may end up with the same problem. This is an app that will be used by multiple clients.

Help!!!!

Nichole