Problem Note 13623: JMP 5.1 clients fail to connect to SAS/SHARE servers with SAS 9.1 ODBC
Driver
The following error message might appear when JMP 5.1 clients attempt
to connect to a remote SAS/SHARE server with the SAS 9.1 ODBC driver:
Error loading string IDS_MS_SAPWMSG[38]
This error means that the calling ODBC application is attempting to
connect to a remote SAS/SHARE server configured with a user access
password. This SAS password is specified on the corresponding SAS ODBC
Data Source definition within the Servers Tab>Server Settings
password field.
JMP and any other ODBC-compliant applications that use SQLDriverConnect
with SQL_DRIVER_PROMPT are not able to use a SAS ODBC Data Source
configured with the SAS/SHARE server's user access password.
To circumvent this problem, do the following:
1. Shut down the SAS/SHARE server.
2. Remove the UAPW= server option from the SAS/SHARE server's
PROC SERVER source statement.
3. Remove the user access password from the SAS ODBC Data Source's
Servers Tab>Server Settings panel.
4. Restart the SAS/SHARE server.
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/913odbcdrv.html#013623
Operating System and Release Information
SAS System | SAS ODBC Driver | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M3 SP4 |
*
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: | high |
Date Modified: | 2004-10-21 11:01:16 |
Date Created: | 2004-10-14 16:48:26 |