Hello all,
 
I have a customer that uses Pervasive and DBA. My company recently migrated them from SBS 2003 32-bit with Pervasive 9 to SBS 2008 64-bit with Pervasive 10.
 
When we made the move things worked just fine, they could still work within DBA and life was good.
 
Recently we've found that since we migrated servers one of their pieces of software has stopped working. They have an Access database that injects information in to Pervasive (I think is how it works) and it's been giving an error when we attempt to do so.
 
The error they are getting is "Syntax error in INSERT INTO statement." and I am just at a loss to explain what is going on.
 
When we migrated servers I made sure to re-create the System DSN in Data Sources (ODBC) in Administrative Tools on the server and workstations.
 
Do any of you have ideas about this? Any help would be much appreciated!

Thanks for the quick reply!
 
I don't know very much about Pervasive or any of this stuff, so I'm kind of shooting in the dark to get this accomplished -- do you have any more detailed information on how to do what you're suggesting? Sorry