Maybe 4D needs to release 64-drivers?
$ /usr/local/iODBC.odbcmanager/bin/iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0607.1008
Enter ODBC connect string (? shows list): ?
DSN | Driver
------------------------------------------------------------------------------
eee | 4D v11 ODBC Driver
ii | 4D v14 ODBC Driver
Sapphire DR v14 | 4D v11 ODBC Driver
Enter ODBC connect string (? shows list): ii
1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(/Library/ODBC/4D v14
ODBC-Driver.bundle/Contents/MacOS/4D v14 ODBC-Driver, 6): no suitable image
found. Did find:
/Library/ODBC/4D v14 ODBC-Driver.bundle/Contents/MacOS/4D v14
ODBC-Driver: mach-o, but wrong architecture (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be
loaded (0) SQLSTATE=IM003
Or am I reading this wrongly?
James.
> On 6 Sep. 2016, at 5:17 pm, James Brown <[email protected]
> <mailto:[email protected]>> wrote:
>
>
>> On 10 Oct. 2015, at 1:42 am, Keisuke Miyako <[email protected]
>> <mailto:[email protected]> <mailto:[email protected]
>> <mailto:[email protected]>>> wrote:
>>
>> I don't have Office 2016, but is it not a 64 bit application?
>>
>> in that case, then I guess you need to use the 64 bit version of ODBC Driver,
>> which has been available since 14R2.
>>
>> http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html
>> <http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html>
>> <http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html
>> <http://doc.4d.com/4Dv15/4D/15/4D-ODBC-Driver.100-2400401.ja.html>>
>>
>>> 2015/10/09 9:31、James Brown <[email protected]
>>> <mailto:[email protected]>> のメール：
>>> Downloaded that, but it is from 2002 and is a PowerPC app, so won’t work on
>>> modern versions of OS X.
>>> In recent MS Excel, I’m using gate Get External Data/From Database which
>>> opens iODBC Data Source Chooser inside Excel.
>>
>
> Trying this again, with Office 2016. Ie Microsoft Excel for Mac version
> 15.25.1 (160826). This is the new 64-bit one. Does that make a difference?
>
> Has anyone had any luck getting Excel to connect TO 4D via ODBC?
>
> All the info and the driver on the 4D web site seem to be about getting info
> FROM 4D using ODBC.
>
> I’m sure I’ve set something up incorrect in iODBC Data Source Administrator,
> as I keep getting:
>
> [iODBC][Driver Manager]Specified driver could not be loaded
>
> When I try to use the connection in Excel.
>
> Anyone have any working odbc.ini and odbcinst.ini files from /Library/ODBC/
> that they are willing to share?
>
> Any other tips?
>
> Running 4D 15.1 on Mac Server.
>
> Thanks,
>
> James.
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ: http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html>
> Archive: http://lists.4d.com/archives.html
> <http://lists.4d.com/archives.html>
> Options: http://lists.4d.com/mailman/options/4d_tech
> <http://lists.4d.com/mailman/options/4d_tech>
> Unsub: mailto:[email protected]
> <mailto:[email protected]>
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
