Defining the SQL Server database interface

To define a connection through the MSOLEDBSQL SQL Server or SQL Native Client interface, you must create a database profile by supplying values for at least the basic connection parameters in the Database Profile Setup - SQL Server or Database Profile Setup - SQL Native Client dialog box. You can then select this profile at any time to connect to your database in the development environment.

For information on how to define a database profile, see Creating a database profile. For a comparison of the database parameters you might have used with existing applications and those used with the MSOLEDBSQL and SNC database interfaces, see Migrating from the MSS or OLE DB database interfaces.