Skip to Main Content

Oracle Database Discussions


For appeals, questions and feedback about Oracle Forums, please email Please ask technical questions in the appropriate category. Thank you!

Oracle and VBScript - connection string

2610327Feb 11 2014 — edited Feb 12 2014

Hi all

I'm trying to run the following piece of code with VBscript:

set cn = CreateObject("ADODB.Connection")
set rs = CreateObject("ADODB.Recordset")

ConnectionString ="Provider=OraOLEDB.Oracle; Data Source=" & _
"User Id="&user&";Password="&password&";"

cn.Open connectionString

I got that connection string from - I'd like to use a TNS-less connection.

When I run that code, I get an error saying: Provider cannot be found. It may not be properly installed, but I have the client installed.

I suspect that the client may have not been installed properly, or something else is missing. Any ideas?

In case it helps, this is a 64-bit Win 7 system.


Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2014
Added on Feb 11 2014