我的程序要读写 Oracle 数据库,开始我设置 Provider=OraOLEDB.Oracle.1,在自己的机子上可以正常运行,但拿到别人的机子上就不行了,修改成 Provider=MSDAORA.1 后才能正常连接。请问这个参数是不是跟本地机的设置有关?
如果有,我怎样知道在哪台机子上该用什么设置。
另外,User ID 是不是很重要,是不是没有这个参数,在某些机器上就无法连接数据库????
感激不尽!
如果有,我怎样知道在哪台机子上该用什么设置。
另外,User ID 是不是很重要,是不是没有这个参数,在某些机器上就无法连接数据库????
感激不尽!
解决方案 »
- ado连接对象Execute方法执行sql语句的问题
- ODBC 数据库问题
- 递归函数,好心人来帮忙下
- 将数据库的内容显示到listctrl里
- 每年N多人出国,怎么没有人把internal mfc带回中国出版呢?
- 急!请问一个visual2005安装问题。
- 用UDP发送数据包可不可以把服务器和客户端写在一起(一个工程)即是服务器又是客户端.
- 一个简单的网页传输机制,技术总监说可以这么传,我却怎么也得不到值
- 应该是个小问题:如何让按钮一直处于北岸下的状态?
- 请教有关socket传输长字符串的好方案
- 如何判断我的程序在当前的局域网里是否有人正在运行?
- 如何得知另一台计算机共享文件夹下最新的文件名,并拷贝到本机?
MSDAORA 是不是在所有的地方都能用???
For the current Oracle ODBC Driver from Microsoft:oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"For the older Oracle ODBC Driver from Microsoft:oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"
For the current Oracle ODBC Driver from Microsoft:oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"For the older Oracle ODBC Driver from Microsoft:oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"
oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"For more information, see: Microsoft OLE DB Provider for Oracle
OLE DB Provider for Oracle (from Oracle)
For Standard Security:oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"
"User Id=myUsername;Password=myPassword;");For a Trusted Connection: OS Authenticated connect setting user ID to "/"strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=;"); OS Authenticated connect using OSAuthentstrConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;")Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.For more information, see: Oracle Provider for OLE DB Developer's Guide
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdreforacleprovspec.asp?frame=true
Oracle Provider for OLE DB Developer's Guide
http://download-west.oracle.com/otndoc/oracle9i/901_doc/win.901/a90171/using.htm