Odbc System Error Code 193

Posted on by

Odbc System Error Code 193

You receive the following system error code 193 when using the Microsoft ODBC Administrator to create the DataSource for Tivoli Netcool / OMNIbus on Windows 64-bit: The setup routines for the DataDirect 5.3 ODBC driver could not be loaded due to system error code 193. The easiest way to remove these entries would be to load up the Registry Editor and navigate to HKEYLOCALMACHINESOFTWAR EWow6432N odeODBC and then you can remove the DSN name entry from the 'ODBC.INI' and 'ODBC Data Sources' keys. The other option would be to install the old PSQL engine, remove the DSNs, then uninstall (if you're not using PSQL any more).

System error code 193 1.Browse to C:WindowsSysWow64 folder 2.Rename the following files: ◦msvcr100.dll ◦msvcp100.dll 3.Reinstall Microsoft Visual Studio C 2010 Runtime.

Symptom

You want to use a 32 bits ODBC driver for SAP IQ 16.1


Read more...

Environment

Product

SAP IQ 16.1

Keywords

odbc driver, 32bits, 32-bits, ODBCDriver, the setup routines for the sybase iq odbc driver could not be loaded due to system error code 193 , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Odbc System Error Code 193 Divided

Visit SAP Support Portal's SAP Notes and KBA Search.

Exasol ODBC driver is available for 32-bit and 64-bit versions of Windows operating system.

System Requirements

Error
  • You should have system administrator rights for the system where you are installing the driver.
  • Microsoft .NET Framework 4.0 Client Profile™ should be installed on the system.
  • All applications and services that integrate the ODBC must be stopped during installation.
  • If 'Business Objects XI' is installed on the system, the 'Web Intelligence Report Server' service must be stopped.

The ODBC driver is tested on the following operating systems:

  • Windows 10 (x86/x64)
  • Windows 8.1 (x86/x64)
  • Windows 7, Service Pack 1 (x86/x64)
  • Windows Server 2012 R2 (x86/x64)
  • Windows Server 2012 (x86/x64)
  • Windows Server 2008 R2, Service Pack 1 (x86/x64)
  • Windows Server 2008, Service Pack 2 (x86/x64)

Download and Install the ODBC Driver

  1. Go to the Exasol Downloads page and from Download ODBC Driver section, download the ODBC Driver according to your OS (32-bit or 64-bit). For example, for Windows, select EXASOL_ODBC-<version>-x86.msi or EXASOL_ODBC-<version>-x86_64.msi.
  2. Run the executable file downloaded.
  3. Follow the setup wizard to complete the installation.

In case of an update, existing ODBC data sources are automatically configured for the new driver.

Configure Driver and Data Sources

Do the following to configure the driver and the data sources:

  1. Open the ODBC Data Source Administrator tool.
  1. Click Add in the User DSN or System DSN tabs.
  2. Select EXASolution Driver in the Create New Data Source dialog and click Finish.
  1. Select Connection tab in the EXASolution ODBC configuration dialog.
  1. Enter the following details:
  • Datasource name: Name of the new ODBC data source
  • Connection string: List of host names or IP addresses and the port of the Exasol cluster (for example, 192.168.6.11..14:8563).

    The system must be capable of resolving the host names. If it is not possible, contact your network administrator.

  • Encryption: Enables or disables the automatic encryption.
  • Username: Name of the default user for this connection.
  • Password: Password of the default user.
  • Default schema: The name of the schema that is automatically opened when the connection is established. If this schema is not available during the attempt at establishing the connection, an error message is displayed and the connection with Exasol fails.
  • Test connection: You can use this to test whether the connection data has been entered correctly. This initiates a connection with Exasol.
  1. (Optional) Click Advanced tab and define the following options and click OK:
  • SQL Prepare always successful
  • Log file
  • Log mode
  • Character locale (LC_CTYPE)
  • Numeric locale (LC_NUMERIC)
  • Query timeout
  • Show only current schema
  • Additional string parameters

The new connection appears in the list of Windows data sources.

The Connection Pooling of the driver manager is deactivated by default, you can activate it in the configuration tool 'ODBC Data Source Administrator'. In that case reused connections keep their session settings which were set through SQL commands (for more information, see ALTER SESSION).

Known Issues

Odbc System Error Code 193 Odbc

IssueScreenshotReasonSolution
System error codes: 126, 127, 193, or 14001

Important elements of the ODBC driver are not installed correctly.

  • Quit all applications and services that may be used by the ODBC and re-install the Exasol ODBC driver.
  • In case of error 14001, important system libraries needed by the Exasol ODBC are not installed on this machine. Re-install the Visual C++ Redistributables and then the Exasol ODBC driver.
  • Install the latest Windows updates.

Incompatible dll versions

An older version of the Exasol ODBC was already installed and it was not overwritten during the installation.

Quit all applications and services that may be used by the ODBC and re-install the Exasol ODBC driver.

Error opening file for writing.

The installer has detected that it cannot overwrite an Exasol ODBC component.

Data source name not found and no default driver specified.

Data source name is not specified properly.

  • Check the Data Source name.
  • On a 64-bit system, check if the created data source is a 64-bit data source. Although, the application expects a 32-bit data source or vice versa.