驱动程序的问题,试试用ORACLE的ODBC或者ORACLE OLEDB Provider。
解决方案 »
- 效率问题
- 求sql语句(类似开关的判断,付详细说明、建表和测试数据插入脚本)
- 问个sql语句
- 安装Oracle11g 64bit关于lib32包的问题。求教
- 给大家推荐一个很好的数据库技术网站
- 用dba studio能否登陆远程数据库?oracle的前几贴我已经送了250分了,再来100
- 请教大家,怎么能用导出的sql文件在access中导入数据呢
- sqlplus环境下如何屏蔽sql语句系统交互啊?
- 急急急…….dmp恢复问题!!!!!
- Oracle dataguard 备库归档日志不全。如何恢复???????
- 运行“OEMC”时,以“登录到Oracle Managemenet Server”时,输入用户密码说“登录身份证明不正确”
- !!P4+redhat linux+oracle的安装问题?
我必须的用ado.
drabit(square): 测试udl,不行的。
大家帮帮忙!
Provider=OraOLEDB.Oracle.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=数据库Microsoft ODBC for Oracle:
Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=数据库;Persist Security Info=True
Microsoft ODBC for Oracle:
Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=数据库;Persist Security Info=True
ado连接串对么?
可就是不行啊
Provider=OraOLEDB.Oracle.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=数据库
2)利用udl,也不行的odbc可以的
是不是ado的问题呢?
我用odbc直接连接,测试都没问题用ado连接,如下dbConn.ConnectionString = "DSN=odbcqd;UID=user;PWD=pass"
也是不行
对比了一下我电脑上C:\Program Files\Common Files\System\ado目录和可以正常连接数据库的电脑的该目录下的几个文件,发现我的文件普遍日期过低,于是拷贝替换,终于正常了!
搂主应该也是这个问题。
但是我不明白的是使什么原因造成我的ado版本过低的?正常的话要怎样升级呢?
可是,利用microsoft ole db provider for oracle 还是不行,为什么呢?
ora_01861:文字与格式字符串不匹配
这是怎么回事呢?如何改正呢?:(
我想请教大家:
是不是日期格式有问题?
或
安装时字符集有问题?
1. Oracle Provider for OLE DB
2. Microsoft OLE DB Provider for Oracle
3. Oracle ODBC Driver
4. Microsoft ODBC for Oracle
5. Oracle Objects for OLE (OO4O) you will receive one of the following errors: (1) Oracle Provider for OLE DB Error Type: Microsoft OLE DB Service Components (0x80070005) Access is denied.
(2) Microsoft OLE DB Provider for Oracle Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to <I>function</I> until these components are installed. Or Error Type: Microsoft OLE DB Provider for Oracle (0x80004005) Oracle error occurred, but error message could not be retrieved from Oracle.
(3) Oracle ODBC Driver Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
(4) Microsoft ODBC for Oracle The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed.
(5) Oracle Objects for OLE (a) while using a GLOBAL.ASA file Error Type: Active Server Pages (0x0) An error occurred while creating object ’OraSession’. (b) not using a GLOBAL.ASA file Error Type: Microsoft VB<I>script</I> runtime (0x800A0046) Permission denied: ’CreateObject’
(6) Other miscellaneous errors (a) The Specified Module Could Not Be Found Solution De<I>script</I>ion -------------------- You need to give the Authenticated User privilege to the Oracle Home by following these steps: 1. Log on to Windows as a user with Administrator privileges. 2. Launch Windows Explorer from the Start Menu and and navigate to the ORACLE_HOME directory. 3. Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. A "Properties" window should appear. 4. Click on the "Security" tab on the "Properties" window. 5. Click on "Authenticated Users" item in the "Name" list (on Windows XP the "Name" list is called "Group or user names"). 6. Uncheck the "Read and Execute" box in the "Permissions" list (on Windows XP the "Permissions" list is called "Permissions for Authe
我想请教大家:
是不是日期格式有问题?
或
安装时字符集有问题?字符集有问题的话如何修改呢?
我想请教大家:
是不是日期格式有问题?
或
安装时字符集有问题?日期有问题的话如何修改呢?