Common questions

What is a ODBC data source?

author 0

What is a ODBC data source?

Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server.

What databases use ODBC?

Some examples of common ODBC compliant databases are:

  • Microsoft Access.
  • MySQL.
  • Oracle.
  • Microsoft SQL Server.
  • Microsoft Visual FoxPro.
  • IBM DB2.

Is OLE DB deprecated?

The previous Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and SQL Server Native Client OLE DB provider (SQLNCLI) remains deprecated and it is not recommended to use either for new development work.

How do I create a data source name in ODBC?

Creating an ODBC Data Source

  1. Select Start, Control Panel, Administrative Tools, Data Sources (ODBC).
  2. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box.
  3. Select SQL Server as the driver for which you want to set up the data source.

How do I add a data source for the ODBC driver?

To add a data source for the ODBC Driver for DB2 using the ODBC Data Source Administrator. In the ODBC Data Source Administrator dialog, click Add. In the Create New Data Source dialog, click Microsoft ODBC Driver for DB2, and then click Finish. The Microsoft ODBC Driver for DB2 Configuration dialog contains five tabs.

Where are ODBC data sources stored?

File data sources are stored in C:\\Program Files\\Common Files\\ODBC\\Data Sources. User and system data sources are collectively known as machine data sources because they are local to a computer. Each of these data sources has a tab in the ODBC Data Source Administrator dialog box.

What information does ododbc ask for from the user?

ODBC asks for the user ID and password, if required. For example, before generalizing, the connection string looks like this: This connection string specifies a trusted connection, which uses Windows NT integrated security.

How do I use the ODBC data source administrator for DB2?

Using the ODBC Data Source Administrator, you can add/modify/remove connections for use with the Microsoft ODBC Driver for DB2. Data sources are the databases or files accessed by a driver and are identified by a data source name (DSN). Use the ODBC Data Source Administrator to add, configure, and delete data sources from your system.

author

Back to Top