win7(64bit)中asp.net连接sybase

win7(64bit)中asp.net连接sybase

总的来说有三种方式：

1.ODBC ：需要安装ase odbc驱动。本文里用的是ase15版本

2.OLEDB：需要安装ase oledb驱动，本文版本ase15

3.Sybase.Data.AseClient 连接 。需要Sybase.Data.AseClient.dll文件并在项目里引用。

 

连接字符串参考：http://www.connectionstrings.com/sybase-adaptive

 

 

代码：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.Odbc; using System.Data.OleDb; using Sybase.Data.AseClient;     namespace ConsoleApplication1 {      class Program      {          static void Main( string [] args)          {              DBInfo dbinfo= new DBInfo{                  ip= "---" ,                  port= "---" ,                  uid= "---" ,                  pwd= "----"              };              string sql = "select Psam_id , Tel_no from Itel_reg_info" ;              Console.WriteLine( "测试开始：" +DateTime.Now);              funDll(dbinfo,sql);              Console.WriteLine( "DLL结束：" + DateTime.Now);              funOLEDB(dbinfo,sql);              Console.WriteLine( "OLEDB结束：" +DateTime.Now);              funODBC(dbinfo,sql);              Console.WriteLine( "ODBC结束：" +DateTime.Now);              Console.ReadLine();          }          static void funODBC(DBInfo dbinfo, string sql)          {              string connectionString = @"Driver={Adaptive Server Enterprise};server=" + dbinfo.ip + ";port=" + dbinfo.port + "; uid=" + dbinfo.uid + ";pwd=" + dbinfo.pwd + ";" ;              OdbcConnection myConnection = new OdbcConnection(connectionString);              OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(sql, myConnection);              myConnection.Open();              DataSet ds = new DataSet();              myDataAdapter.Fill(ds);          }          static void funOLEDB(DBInfo dbinfo, string sql)          {              string connectionString = @"Provider=ASEOLEDB;Data Source=" + dbinfo.ip + ":" + dbinfo.port + ";User Id=" + dbinfo.uid + ";Password=" + dbinfo.pwd + ";" ;              OleDbConnection myConnection = new OleDbConnection(connectionString);              OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(sql, myConnection);              myConnection.Open();              DataSet ds = new DataSet();              myDataAdapter.Fill(ds);          }          static DataSet funDll(DBInfo dbinfo, string sql)          {              string connectionString = @"Data Source='" + dbinfo.ip + "';Port=" + dbinfo.port + ";UID='" + dbinfo.uid + "';Password='" + dbinfo.pwd + "'" ;              AseConnection myConnection = new AseConnection(connectionString);              AseDataAdapter myDataAdapter = new AseDataAdapter(sql, myConnection);              myConnection.Open();              DataSet ds = new DataSet();              myDataAdapter.Fill(ds);              return ds;          }      } }

?

1	Class DBInfo：

?

1 2 3 4 5 6 7

class DBInfo {      public string ip { get ; set ; }      public string port { get ; set ; }      public string uid { get ; set ; }      public string pwd { get ; set ; } }

Itel_reg_info表有40万的数据，我实验的结果是funDll 2秒完成，funOLEDB  7秒完成，funODBC 16秒完成。

最后感叹一下，ODBC太坑爹了~~~~~~~