top of page
cromhancahatiters

ODBC resource DLL is a different version than the ODBC driver manager: How to fix it



This error occurs when installing Peer Web Service:"ODBC Driver Manager: the ODBC resource DLL (C:\WINNT\system32\odbcint.dll) is a different version than the ODBC driver manager (C:winnt\system32\odbcint.dll) You need to reinstall the ODBC components to ensure operation. Press OK to proceed. Cancel to abort."




odbc resource dll is a different




Warning:The instructions below include making changes to essential parts of your operating system. It is recommended that you backup your operating system and files, including the registry, before proceeding. Consult with a qualified computer systems professional, if necessary.Esri cannot guarantee results from incorrect modifications while following these instructions; therefore, use caution and proceed at your own risk.Replace the odbcint.dll and odbccp32.dll files with copies of the files from a system that does not have the Peer Web Service installed.The original files have the following specifications:odbcint.dll Size: 66kb Date: 6/12/97 10:32 AM Version: 3.0.2822odbccp32.dll Size: 86kb Date: 6/12/97 10:32 AM Version: 3.0.2822


Installation on XP continues, when I click ok on error message dialog box which I mentioned above. When launched the sequenced app on Win 7 ,it works fine but on XP It displays error messege "The ODBC resource DLL (c:\windows\system\odbcint.dll) is a different version than the ODBC driver manager (c:\windows\system\odbc32.dll)."


The fact that it runs fine on Windows 7 and not on XP (in all different scenarios) likely means that the application is not actually compatible with XP; have you checked from the vendor if this is the case?


but the application behaves good when installed manually on XP. During manual install on XP, I see error message "The procedure entry point SMapLS could not be located in the dynamic link library KERNEL32.dll" If I click OK, the install continues. But I dont see this error while sequencing. During sequecing I see the error " ODBC can't load the resource".


Anyhow, try to re-install ODBC components during sequencing by installing proper MDAC package ( -us/data/aa937729.aspx)? Maybe this will solve the version differences between odbcint.dll and odbc32.dll.


This is SQL 2000 developers edition on a Win 2000 professional (sp2)that already had SQL 2000 Dev.Ed. (very same CD) installed. Iuninstalled SQL because replication broke, not being able toinitialize a snapshot (unable to copy data from syncobj_324323xxxxx),but that's another story.During installation, I get "Unable to load sql server ODBC driverresource dll", and the setup log says "unable to configure server". I'd copy the required dll/rll where ever necessary, if I could findout what's missing. How do I track down the missing dll/rll? Anyonesolved this before?Bill


Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. The application's source code does not have to be recompiled for each data source. A database driver links the application to a specific data source. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. Therefore, the application can access any data source for which a database driver exists.


* The Oracle ODBC Resource data definition language (DLL) file (sqresxx.dll), where xx represents the language abbreviation, contains all pertinent language information; the default resource file used is sqresus.dll.


Oracle ODBC driver is enhanced to prefetch LONG or LONG RAW data to improve performance of ODBC applications. To do this, the maximum size of LONG data (MaxLargeData) must be set in the registry on Windows (you also must add the registry key MaxLargeData in the data source name (DSN)), and set this manually in the odbc.ini file on UNIX platforms. This enhancement improves the performance of Oracle ODBC driver up to 10 times, depending on the MaxLargeData size set by the user. The default value of MaxLargeData is 0. The maximum value for MaxLargeData that you can set is 64 KB (65536 bytes).


When an application makes heavy calls to small packaged procedures that return REF CURSORS, a performance improvement can be made by forcing the driver to use OCIDescribeAny(). To enable this option, set the value of UseOCIDescribeAny in odbc.ini to T (True), default value is F (False), on UNIX platforms, and through the registry on Windows.


An Oracle server waits indefinitely for lock conflicts between transactions to be resolved. You can limit the amount of time that an Oracle server waits for locks to be resolved by setting the Oracle ODBC Driver's LockTimeOut entry in the oraodbc.ini file. The value you enter for the LockTimeOut parameter is the number of seconds after which an Oracle server times out if it cannot obtain the requested locks. In the following example, the Oracle server times out after 60 seconds:


