Connection strings for Textfile
Microsoft Jet OLE DB 4.0
Usage Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer Microsoft
Delimited columns
The delimiter can be specified in the registry at the following location:<br/> HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text <br/> "Format" = "TabDelimited"<br/> or<br/> "Format" = "Delimited(;)"<br/>
Fixed length columns
"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.
To specify each columns length use the Schema.ini file. See description below.
Important note!<br/>The quota " in the string needs to be escaped using your language specific escape syntax.<br/> c#, c++ \"<br/> VB6, VBScript ""<br/> xml (web.config etc) &quot;<br/> or maybe use a single quota '.
.NET Framework Data Provider for OLE DB
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to Jet OLE DB 4.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Microsoft Text ODBC Driver
Usage Driver={Microsoft Text Driver (*.txt; *.csv)}
Manufacturer Microsoft
Standard
.NET Framework Data Provider for ODBC
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to Microsoft Text ODBC Driver
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.