![]() ![]() For more information about advanced initialization properties, refer to the documentation provided with each specific OLE DB provider. The Advanced tab is provider-specific and displays only the initialization properties required by the selected OLE DB provider. Use the Advanced tab to view and set other initialization properties for your data. If your database connection works you will get the following message. In most cases, once you have configured the Connection tab, you can click the Test Connection button to determine if the Jet Excel add-in can connect to your database. If you select the OLE DB Provider for SQL Server, then the server name, type of authentication, and database must be furnished. For example, if you select the OLE DB Provider for Oracle, the Connection tab displays fields for the server name and login. The fields displayed on this tab depend upon the OLE DB Provider selected. On the Connection tab, you can specify where your data is located and how to connect to it. Shown below are the connection tabs for Microsoft OLE DB Provider for ODBC Drivers on the left and the Microsoft Jet 4.0 OLE DB Provider on the right. Once you have selected your data provider, (see previous topic) click the Next button or click on the Connection tab. The OLE DB Provider for ODBC Drivers also requires that you separately configure an ODBC connection to your database. In general, it is faster to use a direct OLE connection instead of ODBC. Likewise, there is an Oracle OLE DB Provider as well an SQL OLE DB Provider, and both of those database types allow ODBC connections. The Jet OLE DB Provider and the OLE DB Provider for ODBC Drivers will both allow direct connection to an Access database file such as Northwind.mdb. One good example of having several valid connection options is MS Access. There are many cases where you have several possible options for connecting to your database. The Provider tab allows you to select the OLE DB Provider that matches your database. If the Data Link Properties window opens with the Connection tab selected, you should click on the Provider tab at the top of the screen to start your configuration. ![]()
0 Comments
Leave a Reply. |