关于Oracle OCI驱动的使用
我目前已经做的:
1 下载www.oracle.com的jdbc817jdk12-nt
2 解压缩为classes12.zip 和ocijdbc8.dll
3 把ocijdbc8.dll复制到system32
4 win2000PRO平台中set path=E:\[jdbc817jdk12-nt]\;D:\Server\oracle81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;...
5 设置客户端driver:oracle.jdbc.driver.OracleDriver
url:jdbc:oracle:thin:@192.168.0.25:1521:orcl
user:[user]
password:[password]
用jdbc联接提示:
java.sql.SQLException: ORA-06401: NETCMN: 无效的驱动程序指示符
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597) at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:354) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:112) at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:345) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65) at java.lang.Thread.run(Thread.java:536)
有什么建议,谢谢