Excel
-
编辑 删除
Windows 7下通过Excel2007连接Oracle数据库并对表查询
1. 环境变量的设置1.1 ORACLE_HOME环境变量的设置，我这里指向了我的Oracle 10g的客户端ORACLE_HOME=C:\oracle\product\10.2.0\client_21.2 TNS_ADMIN环境变量的设置,TNS_ADMIN目录下需有tnsnames.ora文件2.ODBC的连接我的OS为Windows7,控制面板>管理工具>数据源(ODBC),这个ODBC为64位的ODBC数据源，因为我们使用的客户端为32位的Oracle 10g客户端，则需要使用32位的ODBC程序来配置连接。32位ODBC的路径默认为
搜博主文章
他的分类
- Oracle EBS Concurrent Progra(1)
- Oracle EBS Concurrent Progra(1)
- Oracle EBS Concurrent Progra(1)
- Oracle EBS Concurrent Progra(1)
- Oracle EBS Concurrent Progra(1)
- Exchange(3)
- Zhihu(1)
- Mobile(2)
- Server(7)
- SOA(14)
- PeopleSoft(4)
- Operating System(1)
- Oracle EBS OPM(2)
- Java(2)
- Oracle EBS Report(3)
- Ruby(5)
- Oracle EBS ADF(2)
- Oracle EBS Profile(2)
- Oracle EBS Others(1)
- Oracle EBS HR(1)
- Oracle EBS Customization(4)
- Oracle EBS API(3)
- Oracle EBS OA Framework(16)
- Add-On(1)
- Oracle EBS GL(3)
- Index(1)
- Oracle EBS RCV(1)
- Performance(9)
- VBA(5)
- Oracle EBS BI Publisher(7)
- Excel(1)
- Oracle EBS WSH(2)
- Books(15)
- Blog(6)
- Oracle EBS Workflow(13)
- Oracle EBS Cost(7)
- ERP Implementation(5)
- Oracle Fusion(1)
- Oracle EBS Purchasing(3)
- Oracle EBS WIP(8)
- Oracle EBS WMS(6)
- ERP(9)
- Oracle Notes(1)
- Oracle EBS AR/AP(5)
- Python(2)
- Oracle EBS MOAC(3)
- Oracle EBS Video(1)
- Oracle(10)
- Architecture(6)
- Oracle EBS Patch(3)
- Oracle EBS Install(9)
- Troubleshooting(46)
- Linux/Unix(14)
- Security(15)
- Oracle EBS DBA(60)
- SQL or PL/SQL(18)
- Oracle EBS INV(41)
- Oracle News(8)
- Oracle EBS Code Sample(6)
- Oracle EBS Dictionary(19)
- Oracle EBS OM(11)
- Doc(4)
- Oracle EBS(31)
- Oracle EBS Dev(41)
- Oracle EBS Debug(22)
- Oracle DB(70)
- Scripts(47)
- EBS NOTES(16)
- Misc(24)
- 默认分类(3)
