06-26-2017 08:55 AM
When I try to connect to the OLAP server in SAS EG, I'm getting this error:
ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to host abc.net, port 5451.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 110 (The connection has timed out.)
What is the problem?
(This question is not related to programming but here is the code:
proc sql; connect to olap (host="abc.net" port=5451 user="***" password="***"); disconnect from olap; quit;
06-26-2017 09:00 AM
Check if the OLAP server is up on host abc.net.
On UNIX, I'd issue
ps -ef|grep OLAP
from the commandline as the simplest method. But you can of course use the SAS Management Console to test the server. (expand Server Manager Plug-In, expand SASApp, right-click SASApp - Logical OLAP server, select "Verify")
06-26-2017 09:45 AM
is this the complete error message or is there more? Is there anything in the OLAP Server log?
06-26-2017 11:20 AM
I don't have access to logs on server.
But one question that in order to connect to OLAP cubes from SAS should 'SAS/ACCESS interface to OLE DB' be installed on server?