ADO connection to oracle db

[neemi]

Can someone please tell me do I need oracle client installed on my pc to connect to an oracle db using ado?

sorry if i am being dum but I have come accross the connection string as follows:

objADO.Open "Driver={Microsoft ODBC for Oracle}; CONNECTSTRING=TESTDB; UID=USER001; PWD=PASS001;"

but it doesn't work and when reading up on connecting to oracle there is mention of 'tnsnames.ora'.

I get an error stating the Oracle client and networking componants were not found!!

ie. "It would be defined by the file of 'tnsnames.ora' or others as standard method."

Advise appreciated and guidance appreciated.
Neemi

 

[PHV]

do I need oracle client installed on my pc to connect to an oracle db
Yes

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[neemi]

Thankyou!

so basically anyone using the excel frontend tool which makes the ado connection to oracle will need this installed also? and there is no other simpler(cheaper) way around it?

 

[PHV]

In fact, you need an oracle ODBC driver installed.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[neemi]

That is the "Microsoft ODBC for Oracle" right?

so as long as this is installed am i right in thinking i can get away without installing the oracle client? as i can view the oracle db objects via the "Oracle SQL developer Tool".

 

[PHV]

Have a look here:

http://www.connectionstrings.com/oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Yes, you can use the Microsoft QDBC dtive for Oracle.

Yes, each user must have that driver configured. The DB access is base on the TNSNames, so I believe that each must have some basic Oracle installed.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[neemi]

Thank you. Have ben looking to find some instructions on what needs to be configured in the most cost effective way and also how to actually configure what ever needs to be!

Trying to find a dummy guide almost! :-o