我有一个SybaseASE服务器,我可以用ASEISQL连接到它。我的sql.ini文件中的数据库定义如下:
[<NAME>]
master=TCP,<servername>,<port>
要连接ISQL,我可以进行以下命令行调用,它可以工作:
isql -U <username> -P <password> -S <NAME>
我的最终目标是为我正在编写的RIA服务使用SQL Anywhere的ADO.NET实体框架连接。我现在正试图通过SybaseCentral(而不是通过Visual Studio)使用SQL Anywhere进行连接,但无法使其正常工作。在“标识”选项卡下,我使用和作为凭据,并将下半部分保留为“无”,在“数据库”选项卡下,我指定服务器名称,在“网络”下,我选中“TCP/IP”,并指定为主机和端口。我得到以下错误:
Fri Nov 20 2009 13:10:10
13:10:10 Attempting to connect using:
UID=sa;ENG=<servername>;CON=SQL_DBC_15c95350;LOG=<log>;LINKS='TCPIP(IP=<servername>;PORT=<port>)'
13:10:10 Attempting to connect to a running server...
13:10:10 Trying to start TCPIP link ...
13:10:10 TCP using Winsock version 2.2
13:10:10 My IP address is 28.230.56.158
13:10:10 My IP address is 127.0.0.1
13:10:10 TCPIP link started successfully
13:10:10 Attempting TCPIP connection (no sasrv.ini cached address)
13:10:10 Looking for server with name <servername>
13:10:10 Trying to find server at address <servername>
13:10:10 Found server, verifying server name
13:10:10 TCP/IP link, function recv(), error code 0
13:10:10 Sending broadcast to find server
13:10:10 Using broadcast address of: 28.230.56.255:<port>
13:10:10 Using broadcast address of: 28.230.56.255:2638
13:10:10 Sending broadcast to find server
13:10:10 Using broadcast address of: 127.255.255.255:<port>
13:10:10 Using broadcast address of: 127.255.255.255:2638
13:10:11 Resending
13:10:12 Resending
13:10:13 Resending
13:10:14 Resending
13:10:15 Resending
13:10:16 Server not found (no reply received)
13:10:16 Failed to connect over TCPIP
13:10:16 Not attempting to autostart server
13:10:16 Cannot connect to server
如果我遗漏了重要的细节,我会提前道歉。我刚接触Sybase,有严格的Oracle背景。如果我遗漏了你需要知道的东西,请发表评论,我会更新问题。感谢您帮助Sybase新手。