C#.net連接配接Sybase的方法

õ©Ç ÒÇüODBCµû╣Õ╝ÅÞ┐×µÄÑ

1 Õ«ëÞúàSybaseÕ«óµêÀþ½»,Õ«ëÞúàODBCÚ®▒Õè¿,Úàìþ¢«DSN<þòÑ>

2 Þ┐×µÄÑõ╗úþáü

string strconn = "DSN=TEST;SRVR=TEST;DB=DB;UID=sa;PWD=;";
OdbcConnection SybaseConn = new OdbcConnection(strconn);
OdbcDataAdapter da = new OdbcDataAdapter("select * from TableName",SybaseConn);
DataTable dt = new DataTable();
da.fill(dt);      

õ║îÒÇüþö¿Sybase.Data.AseClientÞ┐×µÄÑ

1 õ©ïÞ¢¢ Sybase.Data.AseClient.dll sybdrvado11.dll sybdrvssl.dll õ©ëõ©¬DLL ,õ©ïÞ¢¢Õ£░ÕØÇ:DLLõ©ïÞ¢¢ http://files.cnblogs.com/ShuiMu/sybase_dll.rar

2 Õ░åÞ┐Öõ©ëõ©¬DLLµïÀÞ┤ØÕê░binþø«Õ¢òõ©ï

3 Õ£¿Úí╣þø«õ©¡µÀ╗ÕèáÕ»╣Sybase.Data.AseClient.dll þÜäÕ╝òþö¿

4 õ╗úþáüõ©¡µÀ╗Õèá:using Sybase.Data.AseClient;

5 Þ┐×µÄÑõ╗úþáü

//þö¿Sybase.Data.AseClientÞ┐×µÄѵò░µì«Õ║ô
//data source µ£ìÕèíÕÖ¿IPÕ£░ÕØÇ
//database  µò░µì«Õ║ôÕÉìþº░
//charset Õ¡ùþ¼ªÚøå(µ£ìÕèíÕÖ¿õ©ÄÕ«óµêÀþ½»Þªüþø©ÕÉî ÕɪÕêÖõ╝Üõ╣▒þáü)
//port þ½»ÕÅúÕÅÀ
//uid sa  õ©ìÞºúÚçè
AseConnection con = new AseConnection("Data Source=Server IP;database=DB;charset=cp850;Port=þ½»ÕÅúÕÅÀ;UID=sa;PWD=");
AseDataAdapter da = new AseDataAdapter("select * from BFBHDD.Mytest", con);
da.Fill(dt);      

 

Sybase Ú®▒Õè¿þÖ¥Õ║ªõ║æõ©ïÞ¢¢Õ£░ÕØÇ´╝Ü

Úô¥µÄÑ´╝Ühttps://pan.baidu.com/s/1oXGjLBYfIiHTWrHvq0LTOw

µÅÉÕÅûþáü´╝Üe04e

ÕñìÕêÂÞ┐Öµ«ÁÕåàÕ«╣ÕÉĵëôÕ╝ÇþÖ¥Õ║ªþ¢æþøÿµëïµ£║App´╝îµôìõ¢£µø┤µû╣õ¥┐Õôª

 

Þ¢¼Þ¢¢õ║Ä:https://www.cnblogs.com/xubao/p/10984126.html