VB6/Oracle

[Chris Wallace]

I am developing a VB6 application which connects to an Oracle Database (Running on a Unix box). The application will run from a Novell file server.

Typical Database size is 30,000 records.

Should I use ADO to bind to the data and perform updates.

OR

Should I stay unbound and fire updates using stored procedures at the back end.

Cheers

[JHausmann]

My preference, mainly because of all the problems I've had with bound controls, is to not use bound controls for anything other than the displaying of data.

I'm not that sure you'll save all that much by updating via a stored procedure vs. doing it via a SQL command. You do have tha advantage of being able to modify stored procedures without having to change code, though...