Hello,

Just to let people know, we have run a trace on Oracle and it shows that the ODBC does infact process the insert of each record 1 by 1.

Is there a bulk insert type of 'thing' we could use with openQuery? i.e. I would like to send all 2000 records in 1 go.

the problem is the 'SQL*Net message from client' always waits after each insert.