2,496
社区成员
发帖
与我相关
我的任务
分享BDE连接失败的
安装ORACLE后，用PLSQL正常登陆，但是用BDE连接的时候连接失败
TYPE :ORACLE
SERVER NAME :TSYW_5
USER NAME: tsyw
tnsnames.ora中配置
TSYW_5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 42.0.96.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tsywdb)
)
)
TYPE :ORACLE
SERVER NAME :TSYW_5
USER NAME: tsyw
tnsnames.ora中配置
TSYW_5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 42.0.96.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tsywdb)
)
)
...全文
请发表友善的回复…
发表回复
编程保姆 2012-05-17
- 打赏
- 举报
TYPE :ORACLE
SERVER NAME :TSYW_5
USER NAME: tsyw
tnsnames.ora中配置
TSYW_5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 42.0.96.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tsywdb)
)
)
将TSYW_5 = 改为TSYW_5.WORLD看看
SERVER NAME :TSYW_5
USER NAME: tsyw
tnsnames.ora中配置
TSYW_5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 42.0.96.5)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tsywdb)
)
)
将TSYW_5 = 改为TSYW_5.WORLD看看
编程保姆 2012-04-26
- 打赏
- 举报
你的BDE设置有问题！但我没有带手提电脑要上班，下班后可以给你解决！
liangyan5811@163.com ,将你的QQ发过来
liangyan5811@163.com ,将你的QQ发过来
编程保姆 2012-04-26
- 打赏
- 举报
千万不要用ADO，会后悔的！我用的就是BDE+ORACE 12年都是这样！快，效率高 6个月写了一个印花厂的ERP系统，一个人
NoMore 2012-04-14
- 打赏
- 举报
BDE链接器不是很安全。建议最好用ADO链接数据库吧。
ork123 2012-04-01
- 打赏
- 举报
错误为
General SQL error.
ORA-03114未连接到ORACLE
General SQL error.
ORA-03114未连接到ORACLE
