| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| I am using the latest IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL I then use a link server – Microsoft OLE Database 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 Database 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. ![]() |
![]() |
| Thread Tools | |
| Display Modes | |