Recently we encountered an interesting problem with a surprising solution.  A customer was moving his Omni Server to a new Windows 2003 Server, and was having problems connecting to his SQL Server database.  The new server is running 64 bit Windows Server.  It turns out that 32 bit programs, such as ITScriptNet, do not have access to ODBS Data Sources created by the 64 bit ODBC Administrator.  To solve the problem, you must create the DSN with the 32 bit ODBC Administrator, located in C:\Windows\SysWow64\ODBCAD32.exe

You can find out more about 32 bit and 64 bit ODBC Data sources in this Microsoft Knowledge Base article.

We added a Knowledge Base article about this problem