This blog provides steps to test ODBC Connectivity with Microsoft Excel 64 bit in Mac • Run the below command to verify installed Excel is 64 bit file -N file -N '/Ap plic atio ns/M icro soft Excel.app/Contents/ MacOS/Microsoft Excel' /App lica tion s/Mi cros oft Exce l.ap p/Co nten ts/M acOS /Mic roso ft Excel: Mach-O 64-bit executable x86_64 This indicates the installation is 64 bit. • In case the installation is 32-bit follow the link to upgrade to 64-bit • Download and install iODBC 64-bit GUI administrator from the below link • Create DSN through the iODBC 64-bit GUI administrator. IODBC can be opened either through Command line or Finder Window • To launch from Command line, execute open command from the Terminal Window with the binary path open '/Ap plic atio ns/i ODBC /iOD BC Admi nist rato r64. Actual Technologies ODBC drivers let Mac OS X users connect to enterprise databases using common desktop applications such as Microsoft Excel and FileMaker Pro. All drivers feature native installers, setup assistants, and on-line help to get you connected to your database as quickly as possible. Jul 12, 2018 - Installing the Driver and Importing MongoDB Data into Excel. Installing the ODBC driver on both Mac and Windows is quick and simple. If you are using Windows. On Mac OSX, the ODBC driver 64-bit. In this post, we'll walk. ![]() App/ Cont ents /Mac OS/i ODBC Administrator64 ' • To launch iODBC through Finder, navigate to the iODBC folder and click on the iODBC Adminsitator64.app If you are using Finder Window to launch iODBC GUI follow the instructions given in the “ Known issues and solution” section below before going ahead with below step • Create required DSN and click on the “Test” connection button in iODBC GUI to verify the connection is successful • Start Microsoft Excel. Excel can also be started through Command line arguments or Finder Window • To open the Data Connection Wizard, Select Data > Get External Data > From Database > iODBC Data Source Chooser > Choose the required DSN • If your data is displayed properly in the Excel, then iODBC Data Source is connected Known issues and solution • You might get SQLAllocEnV failed error while doing the Test connection of the created DSN when iODBC GUI Administrator is opened through Finder window. Follow the below steps to solve the error • Create a shell script 'iODBC Administrator64.sh' in the iODBC application bundle directory /App lica tion s/iO DBC/ iODB C Admi nist rato r64. App/ Cont ents /Mac O S • Open the iODBC Administrator.sh in text editor and enter the following commands: #!/usr/bin/env bash –l export DB2CODEPAGE=1208 logger '`dirname '$0 '`/iODBC' exec '`dirname '$0 '`/iODBC' $@ The logger command will just log the path of the iODBC Administrator executable to the system.log as a debugging aid • In the Terminal set the executable flag of the shell script iODBC Administrator64.sh, i.e.: chmod +x '/Ap plic atio ns/i ODBC / i OD BC Admi nist rato r64. Ap p /Co nten ts/M acO S /iODBC Administrator64.sh' • Open the iODBC Admi nist rato r64. App' s Info.plist and change the value for the key CFBundleExecutable from iODBC Administrator64 to iODBC Admi nist rato r64. Sh • MacOS X does not automatically detect that the iODBC Admi nist rato r64. App' s Info.plist has changed. Therefore, you need to force update the LaunchService database in the Terminal by usin g the lregister comm and: /Sys tem/ Libr ary/ Fram ewor ks/C oreS ervi ces. Fram ewor k/Fr amew ork s /Lau nchS ervi ces. Fram ewor k/Su ppor t/ls regi ster -v -f '/Ap plic atio ns/i ODB C /iODBC Admi nist rato r64. App' • The next time you launch iODBC Administrator from the Finder Window the error SQLAllocEnv Failed won’t be seen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |