Catastrophic Failure opening ODBC via Citrix
- by Joshdan
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.