Link to home
Start Free TrialLog in
Avatar of jsstanley
jsstanleyFlag for United States of America

asked on

ODBC Driver Problem

I'm using an ODBC driver created by SmartWare Corporation in my VB.net program.  The driver has some association with faircomm though I'm not certain what that association is.  Unfortunately SmartWare Corporation is no longer in business and support is limited to other users.  So far I've been unable to solve the problem I'm facing and I'm hoping that someone may recognize these symptoms from another ODBC driver or from their experience with ODBC in general and have some insight.

If I edit an existing record (call it #1) and save it and then insert a new record (call it #2), record #2 is inserted as expected and the contents of record #1 are overwritten with the contents of record #2.

At this point if the database file is opened in the main software, any changes to either record also affect the other record.  If record #1 is deleted, so is record #2 and vice-versa.

Anyone ever experienced similar behavior using ODBC drivers?  Any ideas where I might garner more clues.
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

can you reproduce the issue on another computer? May be a corrupted driver issue
ASKER CERTIFIED SOLUTION
Avatar of jsstanley
jsstanley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jsstanley

ASKER

This solved the problem.