Sybase AdoNet4 AseClient v16。x(客户端无法建立连接)

I have a Sybase client app, which is written in C# using ADO.Net 4.0. Code has reference to Sybase.AdoNet4.AseClient.dll assembly file.

我有一个Sybase客户端应用程序，它是用ADO来编写的。Net 4.0。代码引用Sybase.AdoNet4.AseClient。dll组件文件。

On my (DEV)box, app works perfectly and no issue.

在我的(DEV)框中，应用程序运行良好，没有问题。

When I move this app, along with Sybase.AdoNet4.AseClient.dll file on to a Windows 2008 server (#1), and run the app.. it is unable to get a successful connection to Sybase DB! It is throwing below error.

当我移动这个应用时，和Sybase.AdoNet4.AseClient一起。dll文件到Windows 2008服务器(#1)，并运行应用程序。它无法成功连接到Sybase DB!它正抛出错误。

Client unable to establish a connection

无法建立连接的客户端。

Checked stack trace message, it not useful.

检查堆栈跟踪消息，它没有用处。

at Sybase.Data.AseClient1.AseConnection.Open() at Sybase.Data.AseClient.AseConnection.Open()

在Sybase.Data.AseClient.AseConnection.Open Sybase.Data.AseClient1.AseConnection.Open()()

Connection string is made up of Data Source=xxx.xxx.xxx.xxx; Port=1234; Database=dbname; Uid=username; Pwd=password; ConnectionIdleTimeout=nnn;

连接字符串由Data Source= xxxx . xxxx .xxx组成。端口= 1234;数据库= dbname;Uid =用户名;Pwd =密码;ConnectionIdleTimeout = nnn;

Data Source=xxx.xxx.xxx.xxx is Server(#2) and it is pingable and no issue there (response time<1ms TTL=255).

数据源= xxx.xxx.xxx。xxx是服务器(#2)，它是pingable，没有问题(响应时间<1ms TTL=255)。

1 个解决方案

#1

Try adding Charset=iso_1 (or the appropriate charset) to your connection string. This resolved my issue.

尝试将Charset=iso_1(或适当的字符集)添加到连接字符串。这解决了我的问题。

e.g.:

例如:

Data Source=xxx.xxx.xxx.xxx; Port=1234; Database=dbname; Uid=username; Pwd=password; ConnectionIdleTimeout=nnn;

would now be:

现在是:

Data Source=xxx.xxx.xxx.xxx; Port=1234; Database=dbname; Uid=username; Pwd=password; ConnectionIdleTimeout=nnn;Charset=iso_1;

#1