mSportsman
Programmer
I am developing a C#.NET app using the three tier data model.
On my development machine, this works flawlessly. One other machines with same OS.
An exception occurs - "Pervasive.Data.SqlClient.Lna.k: [LNA][ODBC Engine Interface]Syntax Error."
... This is the full message
Other info I got from the debugger in C# - SQLState proerty from the PsqlException = 37000
(See atachement for full code Link)
Any ideas on what is going on here? How to troubleshoot? etc?
Thanks,
Mike
On my development machine, this works flawlessly. One other machines with same OS.
An exception occurs - "Pervasive.Data.SqlClient.Lna.k: [LNA][ODBC Engine Interface]Syntax Error."
... This is the full message
Other info I got from the debugger in C# - SQLState proerty from the PsqlException = 37000
(See atachement for full code Link)
Code:
connection.Open();
int count = updateCommand.ExecuteNonQuery(); // THIS LINE IF THROWING AN EXCEPTION
if (count > 0)
return true;
else
return false;
Any ideas on what is going on here? How to troubleshoot? etc?
Thanks,
Mike