• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

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
0
visual_b
Asked:
visual_b
1 Solution
 
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
 
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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now