ADO not supported properly in Oracle 8.x 3

[MarcelBeals]

My name is Marcel Beals and I currently work at OCAS in Guelph (Ontario).<br><br>I would like to know what if any are the limitations of ADO in Oracle 8.x ?<br><br>Also can I still run simple D/B queries with Oracle 8.x and ADO?<br><br>Microsoft does not seem to have any idea on this.&nbsp;&nbsp;I sent them a question and they replied search the Knowledge Base.&nbsp;&nbsp;That is it.<br><br>Can you give me any information on this that you have.<br><br>Also I am currently using DAO 3.5.1 to access the Oracle 7.3 D/B through ODBC.&nbsp;&nbsp;<br><br>Can you tell me if I will encounter problems if I continue to use DAO 3.5.1 to access the Oracle 8.x D/B?<br><br>Thanks a million.<br><br><br>Marcel.<br>

 

[Karl Blessing]

for one, DAO only works around Jet Databases(which is one of the major limitations, and why Microsoft's own KB even state DAO isnt around to last), also you need to make sure you have the latest ODBC drivers to support Oracle8, for example, theres known to me Oracle 7.3 drivers, then theres a Microsoft for Oracle Driver. ADO will work with anything you have an ODBC driver for, DAO however will not always work, unless its focused around Jet databases. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[NickBulka]

Karl,<br>&nbsp;&nbsp;&nbsp;DAO will work with any database that has an ODBC driver, not just jet databases.&nbsp;&nbsp;My last project was a publishers web site that used an Oracle database with millions of records through ODBC.&nbsp;&nbsp;No problem.<br><br>Marcel,<br>&nbsp;&nbsp;&nbsp;go to <A HREF="

http://www.actionjackson.com"

TARGET="_new">

http://www.actionjackson.com</A>,

click on search, and type in Oracle.&nbsp;&nbsp;Hope you've got some free time for reading. <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[rajkr]

ADO is much more efficient than others access methods as i found out. here we can connect using ODBC as well as OLEDB. Better if you try using OLEDB. <br>then&nbsp;&nbsp;you will not find any problem regarding Accessibility of data from Oracle 8.x<br><br>&nbsp;

 

[Swany]

ADO works great connected to Oracle 8.X
You can execute simple and complex queries (outer joins, decodes, whatever) You can execute oracle stored procedures, and if they are located in packages, even get recordsets from them. You can manipulate LONG, TEXT and RAW data easily.

We use Oracle 8 for all of our internal data store and web site needs. We run Oracle Applications r11 and have a lot of custom web addons (like an Order Entry Module replacement written by me).

The transition from DAO to ADO can be a little rough for those not familiar with ADO. If you have any problems post them, and I am sure you'll get an answer.