Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL EXCE..

 
   Database Forums (Home) -> ODBC RSS
Next:  SQL 2005 Express  
Author Message
Rich

External


Since: Mar 02, 2006
Posts: 101



(Msg. 1) Posted: Wed Aug 13, 2008 3:34 pm
Post subject: IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL EXCEPTION_AC
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

I am using the latest IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL I
then use a link server – Microsoft OLE DB Provider for ODBC Driver. Both ODBC
and Linked server test connection successfully and I can return most records
in a table from Informix; however, some tables have a text and char columns
that produce the error:

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.



Here's my SQL and ERRORS

USE [TASA]
GO
SET NOCOUNT ON

SELECT
[descrip]
FROM
[tasa1_ptrack].ptrack.tasa.equip

NOTE: If I select any other column in that table it returns no problem.

Results in SQL error:

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.


Date 8/12/2008 10:44:57 AM
Log SQL Server (Current - 8/12/2008 10:50:00 AM)

Source Server

Message
Error: 17310, Severity: 20, State: 1.


Date 8/12/2008 10:44:55 AM
Log SQL Server (Current - 8/12/2008 10:50:00 AM)

Source spid60

Message
* Access Violation occurred reading address 00000000


Date 8/12/2008 10:44:55 AM
Log SQL Server (Current - 8/12/2008 10:50:00 AM)

Source spid60

Message
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION


Date 8/12/2008 10:44:55 AM
Log SQL Server (Current - 8/12/2008 10:50:00 AM)

Source spid60

Message
* Exception Address = 66595E3D Module(msdasql+00025E3D)

Message
SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.


SQL ERROR LOG

SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2008-08-12 10:44:55.54 spid60 *
*******************************************************************************
2008-08-12 10:44:55.54 spid60 *
2008-08-12 10:44:55.54 spid60 * BEGIN STACK DUMP:
2008-08-12 10:44:55.54 spid60 * 08/12/08 10:44:55 spid 60
2008-08-12 10:44:55.54 spid60 *
2008-08-12 10:44:55.54 spid60 *
2008-08-12 10:44:55.54 spid60 * Exception Address = 66595E3D
Module(msdasql+00025E3D)
2008-08-12 10:44:55.54 spid60 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2008-08-12 10:44:55.54 spid60 * Access Violation occurred reading
address 00000000
2008-08-12 10:44:55.54 spid60 * Input Buffer 194 bytes -
2008-08-12 10:44:55.54 spid60 * SET NOCOUNT ON
SELECT [descrip] FROM [tasa1_pt
2008-08-12 10:44:55.54 spid60 * rack].ptrack.tasa.equip

ALSO TRIED....
SELECT *
FROM OPENQUERY([TASA1_PTRACK],'SELECT * FROM tasa.equip')

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.

BTW same as beforementioned all columns return except the last. (Other
tables in same dB have that problem on char fields) URG

CREATE TABLE [dbo].[equip](
[equip_id] [int] IDENTITY(1,1) NOT NULL,
[fsc] [char](4) NOT NULL,
[niin] [char](9) NOT NULL,
[noun] [char](50) NULL,
[ui] [char](2) NULL,
[unit_cost] [numeric](10, 2) NULL,
[slc] [char](1) NULL,
[smc] [char](1) NULL,
[cc] [char](1) NULL,
[imc] [char](1) NULL,
[supe] [char](1) NULL,
[sos] [char](3) NULL,
[tech_nm] [char](20) NULL,
[verf_nm] [char](20) NULL,
[supfsc] [char](4) NULL,
[supniin] [char](9) NULL,
[intfsc] [char](4) NULL,
[intniin] [char](9) NULL,
[crtdate] [datetime] NULL,
[transdt] [datetime] NULL,
[jtransdt] [char](5) NULL,
[requestor] [char](20) NULL,
[hold_cd] [char](1) NULL,
[stat_cd] [char](1) NULL,
[boflg] [char](1) NULL,
[sub_cat] [char](15) NULL,
[maj_cat] [char](6) NULL,
[cat_cd] [char](4) NULL,
[rmks_flg] [char](1) NULL,
[descrip] [text] NULL

Oh i did try to update MDAC that didnt help and we didnt want to go the
datadirect route.

Also tried the trail version of IBM Client Connect 3.5 with no luck.

Any help will be much obliged. Smile

 >> Stay informed about: IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL EXCE.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
x64 ODBC Driver - Anyone know when and if x64 ODBC drivers will be available for connecting to Access?

odbc driver? - Hello, It has been over 5 years since I've had to use MS SQL. I'm finding out the interface has changed and now I can't figure out how to install the ODBC driver to a Server 2003 R2 box. It's not where it used to be. I've searched MS knowledge base..

ODBC driver for W95 - We have a lot of W95 clients that can't be upgraded. I want to use SQL CLR so I need to use SQL 2005. Is there an ODBC driver for W95? I've tried MDAC 2.8 but without success (installation fails on W95). -- Steve

ODBC driver for SQL server using mfc - Hi, I am currently using ORACLE 9i but I am trying to move to SQL server. Below is my code, I am getting very strenge error, I can retrieve all the data from database, but when I do .Edit(), the code crashes. Eventhough, I am opening the recordset..

ODBC Driver for Linux - Hello, We have an instance of oracle on linux and another with sqlserver on windows. We need an odbc driver for the linux box to connect to the sql server. Does anybody have suggestions on what odbc drivers there are out there for linux in order for...
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]