Re: Oracle & ADO (converted from MS-SQL)

First off, go with VB6. The data environment makes it worth it.

Second, download TOAD from www.toadsoft.com to use as a development tool.

Third...
If you are going to stay in a mixed environment (SQL 6.x/7 and Oracle 7/8), then stay with ADO. If so, search Microsoft's KnowledgeBase by the keyword kbOracle and you will find the good and the bad about ADO. Using a DSN-less connection against Microsofts ODBC for Oracle has proven to be a little more stable than Oracle's ODBC.

-=< BUT >=-

If you are going to only have Oracle as your back end, then you should really check out Oracle Objects for OLE for your data access. OO4O is available from the Oracle Client (License Free). If you use OO4O version 2.2 or higher, you can retrieve data faster than ADO 2.x. Plus, you can do all the things ADO can not like return a cursor from a stored procedure, return more than 10 parameters from a stored procedure, perform a true refresh call on data objcets.

Good Luck!

Zane E

Ed. wrote in message <7l9ah9$m2u$1_at_news.iinet.net.au>...
>Hi all,
> We are currently using SQL Server & are planning to migrate our system to
>Oracle. We are using ADO & Visual Basic 5 & 6. I'm interested in getting
a
>general gut feel of how much work is involved, and if there are any obvious
>traps we may fall into. The system is fairly straight forward, it's
running
>a relatively thick client, and we don't use all that many stored procs. I
>don't need any real detail, just a general opinions and comments.
>
>Any comments would be greatly appreciated.
> Ed.
>
>
Received on Mon Jun 28 1999 - 23:47:36 CDT