To connect with an ODBC driver, start by selecting the. This provider acts as a wrapper around the ODBC driver. Here's the generic screen that you see immediately after selecting the. The next step is to provide the connection info for your ODBC driver and your data source. You have two options. Provide a connection string , which you can look up online, or create and test on your computer with the ODBC Data Source Administrator applet. If you already have the connection string or know how to create it, you can skip the rest of this page.
Enter the connection string in the ConnectionString field on the Choose a Data Source or Choose a Destination page, then continue to the next step of the wizard. If you provide a connection string, the Choose a Data Source or Choose a Destination page displays all the connection info that the wizard is going to use to connect to your data source, such as server and database name and authentication method.
If you provide a DSN, this information isn't visible. If you only have a bit driver, or have to use a bit driver, search for or browse to ODBC Data Sources bit instead. Launch the applet. Here's what the applet looks like. Check the name, then go back to the wizard and enter it in the Dsn field on the Choose a Data Source or Choose a Destination page. Skip the rest of this page and continue to the next step of the wizard. This example creates a new System DSN.
In the Create a New Data Source dialog box, select the driver for your data source, then click Finish. The driver now displays one or more driver-specific screens where you enter the info needed to connect to your data source.
For the SQL Server driver, for example, there are four pages of custom settings. Specify the name and description of the data source, and the name of the server running SQL Server to which the data source will connect. The data source name used by an ODBC application when it requests a connection to the data source. For example, "Personnel. Optional A description of the data source.
For example, "Hire date, salary history, and current review of all employees. The name of an instance of SQL Server on your network. You will need to specify a server in the next edit box. In most cases, the ODBC driver can connect by using the default protocol order and the server name supplied in this box.
This field only applies to the connection made to determine the server default settings; it does not apply to subsequent connections made using the new data source. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No.
0コメント