Welcome! Log In Create A New Profile

Advanced

SQL Server + SQLconnect + Insert

Posted by Nathalie 
Nathalie
SQL Server + SQLconnect + Insert
September 01, 2008 05:50PM
Hello!!!

I'm having a weird problem using SQLconnet with sqlnative access.

The point is:
I have a table with a trigger that returns the id inserted.

If i do an insert in the table using a odbc connection everything works ok.
If i do an insert in the table using sqlconnect and access native to connect the sql returns the id but it inserts two lines in the database!!!!! And the id returned is always the second line inserted.


Does anybody knows why???
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: