Tutorials to .com

Tutorials to .com » Dotnet » Database » . NET connection using oledb and csv format sybase connection

. NET connection using oledb and csv format sybase connection

Print View , by: iSee ,Total views: 6 ,Word Count: 187 ,Date: Sat, 13 Jun 2009 Time: 2:48 AM

Read some previous time. Net in the Guinness database connection and found that not very full, especially in sybase and csv data using these two methods, and now my connection for your reference.

Sybase (oledb)

First of all, the ole need to install the 12.5 client, in the configuration process to add data source. Then. Net can be used.

Provider = Sybase.ASEOLEDBProvider.2; Initial Catalog = database name; User ID = user name; Data Source = Data Source; Extended Properties = ""; Server Name = ip address; Network Protocol = Winsock; Server Port Address = 5000;

Or direct use. Net fool-style to create a new connection.



CSV

oledb

Select *
From OPENDATASOURCE ( 'Microsoft.Jet.OLEDB.4.0',
'Data Source = "c: \ csv \"; User ID = Admin; Password =; Extended properties = Text')...[ filename # csv]


.Net Database Articles


Can't Find What You're Looking For?


Rating: Not yet rated

Comments

No comments posted.