topic Re: SAS ODBC 9.4 fails on Windows Server 2012 R2 in Administration and Deployment

SAS ODBC 9.4 fails on Windows Server 2012 R2

anewlevel4u — Tue, 19 Sep 2017 21:06:21 GMT

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.

--Login failed

--Database Connector Error: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed'

The trace file shows the following error:

[2165030531]:WQEOpen: Winsock getservbyname failed rc = 11004.

[2165030531]: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;" +

"Location=servername;" +

"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.

http://support.sas.com/kb/00/714.html

http://support.sas.com/kb/12/626.html

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.

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

alexal — Wed, 20 Sep 2017 11:26:10 GMT

@anewlevel4u,

How many characters are in server name?

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

anewlevel4u — Wed, 20 Sep 2017 12:27:52 GMT

There are 15 characters in the server name.

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

alexal — Wed, 20 Sep 2017 12:36:17 GMT

@anewlevel4u,

Thanks for your response. Can you try to use the server name with no more than 8 characters?

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

anewlevel4u — Wed, 20 Sep 2017 14:35:20 GMT

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.

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

alexal — Wed, 20 Sep 2017 17:59:29 GMT

@anewlevel4u,

You are welcome!

Re: SAS ODBC 9.4 fails on Windows Server 2012 R2

Stig_Eide — Tue, 14 Nov 2017 11:48:33 GMT

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