The exception does happen every time and never one the first machine. I have even installed visual studio on the other machine so I can run under the IDE debugger.
The first machine always succeeds and the second machine always throws exception.
Both machines are using the same version of the...
Answer to questions:
1. Are you specifying the same values on both machine? You said it's the same OS, but are you giving the same values?
Values From Machine That Works Values From Machine That Throws Exception
Paramerter p1= 1 Paramerter p1= 1
Paramerter p2=...
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...
Could someone please help me see what is going on and how to fix this problem?
My database was working fine then this is what I did:
I needed to add a new column to a table which contains a Foreign Key to another table with a primary key.
I used the PCC's edit table function, and deleted the FK...
Answer to questions:
1. Both databases are running on the same server.
3. ( I did not try this, because I got results from question #4 )
4. I created a new table in the production database, and methods of inserting record seemed to work.
5. There is another table that has a foreign key...
I am having a problem where @@IDENTITY is returning null after a record has been successfully inserted into a table that contains an IDENTITY Column.
The methods I have tried always work again a test database. The same methods sometimes work against the production data, but sometimes they do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.