驱动程序的问题,试试用ORACLE的ODBC或者ORACLE OLEDB Provider。
解决方案 »
- oracle语句筛选,请高人指点简洁写法
- oracle返回数据问题。在线等。
- oracle建立分区表
- 怎么只显示一组里,最大的那个值?
- 100分求助:在ORACLE中如何打印表名,主健字段名,外键字段名和统计主健最大值?
- 使用db configurate assistant的问题,请高手指教
- 选课系统中『上课时间』怎么调整?
- **执行完一段SQL语句后,"if sql%notfound then"表示什么意思?**
- 急!如何在sql语句中对某个字段进行位或操作?
- 如何在存储过程的LOOP中临时创建视图,用完后删除?
- 运行“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
我想请教大家:
是不是日期格式有问题?
或
安装时字符集有问题?字符集有问题的话如何修改呢?
我想请教大家:
是不是日期格式有问题?
或
安装时字符集有问题?日期有问题的话如何修改呢?