[此贴子已经被作者于2007-10-8 20:52:42编辑过]
[此贴子已经被作者于2007-10-8 20:52:42编辑过]
10g如果安装成功了,去网上下载一个jdbc驱动,然后用eclipse直接使用ip+端口连接oralce,看可以不
jdbc url。
jdbc:oracle:thin:@202.102.x.x:1521:ORCL
oracle tnsnames.ora 设置
MYORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
[此贴子已经被作者于2007-10-9 15:02:17编辑过]
10g如果安装成功了,去网上下载一个jdbc驱动,然后用eclipse直接使用ip+端口连接oralce,看可以不
jdbc url。
jdbc:oracle:thin:@202.102.x.x:1521:ORCL
oracle tnsnames.ora 设置
MYORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
我就是的这种方法,但有个地方不同:(SERVER = DEDICATED)是什么意思?10g里没有这项,9i里有。
jdbc:oracle:thin:@0923D2DEFD1F435:1521:ORCL
tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0923D2DEFD1F435)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
最初我装的是9i,但那个版本的JDBC有问题,ECLIPSE无法与他连接,后来就装了10g,也是在官方网站下的,安装配置完后出现了1楼的问题,弄我好几天都不行,只有卸了10g,最后无奈买了张9i的盘,最后才弄好了