DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

VB6 Insert to Oracle Causing Crash

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Dec 2007

Posts: 3

Reputation: DWFENNEL is an unknown quantity at this point

Solved Threads: 0

DWFENNEL

Offline

Newbie Poster

VB6 Insert to Oracle Causing Crash

Apr 29th, 2008

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?

•

Join Date: Apr 2008

Posts: 8

Reputation: rayofhope is an unknown quantity at this point

Solved Threads: 2

rayofhope

Offline

Newbie Poster

Re: VB6 Insert to Oracle Causing Crash

Apr 29th, 2008

•

Originally Posted by 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?

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