Technote (troubleshooting)
Problem(Abstract)
I have attempted to deploy the latest SPSS Data Access Pack version 6 ODBC drivers to my PASW Statistics Servers on UNIX/Linux. Whenever my end users try to access a Microsoft SQL Server 2008 database, using the SQL Wire Protocol driver supplied in this pack, PASW Statistics hangs.
Resolving the problem
Data Direct has reported a work around for this issue. The work around is to set the ReportDateTimeType to 0 (zero) in the odbc.ini file.
By setting this to 0, all the new datetime types will be reported as varchars. This is the same behavior that existed in the Version 5.3 Service Pack 2 drivers.
This behavior has been resolved for the upcoming 18.0.1 patch release to include the work around in the ReadMe file and to modify the odbc.ini file at installation time so that the attribute is set to 0.
Historical Number
86525
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.