Member Avatar for 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?

  • 3 Contributors
  • 2 Replies
  • 96 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for 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

Member Avatar for debasisdas

kindly post your code for reference of our experts.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.