c#对接小众数据库整理（sqlanywhere，Firebird）

hbsyuyang

已于 2022-11-11 12:04:22 修改

阅读量546

点赞数

文章标签：数据库 c# java

于 2022-11-11 12:03:44 首次发布

本文链接：https://blog.csdn.net/u012932582/article/details/127803643

版权

最近在做数据库对接，对接的比较多，记录一下

sqlanywhere比较特殊，需要运行数据库服务，连接需要OleDbConnection类，查询需要OleDbCommand或者SADataAdapter，在测试过程中SADataAdapter打包后无法运行，后用OleDbCommand替代
运行前需要安装SQLA1201_Client程序
SQLA1201_Client安装程序
代码如下

//连接字符串
Provider=SAOLEDB.10;UID={username};PWD={password};SERVER={host};DBN={database};charset=Utf8

//连接方法
 private static OleDbConnection conn;
 public static OleDbConnection Open(string connection)
        {
            try
            {
                if (conn == null)
                    conn = new OleDbConnection();
                if (conn.State == ConnectionState.Closed)
                {
                    conn.ConnectionString = connection;
                    {
                        conn.Open();                    
                        return conn;
                    }
                }
                return conn;
            }
            catch (Exception ex)
            {
                return null;
            }
            
        }
  
//查询方法  ：获取表信息
 static Dictionary<string, string> dic = new Dictionary<string, string>();
 public static List<string> GetTable()
        {
            List<string> ls = new List<string>();
            dic.Clear();
            try
            {
                DataSet ds = new DataSet();
                using (OleDbCommand cmd = new OleDbCommand())
                {             
                	cmd.CommandText = "select table_id,table_name from systable";
                    cmd.Connection = conn;              
                    var dr = cmd.ExecuteReader();
                    while (dr.Read())
                    {
                       
                        ls.Add(dr["table_name"].ToString());
                        dic.Add(dr["table_id"].ToString(), dr["table_name"].ToString());
                    }
                    dr.Close();
                }

            }
            catch (Exception ex)
            {
                
            }
            finally
            {
               
            }
            return ls;
        }

火鸟数据库：
启动前需要注册编码

  Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);

连接字符串

data source={host};user id={username};password={password};port number={port};character set=GB_2312;initial catalog={database};
//utf-8
data source={host};user id={username};password={password};port number={port};character set=Utf8;initial catalog={database}