Jump to content
Sign in to follow this  
JonoUNC

ODBC Client returns a HY000 - Unknown Error

Recommended Posts

I've written an .NET client using ODBC to connect to a fp5 on a remote FM 5.5 server.

 

After opening FM 6 on the same PC as the .NET client and opening the fp5 remotely, the first action by the .NET client application (whether it be an INSERT or UPDATE) seems to take a very long time (3-4 minutes) before returning an ODBC exception - HY000-Unknown error. The .NET client catches the exception and displays a message box to the user. The user clicks OK and if there are more records in the batch to process it continues with no further errorrs.

 

The outcome for the first record attempted is not certain...sometimes the record is inserted/updated successfully (after a long wait), other times no action occurs and occassionally a partial or empty record in written if the action is to INSERT. Subsequent records in the first batch are always updated/inserted correctly with no delays or errors. And, as long as I keep the remote fp5 file open on the client PC and connected, any subsequent batches of records are update/inserted with no issues.

 

Any ideas why the OBDC driver seems to hang on the first operation to be performed (after opening the remote fp5)?

 

Thanks in advance!

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.