reading data w/o using odbc

[Nanda]

My client wants to access the Oracle and SQL database from ASP without using ODBC....I do not know if it is possible!! and how!! If I use OLE-DB that also uses ODBC layer in between.

If anybody has done this before or doing....please let me know. Please also give your suggestions/comments to convience to client on this point.

I would really appreciate quick response(s).

Thank you

 

[RobSchultz]

If what the client is asking for is to be able to access databases without using an ODBC DSN then...

http://www.able-consulting.com/ADO_Faq.htm

Otherwise, I don't know. If someone else does I would be interested in seeing the solution I .

Later,
Rob
robschultz@yahoo.com
-Focus on the solution to the problem, not the obstacles in the way.-

 

[BigLar]

Use the MS OLEDB provider for Oracle or the Oracle OLEDB provider for Oracle. Neither of these use an ODBC driver. The first is twice as fast as the MS OLEDB Provider for ODBC and the second is four times as fast (but only works with Oracle 8i). Use the ADO Add and Update methods to maintain a single syntax for updates against both Oracle and SQL*Server.

You should also use the OLEDB Provider when accessing the Jet databse because there is a threading problem in the ODBC driver and the Jet Engine that is avoided when using the OLEDB provider.

If you create an ActiveX DLL with VB that has methods that do the database I/O, you can code two-phase transactions VERY easily and will get very fast response because MTS can pool the database connections. However, there is a fairly steep learning curve if you have never created an ActiveX DLL with VB. Seel the COM Tutorial at Developmentor.Com (Developer resources). You can ignore the advice about using interfaces to keep things simpler.

Good luck!

Larry
Larryh@ecn.ab.ca