CONNECT ODBC SQL Server Wire Protocol driver was causing Statistics to hang on all Unix platforms.

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:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Server

Software version:

Not Applicable

Operating system(s):

Platform Independent

Reference #:

1489268

Modified date:

2012-12-19

Translate my page

Machine Translation

Content navigation