Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

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.
0
jsstanley
Asked:
jsstanley
  • 2
1 Solution
 
hnasrCommented:
can you reproduce the issue on another computer? May be a corrupted driver issue
0
 
jsstanleyAuthor Commented:
This problem seems to be a nuance of the driver.  We changed the version of the database and the problem was solved.
0
 
jsstanleyAuthor Commented:
This solved the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now