Thanks Tim. Got the driver working. Looks like I am now facing an Excel bug.
Found the 4D docs too; they are at: http://doc.4d.com/4Dv15/4D/15.2/Installing-an-ODBC-driver-on-OS-X.300-2885364.en.html <http://doc.4d.com/4Dv15/4D/15.2/Installing-an-ODBC-driver-on-OS-X.300-2885364.en.html> When you tell Excel to get data from an External Database, it fires up Microsoft Query, and I can get that to connect to 4D, execute the SQL query and show the data. Then when I click on ‘Return Data’, Excel throws up the error about not being able to load the specified driver. I’ve posted the full description with screenshots here: http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/odbc-connection-not-working-within-excel/e6ac7984-904b-4a85-9a7e-f2bb8eeb75b5 <http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/odbc-connection-not-working-within-excel/e6ac7984-904b-4a85-9a7e-f2bb8eeb75b5> Have made a post on Microsoft’s feedback page: https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15964384-get-data-from-external-database-not-working-ms-q <https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/15964384-get-data-from-external-database-not-working-ms-q> But it only has 3 votes - please help by voting for it! Thanks, James. > On 8 Sep. 2016, at 4:32 am, Timothy Penner <[email protected] > <mailto:[email protected]>> wrote: > >> Aren’t those drivers for 4D accessing other databases? Ie not for retrieving >> data FROM 4D? >> Or is it for both? > > The drivers I provided are for accessing data from 4D where 4D is acting as a > ODBC Server, like in this text diagram: > > Generic ODBC Client Application <- communicates with -> 4D's ODBC Driver <- > communicates with -> 4D Server's SQL Server Port 19812 > > If you are using MS Excel, it would be like this text diagram: > > MS Excel <- communicates with -> 4D's ODBC Driver <- communicates with -> 4D > Server's SQL Server Port 19812 > > -Tim > ********************************************************************** > 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] **********************************************************************
