Use OLEDB to connect to Sybase and CSV format file connections in .NET.

zhaozj2021-02-16  71

I saw some .Net's Daquan. I found that it is not very full, especially Sybase and CSV, and now I will now give me a reference.

Sybase (OLEDB)

First, you need to install 12.5 OLE client, add Data Source to the configuration program. Then .Net can be used.

Provider = sybase.AseoledbProvider.2; Initial catalog = database name; user ID = username; Data Source = Data Source; Extended Properties = ""; Server Name = IP address; network protocol = Winsock; Server port address = 5000;

Or use the .NET's fool-style creation new connection.

CSV

OLEDB

Select * from OpenDataSource ('microsoft.jet.oledb.4.0', 'data source = "c: / csv /"; user ID = admin; password =; extended profment = text') ... [filename # csv]

转载请注明原文地址:https://www.9cbs.com/read-24868.html

New Post(0)