VB6 Insert to Oracle Causing Crash

[DWFENNEL]

I have a program that has a connection to an Oracle database and is supposed to execute an Insert statement. It runs with no problem until the connection.Execute SQLString command. This causes a crash. The code compiles error free, and I've checked the syntax of the Insert statement and it seems to work.

Any ideas or suggestions as to what might cause this?

[rayofhope]

I have a program that has a connection to an Oracle database and is supposed to execute an Insert statement. It runs with no problem until the connection.Execute SQLString command. This causes a crash. The code compiles error free, and I've checked the syntax of the Insert statement and it seems to work.

Any ideas or suggestions as to what might cause this?

Hi,

Did you try to execute the same insert statement in sql plus ?
If it is running properly, I suspect u hv some problems with your driver.
Why dont you try any other driver? If you use Oracle driver, try microsofts;
or if you use microsoft, try oracles..

Please post your results

Regards

[debasisdas]

kindly post your code for reference of our experts.