If you are running ITScriptNet on a 64 bit version of Windows, and you are trying to connect to a database using an ODBS Data Source (DSN), you may receive the following error:
Data source name not found and no default driver specified.
This occurs because 32 bit applications, such as ITScriptNet, do not have access to Data Sources created with the 64 bit version of the ODBC Administrator.
To resolve this problem, you must create a 32 bit Data Source using the 32 bit ODBC Administrator. This is located in:
C:\Windows\SysWoW64\Odbcad32.exe
For more detail on this issue, see the following Microsoft Knowledge Base article:
The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system