We are getting an error trying to make a connection using SAS ODBC 9.4 from a Windows Server 2012 R2 machine. The connection is to a SAS Share Server and the ODBC connection is coming from Crystal Reports. The error that is produced in the Crystal reports software is listed below.
--Database Connector Error: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed'
The trace file shows the following error:
:WQEOpen: Winsock getservbyname failed rc = 11004.
:WQEOpen failed: rc -1005 trc 0x2afc.
This error reflects that there is an issue with the services file but we have checked both the locations and the service file matches. We have tried to make the connection using the DNS Name port connection (servername.__8551) and that fails with the same error. We have also tried to make an ODBC connection suing the SAS Enterprise Guide and it gets the same error.
The ODBC connection was created using the 32-bit ODBC.
Interesting...we have a web application that uses a DNS Connection String (below) and it works fine.
connString = "Provider=sas.ShareProvider.1;" +
"Data Source=" + appType.ToLower() + "Shr1;" +
"User ID=" + username.ToLower() + ";" +
"Password=" + userpwd + ";" +
"Mode=Read|Share Deny None";
There are a couple of SAS Support KB articles that are no longer available that appear to contain the error we are getting.
Are there security settings that are being missed in the SAS Cient configuration? We are at a loss as to why this is happening using the ODBC connections? Any help would be appreciated.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.