#5 03-29-2012, 10:42 AM vb2008 Regular Join Date: Jan 2008 Posts: 88 Yeah that was navigate here It may not be properly installed." This is my connection string: oConn = Server.CreateObject("ADODB.Connection"); sConn = "Provider=OraOLEDB.Oracle.1;"; sConn += "Password="+password+";" sConn += "User ID="+username+";" sConn += "Data Source="+db.dbname+";Log Level=0"; oConn.Open(sConn) I've Edit :- Sorry, I'm now guessing the interop stuff is left over from when you were referencing other stuff. Watson Product Search Search None of the above, continue with my search "Error 3706 ADODB.Connection - Provider cannot be found. Provider Cannot Be Found. It May Not Be Properly Installed Excel
Thanks Carsten Please click Mark as Answer if this post is of help to you. :-) My Blog Reply Lannie Contributor 3172 Points 1171 Posts problem with MSDAORA provider on 64
If you are already running it in Internet Explorer, I suggest researching the Oracle runtime and making sure Internet Explorer is loading the correct one (or loading it period). I'm realy hopeless... Tell me about your project and I can offer up a quote.Quotes start at $50.00 for a baseline. Microsoft Ole Db Provider For Oracle Forgot your password?
To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! I was using msdaora for my connection string however that does not work in 64bit. All Rights Reserved. | Terms and Conditions Register Help Remember Me? this contact form So it seems you are missing the A in your connect string.
sql oracle vba 64bit connection-string share|improve this question edited Jan 25 '12 at 10:06 Mitch Wheat 216k28347445 asked Jan 25 '12 at 9:54 matyyyy 110517 add a comment| 2 Answers 2 I am looking for an official Oracle statement saying that their installer is not registering the Oledb provider properly. I have attached a screen shot. Thanks Carsten Please click Mark as Answer if this post is of help to you. :-) My Blog Reply yanku Member 10 Points 116 Posts Re: problem with MSDAORA provider on
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate?