ORA-03114 ORA-03114 not connected to ORACLECause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.Action: Try again. If the message recurs and the program is user written, check the program.
用sql2000的工具导出数据 第一步:选择SQL2000的“导入导出数据” 第二步:点“下一步” 第三步:数据源请选择“Oracle Provider for OLE DB” 第四步:点“属性” 第五步:数据源输入:oracel网络数据库的网络名。用户名和密码就是oracle数据库的用户名和密码了。测试一下能否连接。 第六步:确定。 其它的就是设置sql的那些了。你肯定会调试了。
happens because a user-written program has not logged on. It may happen if communication
trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM
KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier
because, in those cases, the client's connection to the database is terminated without
waiting for the client to issue a request.Action: Try again. If the message recurs and the program is user written, check the
program.
第一步:选择SQL2000的“导入导出数据”
第二步:点“下一步”
第三步:数据源请选择“Oracle Provider for OLE DB”
第四步:点“属性”
第五步:数据源输入:oracel网络数据库的网络名。用户名和密码就是oracle数据库的用户名和密码了。测试一下能否连接。
第六步:确定。
其它的就是设置sql的那些了。你肯定会调试了。