Connect for oracle via ado

When I try to connect to an Oracle Enterprise and Personal Oracle database using the Microsoft ODBC Driver
the following happens.

Personal Oracle
===============

Situation 1
cn.Provider = "msdaora"
cn.open = datasource

works fine
Situation 2
dont specify a provider, works fine unless there is more than 10 parameters to a stored procedure, at which point it crashes

Oracle Enterprise
===================
Situation 1
cn.Provider = "msdaora"
cn.open = datasource

wont Connect

error:
ORA-12203:TNS: UNABLE TO CONNECT TO DESTINATION.
Situation 2:
dont specify a provider, works fine unless there is more than 10 parameters to a stored procedure, at which point it crashes

oracle odbc driver
==================
When I use the Oracle ODBC driver it doesnt retreive data. Why is this? and what provider should I specify.

Thanks
LVL 1
visual_bAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

corvanderlindenCommented:
This works fine for us:

'OLE DB - Provider
strConnect = "Provider=MSDAORA.1;" & _
   "Password=" & mstrPassword & ";" & _
   "Persist Security Info=False;" & _
   "User ID=" & mstrUserID & ";" & _
   "Data Source=" & mstrDataSource
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
visual_bAuthor Commented:
you may lock the question
0
shyamkumarreddyCommented:
Hi Visual_b

Where does ur oracle reside?? if it reside in another system, u would have host string name to connect to oracle.  I hope u know host string name??(i.e,eg user@hostname,password).

U should specify the hostname with odbc or use data link method to connect to any personal/enterprise oracle.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.