Wierd ODBC Errors

Anyone have any ideas what this might be?

Hi all,

I'm having some wierd ODBC issues. These issues didn't show up until we attempted to move our program onto a real production server.

My program (a Windows Service, written in C# using ADO.Net) watches for files, parses them, then attempts to find and update a record using FM 6 Unlimited's ODBC Local Data Access compaion.

Usually things go fine; sometimes however, FM 6 reports that no records match the criteria (even though there ARE records that should match), we get a Field Not found error, or we get some other kind of error such as ERROR [HY000] [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Receive failure

ERROR [HY000] [FileMaker][ODBC FileMaker Pro driver]An attempt to fetch forward has failed for table:

The code generates the exact same sql (save for the values in a where clause, but all the fields we use to find the row are the same) so I'm at a loss as to what is wrong.

The Windows Service runs fine on my local development machine (WinXP SP2), and worked fine on a Windows 2003 Server, but won't work on two Windows XP workstations.

Any ideas?

Thanks

Andy

Edited August 24, 200520 yr by Guest