Local Intsall of Oracle for ADO

[TheMillionDollarMan]

DO I need a local install of oracle for ADO to work on my wrokstation?

At the moment we have all of Oracle siting on the network and simply point the registry and path variables to the network drive no problem.

Now when I try to connect using ado to an oracle database it says "Provider not installed properly" when trying to open an ADO connection.

I don't want to install all of the oracle fileson my workstation.

Thanks
Dave

 

[zemp]

What is your connection string like?

To see examples for all DB's see

http://www.connectionstring.com.

zemp

 

[Swi]

zemp,

I think you meant

http://www.connectionstrings.com

Swi

 

[johnwm]

Or:

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

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[zemp]

Yes I did, forgot the last 's', thanks Swi.

zemp

 

[TheMillionDollarMan]

thanks but none of these websites or replies answered my question.

 

[chiph]

You'll need the Oracle client installed on your PC to talk to your Oracle server. Check with your DBA to see if you're licensed to install the client -- I don't remember how Oracle does their license counts, whether it's active connections, or number of client installs.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[johnwm]

If you follow the link I gave and scroll down to OLE DB Provider for Oracle you will find the connection string required along with further references on how to access you data

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'