Odbc Error Im003 In
Contents |
nco_g_odbc; libodbc; datadirect drivers; ODBC libraries; datasource;
Specified Driver Could Not Be Loaded Due To System Error 8 Sage
odbc gateway Technote (troubleshooting) Problem(Abstract) Unable to use the Microsoft ODBC Administrator to
Specified Driver Could Not Be Loaded Due To System Error 126
create the DataSource on Windows 64-bit. Symptom Receive the error "The setup routines for the DataDirect 5.3
Error Im003 System Error 8
driver could not be loaded due to system error code 193." Cause The driver is a 32-bit driver and the default Microsoft ODBC Administrator utility is for 64-bit drivers. Resolving the problem On 64-bit Windows, there are two versions of the Microsoft error im003 specified driver could not be loaded due to system error 8 ODBC Administrator tool. Typically, you go to Start --> Administrative Tools --> Data Sources (ODBC) to create ODBC connections. This calls the program %WINDIR%\System32\odbcad32.exe to create a 64-bit ODBC connection. However, this program will not create 32-bit ODBC connections. The ODBC gateway requires a 32-bit ODBC connection. Use the 32-bit version of the Microsoft ODBC Administrator tool located in %systemdrive%\Windows\SysWoW64\odbcad32.exe to create the ODBC Data Source. Document information More support for: Tivoli Netcool/OMNIbus ODBC (MySQL) Gateway Software version: 7.3.0, 7.3.1, 7.4.0 Operating system(s): Windows Software edition: All Editions Reference #: 1377507 Modified date: 31 May 2016 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
12.5, I get the error message: SQLSTATE = IM003 Cannot load driver due to system error 193. (SQL Anywhere 12 C:\Program Files\SQL Anywhere 12\Bin64\dbodbc12.dll). I specified driver could not be loaded due to system error 127 use windows 7 64 bits error-message asked 01 Oct '12, 23:54 cmunpal error im003 specified driver could not be loaded due to system error 126 31●1●1●3 accept rate: 0% edited 02 Oct '12, 11:32 Breck Carter 26.3k●414●568●819 flat view 5 Answers: active answersoldest answersnewest error im003 sage answerspopular answers 1 Try the 32 bit ODBC 32 bit driver. PB is a 32 bit app and needs the 32 bit driver. c:\windows\sysWOW64\odbcad32.exe you may have to delete the 64 bit http://www-01.ibm.com/support/docview.wss?uid=swg21377507 odbc connection first (using Control Panel) permanent link answered 02 Oct '12, 10:26 Tom Mangano 512●17●20●28 accept rate: 3% edited 02 Oct '12, 11:32 Breck Carter 26.3k●414●568●819 flat view 1 See this forum discussion... http://sqlanywhere-forum.sap.com/questions/890/windows-7-64-bit-1001-4075-system-dsn-setup-problems permanent link answered 02 Oct '12, 11:37 Breck Carter 26.3k●414●568●819 accept rate: 20% flat view 0 Thanks, one more question, do I have to uninstall SQL Anywhere 12 http://sqlanywhere-forum.sap.com/questions/13617/sqlstate-im003-cannot-load-driver-due-to-system-error-193 64 bit and install sql Anywhere 12 32 bit?, because I can't delete 64 bit odbc connection (c:windowssysWOW64odbcad32.exe or c:windowssystem32odbcad32.exe) and I can't create 32 bits connection either. I have little knowledge, Could you tell me how to do it? permanent link answered 03 Oct '12, 12:52 cmunpal 31●1●1●3 accept rate: 0% If you do not want to use the installed SQL Anywhere 64-bit components and just want to use the 32-bit components, then I think it's easiest to uninstall SQL Anywhere 12 and just install the 32-bit components. If you like to have both bitnesses installed, it should work to re-run the setup (say, from the "Software" control panel topic), and use "Add components" (or whatever this is worded exactly) to add the 32-bit components. Not sure about the "not being able to delete ODBC DSNs" - that surely should work when SQL Anywhere is installed correctly. (03 Oct '12, 15:38) Volker Barth flat view 0 Thanks, one more question, do I have to uninstall SQL Anywhere 12 64 bit and install sql Anywhere 12 32 bit?, because I can't delete 64 bit odbc connection (c:windowssysWOW64odbcad32
here for a quick overview of the site Help Center Detailed answers to http://stackoverflow.com/questions/10383822/odbc-lib-specified-driver-could-not-be-loaded any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://cs.pervasive.com/forums/p/13838/47618.aspx about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack system error Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ODBC lib Specified driver could not be loaded up vote 2 down vote favorite I am trying to install ODBC drivers and I am running into brick walls. specified driver could [root@Crux pkg]# isql -v [IM002][DataDirect][ODBC lib] Data source name not found and no default driver specified [ISQL]ERROR: Could not SQLConnect [root@Crux pkg]# isql -3 SUBS2A [IM003][DataDirect][ODBC lib] Specified driver could not be loaded [ISQL]ERROR: Could not SQLConnect My INI files are as follows; odbcinst.ini [ProgressOpenEdge] Description = ODBC for Progress OpenEdge Driver = /usr/dlc/odbc/lib/pgoe1023.so ;Setup = /usr/dlc/odbc/lib/pgoe1023.so FileUsage = 1 odbc.ini [SUBS2A] Driver = ProgressOpenEdge Description = Fail DatabaseName = SUBS PortNumber = 4000 HostName = 192.168.1.2 LogonID = SYSPROGRESS Password = SYSPROGRESS APILevel = 1 ConnectFunctions = YYN CPTimeout = 60 DriverODBCVer = 03.50 FileUsage = 0 SQLLevel = 0 UsageCount = 1 ArraySize = 50 DefaultLongDataBuffLen = 2048 DefaultIsolationLevel = REPEATABLE READ StaticCursorLongColBuffLen = 4096 [ODBC] InstallDir = /usr/dlc/odbc Trace = 0 TraceFile = odbctrace.out TraceDll = /usr/dlc/odbc/lib/odbctrac.so UseCursorLib = 0 I have already made sure all dependencies are loaded properly via ldd. UPDATE OUTPUT OF: strace isql -v http://pastebin.com/tXFY4vVt OUTPU
returns error IM003 Last post 04-22-2011 4:36 AM by intra_net@o2.pl. 9 replies. Page 1 of 1 (10 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 04-21-2011 7:35 AM intra_net@o2.pl Joined on 04-21-2011 Posts 6 [PHP] odbc_connect returns error IM003 Reply Contact When I try to connect from a local machine using: (Windows XP or Vista, Apache, Pervasive v11)[Code PHP]$connect = odbc_connect("Driver={Pervasive ODBC Client Interface};ServerName=127.0.0.1;ServerDSN=Demodata;", "", "");if(!$connect) echo ("Could not connect
"); else echo ('Connected');I get the information from Page (http://localhost/):Warning: odbc_connect() [function.odbc-connect]: SQL error: Specified driver could not be loaded due to system error 998 (Pervasive ODBC Engine Interface)., SQL state IM003 in SQLConnectConfiguration OS:variables: Path -> C:\Program Files\Pervasive Software\PSQL\bin\Control Panel -> (ODBC):user DSN: demodata - Pervasive ODBC Client Interface - TEST successfulsystem DSN: demodata - Pervasive ODBC Client Interface - TEST successfulAny ideas?Thanks! 04-21-2011 7:47 AM In reply to Jay.Clark Joined on 07-13-2007 Posts 838 Re: [PHP] odbc_connect returns error IM003 Reply Contact Looking for "Specified driver could not be loaded due to system error 998" I found a couple of references that may help:Forum post: http://cs.pervasive.com/forums/p/12428/42549.aspxAre you using "any cpu"? It could throw a driver not found error. Has the path been changed? You may need to restart after path was modified by the Pervasive install to include the ODBC drivers 04-21-2011 8:10 AM In reply to intra_net@o2.pl Joined on 04-21-2011 Posts 6 Re: [PHP] odbc_connect returns error IM003 Reply Contact - I'm logged in locally desktop - I'm logged in as a local Administrator- The registry key HKEY_L