09-19-2017 05:06 PM
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.
09-20-2017 10:35 AM
Thanks for you help. I changed it in the server listing to 8 and then in the configuration for the SAS Share, I put in the whole 15 character server name.
11-14-2017 06:48 AM
Hi, not sure what you mean by "I changed it in the server listing to 8". What I did, was that I added a shorter entry in the etc\hosts file (%windir%\system32\drivers\etc\hosts on windows) and used that short name instead
Need further help from the community? Please ask a new question.