Ora配置文件信息如下,通过ODAC链接数据库时,链接字符串为
testuser/[email protected]:1521:gmzy;但提示无效的SID。
1)有没有办法在客户端找到SID? 客户端通过SQL PLUS或TOAD可以链接到数据库
2)ODAC链接时,是否可以不要SID,只需要用Service_name?如果可以,
请指点链接字符串如何写。 D6+ODAC5.55+ORACLE10g谢谢!# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.TYGSNT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gmzy)
)
)WISETOP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gmzy)
)
)
请注意你输入的需要连接的 Oracle数据库实例名是否有效??
username := 'testuser';
password := 'test';
server := '192.168.10.111:1521:gmzy';
(神奇Delphi)
这个与MYSQL的连接方式“相似”呀