An ITScriptNet program that uses an ODBC connection string to connect to a Microsoft Access database, but does not specify the path to the MDB file behaves differently with the OMNI server than the Download utility.

For example, a connection string in the form:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.mdb;Persist Security Info=False

DETAILS

The Download Utility will look for the MDB file in the ITB directory, but the OMNI server will look in the current working directory, usually the directory where the OMNI Server is installed.

Either place the ITB in the current working directory (OMNI Server Directory) or specify the full path to the database in the connection string.

This article last updated: 1/1/2009 12:00:00 AM