The 4D application is located on the PC-1 machine, published on port 19812 (default port). The 4D application is located on the local machine.
To add a DSN, you launch the ODBC Data Source Administrator by selecting Start/Control Panel/Administrative Tools/Data Sources (ODBC).Ĭlick on the "Drivers” tab to check that the 4D ODBC Driver is correctly installed: Applications such as Crystal Reports®, Word and/or Excel can all be OBDC clients, and you can also write your own OBDC client using Python, PHP, C, C++ or any language that enables ODBC use.Īfter running the ODBC Driver installer, you need to define a DSN in order to connect to the desired database. Warning: The 32-bit administrator is found in "syswow64" and the 64-bit one is in "system32." Since this is not intuitive, you need to make sure not to mistake one for the other.įor more information about the ODBC Data Source Administrators, please refer to the following Microsoft technical note:Ī DSN (Data Source Name) is a set of registry keys that enables an application, the ODBC client, to link to the native SQL Server of 4D or 4D Server.
#Driver odbc excel 2010 install
Note: If you install the 32-bit Installer on a 64-bit OS, you must use the 32-bit ODBC Data Source Administrator instead of the default 64-bit one. Remember to uninstall any previous versions of ODBC Driver before installing a new one.
#Driver odbc excel 2010 drivers
You can even install both of the drivers on the same machine. For example, if you are using a 32-bit version of Excel 2010 with a 64-bit 4D Server, then you'll need a 32-bit ODBC Driver. You choose your driver based on the version of your ODBC client, and not that of your 4D or 4D Server. You can download one (or both) of the following files from the 4D web site:
4D provides two versions (a 32-bit and a 64-bit) of the ODBC Driver installer for Windows.