在vb的程序中,打开一个Oracle的连接,但是报如下错误(错误信息是用Err.Description报的),不知道有谁知道怎么解决吗?
Error Number3706:Provider cannot be found.It may not be properly installed.
Error Number3706:Provider cannot be found.It may not be properly installed.
' ADODB FOR Oracle DATABASE
mAdoConn.Provider = "OraOLEDB.Oracle"
mAdoConn.ConnectionTimeout = 30
mAdoConn.CursorLocation = adUseClient
mAdoConn.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};server=shengjian;Data Source=eko.ispacebank.com;User Id=user1;;Password=ekouser1;AutoTranslate=True" mAdoConn.Open //执行了这句后出错了
OpenDBConnection = True
Exit Function
e:
MsgBox "Error Number" & Err.number & "::" & Err.Description
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"