You can create an ODBC data source for 64 bit on a server computer, admin computer or user computer according to the following instructions. Call the appropriate system program via the control panel. If this program is not available install it from the SQL Server CD.
Important! Set the SQL cursor (1st digit=S) or to activate MarsConnection in the INI file parameter for the ODBC access (SQLDRIVERCONNECT= ) in the particular component (Automation Engine, utility). Otherwise, the SQL Server database can only process one command at at time, which results in the following error:
U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for another command'
It is possible to create the data source as a User DSN (user specific) or as a System DSN (once for all users of this computer). However, it is best to create it as System DSN.
Follow the ODBC Data Source Administrator wizard to create the data source as System DSN.
Notes:
- Note that the SQL native client is required in order to use the AE database with MARS. You can download it from the Microsoft homepage if it is not yet installed on your computer.
- When selecting the SQL Server, select local if the SQL Server is on the same computer, otherwise enter the name of the DB computer.
- Select SQL Server Authentication keeping in mind that it is best to create a separate database user for AE. Do not use the user "sa" (system administrator).
- When creating a new data source to SQL Server, do not select the checkbox Perform translation for character data.
Potential problems:
- 32-Bit ODBC is used instead of 64-Bit ODBC.
- The check box "Use ANSI nulls, paddings and warnings" is not activated.
See also: