Accessing Oracle 8i using DAO through Visual Basic

[hello07]

Dear Sir,
Can you please tell me how to access Oracle 8i using Data Access Object (DAO) through Visual Basic. i have used DAO in accessing Microsoft Access but dont know how to access Oracle by the same method. i would be greatfull if you please give me a solution.
Thank You,
himadrimukherjee07in@yahoo.co.in

 

[zemp]

DAO is specific to the microsoft Jet engine (Mainly Access). I don't believe you can connect to Oracle with DAO.

You will need to switch to ADO.
See thread709-506184 for information on connection strings.

For ADO tutorials see thread709-530615.

For more information you can search this forum, use the VB help files or search msdn.

Thanks and Good Luck!

zemp

 

[zemp]

You can also search forum222 for information on ADO. Check out the FAQs section of the forums as well.

Thanks and Good Luck!

zemp

 

[CCLINT]

You can make a connection to other ODBC data sources through DAO with ODBCDirect....but don't do it.

Do as Zemp says, using ADO.

Zemp, this thread number Thread709-506184 seems to be wrong.

 

[zemp]

Yes, my thread reference was incorrect. Typo!

I was trying to provide a link to a thread where johnwm posted the following link for ADO connection strings.

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

Thanks and Good Luck!

zemp