Sudo /Applications/iODBC/iODBC\ Administrator64.app/Contents/MacOS/iODBC\ Administrator64Īfter opening the iODBC Administrator 64-bit, you will see the CData Elasticsearch Source listed under the System tab. To do so, enter the following command into a terminal: To modify the system DSN installed by the driver or create a system DSN, open the iODBC Administrator 64-bit with elevated permissions. You can create user DSNs by opening the iODBC Administrator 64-bit from Launchpad. System data sources can be accessed by all users.Ĭonfiguring a DSN with the iODBC Administrator User data sources are restricted to a user account. Alternatively, you can edit the iODBC configuration files. The most recent version of the CData ODBC Driver for Elasticsearch is 64-bit only. Note that the ODBC Manager must match the bitness of the ODBC driver. To configure a DSN, you can use the iODBC Administrator 64-bit, the GUI installed with iODBC. The driver must be registered with the driver manager and DSNs are defined in the driver manager's configuration files. The driver manager loads the driver and passes function calls from the application to the driver. The driver installation registers the driver with iODBC and creates a system DSN, which you can use in any tools or applications that support ODBC connectivity. You can find the latest version of iODBC on the iODBC site. On macOS, the CData ODBC Driver for Elasticsearch is preconfigured for use with the iODBC driver manager, as are many other products like Filemaker Pro, Microsoft Excel, and Tableau. These refer to your name and your machine's password. You'll be prompted for a name and password. To activate a trial, omit the input.Ĭd "/Applications/CData ODBC Driver for Elasticsearch/bin" In a terminal, run the following commands to license the driver. The CData ODBC Driver for Elasticsearch driver requires macOS Sierra (10.12) or above. This is particularly important if the server is also concurrently running an instance of the Microsoft Desktop Engine (MSDE).This section shows how to set up ODBC connectivity and configure DSNs on macOS. Your database administrator should be able to tell you whether the latest service pack has been applied. NOTE: if the only message you see is "Port Scan has completed", then the server is not listening on that port, or the port is not reachable from your Mac! Contact your database administrator or network support staff to determine the correct port or to have the port opened on your organization's network equipment.įinally, the latest service packs from Microsoft should be applied to the SQL Server. When you use the Port Scan tool to scan the default port 1433, you should see a message that says: Use the Port Scan tool of the Network Utility application to verify your server is listening on the port you have configured, and the port is reachable from your Mac. If you get this message immediately, then you either have the wrong port or the port is being blocked by the network equipment (such as a router or firewall). Use the Ping and Trace Route tools of the Network Utility application in the /Applications/Utilities folder to verify you can reach your server's IP address. If you get this message after waiting more than 60 seconds, then you either have the wrong IP address for the server or the server is not reachable from your Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |