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.
