SQLConfigDataSource

The Microsoft® SQL Server™ ODBC driver supports the following SQL Server-specific keyWord/value pairs for data source configuration attribute strings.

KeyWord Values Description Address   Network address of the SQL Server. AnsiNPW yes Default. Specifies that ANSI_NULLS, ANSI_WARNINGS, ANSI_PADDING, and CONCAT_NULL_YIELDS_NULL are set ON for each connection. This allows SQL Server to treat SQL statements as per SQL-92. For more information see Effects of SQL-92 Options.   no Do not use ANSI-defined behaviors for NULL comparisons, padding, warnings, and NULL concatenation. AttachDBFileName file_path Name of the primary file of an attachable database. Include the full path, and escape any \ characters if using a C character string variable:

AttachDBFileName=c:\\AB\\MyDB.mdf

This database is attached and becomes the default database for the connection. To use AttachDBFileName you must also specify the database name in either the SQLDriverConnnect DATABASE parameter or the SQL_COPT_CURRENT_CATALOG connection attribute. If the database was previously attached, SQL Server will not reattach it; it will use the attached database as the default for the connection.