| title | SQLDriverConnect (Text File Driver) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.reviewer | |||
| ms.technology | connectivity | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | d7769021-bd18-4d8e-96e0-e184a82d6ca3 | ||
| author | David-Engel | ||
| ms.author | v-daenge |
Note
This topic provides Text File Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
SQLDriverConnect enables you to connect to a driver without creating a data source (DSN).
The following keywords are supported in the connection string for all drivers: DSN, DBQ, and FIL.
The following table shows the minimum keywords required to connect to each driver, and provides an example of keyword/value pairs used with SQLDriverConnect. For a full list of DRIVERID values, see SQLConfigDataSource.
Note
If DBQ or DefaultDir is not specified for the Text driver, the driver will connect to the current directory.
| Driver | Keywords required | Examples |
|---|---|---|
| Text | Driver | Driver={Microsoft Text Driver (*.txt;*.csv)}; DefaultDir=c:\temp |