Re: Best way to access Oracle databases with VB4???

Mark Wagoner wrote:
>
> I have used RDO, direct ODBC API calls and Oracle Object for OLE with VB 4.
> IMHO, RDO is the easiest but the slowest and most limiting, ODBC calls is
> fast but requires a considerable amount of coding. OO4O is easy, relativly
> fast and similar to RDO code wise. OO4O is gets my top vote.
>
> For SQL*Net, I use the Easy Config (as opposed to Network Manager) to
> create the connection name on the client. You then pass this as one of the
> parameters to the open statement, regardless of which access method you
> use. Once you have done it a dozen times or so, it gets fairly easy.

I'm currently using the same set-up. Using the version 2.1 Oracle Data Control with the reqular MS VB4.0 bound controls. I use the Oracle Data Control to pass SQL statements back and fourth to the database and everything seems to work well, but watch out!

I have noticed (has anyone else?) that the Oracle Data Control's Reposition event fires at the wrong time. My testing has shown that the sequence of events are as follows: Request new record, Validate event, Reposition event, move pointer to new record. Shouldn't the Reposition event fire after moving the pointer to the new record?

-- 
Tom Grable, Allentown, PA
mailto:tgrable_at_fast.net
http://www.users.fast.net/~tgrable/index.html
"One day I wished for a fish and I got one!"