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
