BookmarkSubscribeRSS Feed
Stephen1
Calcite | Level 5

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 ? 

 

KR

4 REPLIES 4
JuanS_OCS
Amethyst | Level 16

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

 

 

Stephen1
Calcite | Level 5

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.

 

JuanS_OCS
Amethyst | Level 16

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.

ballardw
Super User

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 4 replies
  • 1549 views
  • 0 likes
  • 3 in conversation