Catastrophic Failure opening ODBC via Citrix

Posted by Joshdan on Server Fault See other posts from Server Fault or by Joshdan
Published on 2009-08-06T06:45:40Z Indexed on 2011/11/14 1:53 UTC
Read the original article Hit count: 605

Filed under:
|
|

We recently had our Citrix server crash unexpectedly. When it came back up, there was a new issue -- every ODBC connection fails with "Catastrophic Failure" (0x8000FFFF). The issue is limited to Citrix / ICA connections; logging in as the same user via RDP works as usual.

The following code is my minimal test case (for wscript):

''// test_odbc.vbs
strConn = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\files\;"
Set rs = CreateObject("ADODB.recordset")
strSQL = "SELECT * FROM myFile.csv"

wscript.echo "Press OK to Test"

''// This line breaks over Citrix, but not over Terminal Services
''// ----------------------
rs.open strSQL, strConn, 3,3
''// ----------------------
wscript.echo rs("a")

Any insight would be greatly appreciated.

Windows Server 2003 SP1, Citrix MetaFrame Presentation Server 4.0.

Clients include at least versions 10.2-11 running on 2000-Vista, OS X. ODBC error happens whether a DSN is used or not, on at least Access, MS-SQL, and CSV. Connections both through the SSL Gateway and directly. There have been a few users actually able to log in without trouble, but I can't pin down anything special about them.

© Server Fault or respective owner

Related posts about windows-server-2003

Related posts about citrix