Wierd ODBC Errors

[AndyJ]

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, 2005 by Guest