配置 SQL Anywhere 以从 ASE 服务器读取
我有一个 Sybase ASE 服务器,我可以使用 ASE iSql 完全正常地连接到它。我的 sql.ini 文件中的数据库定义如下所示:
[<NAME>]
master=TCP,<servername>,<port>
要与 iSql 连接,我可以进行以下命令行调用并且它可以工作:
isql -U <username> -P <password> -S <NAME>
我的最终目标是使用 SQL Anywhere 的 ADO.Net 实体框架连接来实现 RIA 服务 I'我正在写作。我现在尝试通过 Sybase Central(而不是通过 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 新手。
I have a Sybase ASE server that I'm able to connect to with ASE iSql totally fine. The database definition in my sql.ini file looks like:
[<NAME>]
master=TCP,<servername>,<port>
to connect with iSql, I can make the following command-line call and it works:
isql -U <username> -P <password> -S <NAME>
My ultimate goal is to use SQL Anywhere's ADO.Net Entity Framework connectivity for a RIA service I'm writing. I'm trying to connect now using SQL Anywhere through Sybase Central (rather than through Visual Studio), and can't get it to work. Under the Identification tab, I use and for my credentials and leave the bottom half as "None", under the Database tab, I specify for the Server name, and under Network I check "TCP/IP", and specify as the Host, and as the Port. I get the following error:
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
I'm sorry in advance if I left out significant details. I'm new to Sybase, having a strictly Oracle background. If I left out anything you need to know, please post a comment and I'll update the question. Thanks for helping a Sybase newb.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
没有办法做我所要求的事情(虽然可以使用代理表,但这不是一个理想的解决方案),所以我不打算使用.Net RIA 服务框架。我将编写一个标准的 ASP.Net Web 服务。
There's no way to do what I was asking (though it could be possible with a proxy table, that's not a desirable solution), so I'm not going to use the .Net RIA Services framework. I'm going to be writing a standard ASP.Net web service.