vb,asp,delphi是这样连的,不知道vc?
你把对应的用户名,密码, 数据库别名改自已的"Provider=MSDAORA.1;" & _
"Password=qsun;User ID=qsun;" & _
"Data Source=manu;"
你把对应的用户名,密码, 数据库别名改自已的"Provider=MSDAORA.1;" & _
"Password=qsun;User ID=qsun;" & _
"Data Source=manu;"
解决方案 »
- Oracle提示数据文件坏块。
- 移植存储过程有错
- ORA-01033的问题
- ORA-01139错误,请人看看(急!在线等!!!)
- ORACLE如何调用过程返回一个值
- 。NET连接oracle 10G出错的问题 无法加载 DLL (OraOps10.dll)。
- 一个关于lsnrctl start的问题,急!!!!
- *********************Oracle9i导入数据的问题!!!!!
- 菜鸟问:oracel怎么把表link到access啊?在access里面改数据会影响oracel里面的吗?
- oracle的sql准确的执行时间
- 请教:从其他数据库到ORACLE数据类型的变化
- 什么地方可以下载Designer?
不好用啊
("Provider=MSDAORA.1;Server=pacs;Data Source=PACS;","PACS","pacs",adConnectUnspecified)
语法有错误么?
m_pConnection->Open("Provider=MSDAORA.1;Data Source=pacs;Persist Security Info=True","PACS","pacs",adConnectUnspecified);
不行啊,还是异常
Open("Provider=MSDAORA;Data Source=pacs;User Id=PACS;Password=pacs","PACS","pacs",adConnectUnspecified);
还是不行啊。
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.Open "Provider=MSDAORA.1;" & _
"Password=qsun;User ID=qsun;" & _
"Data Source=manu;"
Set cmd = New ADODB.Command
cmd.ActiveConnection = conn
cmd.CommandType = adCmdText
cmd.CommandText = "{call pkg_typ.pro_test(?,{resultset 0, p_cur})}"
cmd.Parameters.Append cmd.CreateParameter("p_id", adNumeric, adParamInput, 10, 1)
Set rs = cmd.Execute
Do Until rs.EOF
Debug.Print rs.Fields(0)
rs.MoveNext
Loop
rs.Close
conn.Close
End Sub
没有问题,可以进
_bstr_t strCnn("Provider=MSDAORA.1;Password=pacs;User ID=PACS;Data Source=pacs;Persist Security Info=True;");
pConnection->Open(strCnn,"","",adConnectUnspecified);我快崩溃了,呵呵,我以前没用过oracle,想不到连上去这么困难
天啊,终于搞定了,不能用Provider=,必须用Driver,草,日他先人板板
谢谢: beckhambobo(beckham) ,谢谢大家,一会给分