Several ways to connect dot net to Sybase database_postfxj’s blog

How dot net connect to Sybase database I recently worked on a project for a power grid company. Because their database is Sybase12.5.1, they simply learned about the Sybase database. But I found that there is very little information about it on the Internet. It took me a lot of effort to get the Sybase database connection and garbled characters done. To sum up 1. Several connection methods and configurations for Net to connect to Sybase12.5.1 database 1. ODBC method Use a connection string when connecting to .Net such as “Driver={Sybase System 11};Srvr=xqc;database=DBData;uid=DB;pwd=11;” Configure ODBC driver steps: a. Confirm that the Sybase12.5.1 client has installed the ODBC driver. b. Click the ODBC data source manager to select the system DSN, and then add the Sybase ASE ODBC Driver in the pop-up dialog box. Click Finish, and the Sybase ODBC detailed configuration window will pop up. c. Input Data Source Name, NetWork Address, and Database Name in the Sybase ODBC detailed configuration window; among them, Data Source Name is used by Srvr in the connection string, and the format of NetWork Address is “Sybase database server IP, port Number”, Database Name is the name of the database you want to access.…