.net framework 4.8 使用GeneralData.GBase8s.DataProvider.dll 连接GBase8sV8.8数据库报错
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】:GBase8sV8.8_3.6.3_3X2_x86_64(开发版)
【操作系统】:window11
【CPU】:
【问题描述】*:代码内配置好后connection.Open();报错:ERROR [HY000] [GBasedbt][GBasedbt ODBC Driver][GBasedbt]Unspecified System Error = -23101. 具体测试代码如下
public static GbsConnection GetGbsConnection(string dbName)
{
GbsConnectionStringBuilder builder = new GbsConnectionStringBuilder();
// 设置连接参数
builder.Host = "192.168.2.190"; // 数据库服务器IP
builder.Service = "9088"; // 端口号
builder.Protocol = "onsoctcp";
builder.Server = "gbase01"; // 数据库服务名称
builder.Database = dbName; // 数据库名称
builder.UID = "gbasedbt"; // 用户名
builder.Pwd = "GBase@123"; // 密码
builder.DbLocale = "zh_CN.utf8"; // 数据库字符集
builder.ClientLocale = "zh_CN.utf8"; // 客户端字符集
// 构建连接字符串
var connstrTest = $"{builder.ConnectionString};";
var conn = new GbsConnection(connstrTest);
return conn;
}
public static bool HasDb()
{
using (var connection = GetGbsConnection("sysmaster"))
{
try
{
connection.Open();
Console.WriteLine("连接成功!");
var cmd = connection.CreateCommand();
cmd.CommandText = "select name FROM sysdbspartn";
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine(reader.GetString(0));
if (reader.GetString(0).Trim() == “testdb”)
{
return true;
}
}
}
else
{
Console.WriteLine("查询结果为空");
}
}
return false;
}
catch (Exception ex)
{
Console.WriteLine($"连接失败:{ex.Message}");
}
}
return false;
}
评论
热门帖子
- 12025-12-01浏览数:182764
- 22023-05-09浏览数:25062
- 42023-09-25浏览数:18526
- 52020-05-11浏览数:17529