topic Re: SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work in Microsoft Integration with SAS

SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work

Stephen1 — Tue, 27 Sep 2016 13:52:47 GMT

Hi all,

i have a short question regarding SAS 9.4 and Windows 10 (x64).

I have installed the latest SAS 9.4 ODBC (x64) driver and have configured it. When i try to open a OBDC connection in Excel 2016 (x64) - Excel crashes...

Does somebody has an idea ?

Re: SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work

JuanS_OCS — Tue, 27 Sep 2016 14:05:22 GMT

Hi,

probably some logging could give us some extra information.

One log that might be useful could be on the one generated by the Addon: http://support.sas.com/kb/56/743.html

Re: SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work

Stephen1 — Tue, 27 Sep 2016 14:11:04 GMT

Hi Juan,

thx for your quick response...

I haven´t installed the SAS Office Add-In - In the past, it was enough to open a ODBC connection.

Re: SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work

JuanS_OCS — Tue, 27 Sep 2016 15:08:45 GMT

And that is still true. You might want to check with your system admins, what they do think. They can see the logs of Excel, the Windows Logs, and the odbc client logs.

Re: SAS ODBC Connection on Office 2016 and Windows 10 (both x64) doesn´t work

ballardw — Tue, 27 Sep 2016 15:12:41 GMT

By any chance were you attempting to open a SAS data set that exceeds the size limits for Excel?