Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mSportsman

    C# Pervasive Data Provider Update command causing Syntax error, but not on development machine.

    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...
  2. mSportsman

    C# Pervasive Data Provider Update command causing Syntax error, but not on development machine.

    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=...
  3. mSportsman

    C# Pervasive Data Provider Update command causing Syntax error, but not on development machine.

    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...
  4. mSportsman

    Trouble with foreign Keys

    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...
  5. mSportsman

    Strange Problem with Identity field

    The reboot of the server seemed to have fixed this issue. Any ideas on how this database may have been affected in this way? MS
  6. mSportsman

    Strange Problem with Identity field

    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...
  7. mSportsman

    Strange Problem with Identity field

    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...

Part and Inventory Search

Back
Top