An application must connect to a data source to access the data in it. Different applications connect to data sources at different times. For example, an application might connect to a data source only at your request, or it might connect automatically when it starts. For information about when an application connects to a data source, see the documentation for that application.


If you specify a lock timeout value using the ODBC SQLSetConnectAttr function, it overrides any value specified in the oraodbc.ini file. Refer to Reducing Lock Timeout for more information on specifying a value in the oraodbc.ini file.


Minimize the number of times a statement must be prepared. Where possible, use bind parameters to make a statement reusable for different parameter values. Preparing a statement once and executing it several times is much more efficient than preparing the statement for every SQLExecute.


The SQL_CLOSE option of the ODBC function, SQLFreeStmt, is supposed to close associated cursors with a statement and discard all pending results. The application can reopen the cursor by executing the statement again without doing a SQLPrepare again. A typical scenario for this is an application that is idle for a while but reuses the same SQL statement. While the application is idle, it might free up associated server resources.


The Oracle Call Interface (OCI), on which the Oracle ODBC Driver is layered, does not support the functionality of closing cursors. So, by default, the SQL_CLOSE option has no effect in the Oracle ODBC Driver. The cursor and associated resources remain open on the database server.


Errors related to odbcint.dll can arise for a few different different reasons. For instance, a faulty application, odbcint.dll has been deleted or misplaced, corrupted by malicious software present on your PC or a damaged Windows registry.


In the vast majority of cases, the solution is to properly reinstall odbcint.dll on your PC, to the Windows system folder. Alternatively, some programs, notably PC games, require that the DLL file is placed in the game/application installation folder.


Depending on which Windows version you use, manual update processes are different. Because of this, we have prepared a special article for each Windows version. You can get our articles relating to the manual update of the Windows version you use from the links below.


We recommend that you create a system DSN instead of a user DSN. Some applications load the data using a different user account. These applications might not be able to detect user DSNs that are created under another user account.


Additionally, under /opt/amazon/redshiftodbc/Setup on Linux or /opt/amazon/redshift/Setup on macOS X, there are sample odbc.ini and odbcinst.ini files. You can use these files as examples for configuring the Amazon Redshift ODBC driver and the data source name (DSN).


To avoid this, copy the amazon.redshiftodbc.ini file to a directory other than the installation directory. If you copy this file to the user's home directory, add a period (.) to the beginning of the file name to make it a hidden file.


For the odbc.ini and odbcinst.ini files, either use the configuration files in the user's home directory or create new versions in another directory. By default, your Linux or macOS X operating system should have an odbc.ini file and an odbcinst.ini file in the user's home directory (/home/$USER or /.). These default files are hidden files, which is indicated by the dot (.) in front of each file name. These files display only when you use the -a flag to list the directory contents.


Whichever option you choose for the odbc.ini and odbcinst.ini files, modify the files to add driver and DSN configuration information. If you create new files, you also need to set environment variables to specify where these configuration files are located.


By default, ODBC driver managers are configured to use hidden versions of the odbc.ini and odbcinst.ini configuration files (named .odbc.ini and .odbcinst.ini) located in the home directory. They also are configured to use the amazon.redshiftodbc.ini file in the /lib subfolder of the driver installation directory. If you store these configuration files elsewhere, set the environment variables described following so that the driver manager can locate the files. For more information, see "Specifying the Locations of the Driver Configuration Files" in the Amazon Redshift ODBC connector installation and configuration guide.


When connecting to your data store using a data source name (DSN), configure the odbc.ini file to define DSNs. Set the properties in the odbc.ini file to create a DSN that specifies the connection information for your data store. 2ff7e9595c


1 view0 comments

Recent Posts

See All

download 1 c

Como baixar o software 1C e aprender a linguagem de programação 1C Se você está procurando uma solução de software poderosa e flexível...

Comments


bottom of page