[ExcelVBA] Connect to Oracle using ADO with Run-time error '-2147467259 (80004005)'

 

Hi,

I am trying to extract data from Oracle using ADODB conneciton.
Here is my connection string:

oraConStr = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=" & oraHost & ")(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=" & DBStr & "))); uid=" & User & " ;pwd=" & pwd & ";"
Set oraConnect= CreateObject("ADODB.Connection")
Set oraResult = CreateObject("ADODB.Recordset")
oraConnect.Open oraConStr
Set OraResult= OraConnect.Execute(mySql)

When I run the marco, I got the run-time error '-2147467259 (80004005)'[Microsoft][ODBC driver for Oracle][Oracle].

Could you please help me to tell me what is wrong.

Many Many Thanks

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___