本地安装服务端,没有客户端,本地用命令sqlplus user/passwd@aaa.gov
可以连接到远端服务器
写C程序
int main()
{
EXEC SQL CONNECT :user identified by :passwd using :aaa.gov
if(sqlca.sqlcode !=0)
{
return -1;
}
return 0;
}
错误码为-12154
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
4、在listener.ora添加如下内容:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
这两个文件已经修改了
这个错误应该找不到连接符 本地如果不安装客户端 能有办法找到连接符么??