55008 - "Extension Load Failure" errors might occur when you submit a LIBNAME statement against SAS® Table Server

Problem Note 55008: "Extension Load Failure" errors might occur when you submit a LIBNAME statement against SAS® Table Server

If you submit a LIBNAME statement against the SAS Table Server, you might encounter errors such as the following:

Extension Load Failure: OS Error: 193 (tkedcm is not a valid Win32 application.)

For example, an error occurs if the SharedServices database is deployed to SAS Table Server and you submit the following LIBNAME statement against it:

LIBNAME fdsdb SASTS SERVER='racesx13067.demo.sas.com' PORT=22031 PROTOCOL=bridge USER='sasadm@saspw' password=Orion123 noprompt="driver=tssql;conopts=(dsn='SharedServices')" ;

In this situation, you might encounter the following errors:

1 LIBNAME fdsdb SASTS 2 SERVER='racesx13067.demo.sas.com' 3 PORT=22031 PROTOCOL=bridge 4 USER='sasadm@saspw' password=XXXXXXXX 5 noprompt=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 6 ; ERROR: Error allocating CLI environment. ERROR: Error in the LIBNAME statement. ERROR: Extension Load Failure: OS Error: 193 (tkedcm is not a valid Win32 application.) ERROR: Unable to load extension: (tkedcm)

An error might also occur if a generic SAS Table Server LIBNAME statement is submitted, as shown here:

LIBNAME fdsdb SASTS SERVER='racesx13068.demo.sas.com' PORT=22031 PROTOCOL=bridge USER='sasadm@saspw' password=Orion123 noprompt="driver=syscat" ;

If the above code is submitted, then you might encounter the same errors:

1 LIBNAME fdsdb SASTS 2 SERVER='racesx13068.demo.sas.com' 3 PORT=22031 PROTOCOL=bridge 4 USER='sasadm@saspw' password=XXXXXXXX 5 noprompt=XXXXXXXXXXXXXXX 6 ; ERROR: Error allocating CLI environment. ERROR: Error in the LIBNAME statement. ERROR: Extension Load Failure: OS Error: 193 (tkedcm is not a valid Win32 application.) ERROR: Unable to load extension: (tkedcm)

You might encounter the problem if a 32-bit version of SAS was installed after a 64-bit version of SAS was previously installed on your 64-bit Windows operating system.

A fix is available to resolve this issue. Contact SAS Technical Support to request it.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	Windows Vista for x64	9.3		9.3 TS1M0
		Microsoft® Windows® for x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0
		Microsoft Windows Server 2003 for x64	9.3		9.3 TS1M0
		Microsoft Windows Server 2008 for x64	9.3	9.4	9.3 TS1M0	9.4 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	medium

Date Modified:	2015-01-28 11:29:25
Date Created:	2015-01-16 11:05:15