August 12, 2008 at 1:05 pm
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.
Date8/12/2008 10:44:57 AM
LogSQL Server (Current - 8/12/2008 10:50:00 AM)
SourceServer
Message
Error: 17310, Severity: 20, State: 1.
Date8/12/2008 10:44:55 AM
LogSQL Server (Current - 8/12/2008 10:50:00 AM)
Sourcespid60
Message
* Access Violation occurred reading address 00000000
Date8/12/2008 10:44:55 AM
LogSQL Server (Current - 8/12/2008 10:50:00 AM)
Sourcespid60
Message
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
Date8/12/2008 10:44:55 AM
LogSQL Server (Current - 8/12/2008 10:50:00 AM)
Sourcespid60
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
Oh i did try to update MDAC that didnt help and we didnt want to go the datadirect route.
Any help will be much obliged. 🙂
[/quote]
August 12, 2008 at 1:12 pm
What is the data type of the column causing the problem? Could be a mapping issue so you may need to CAST it. Also have you tried using openquery or openrowset?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 12, 2008 at 1:28 pm
It is a text field; however, I noticed it happens on some Char fields as well. I have tried Cast and convert; however, they do not seem to make a difference. Maybe becuase SQL terminates the connection before it gets to execute the convert??? don't know.
August 12, 2008 at 1:33 pm
I'd try using openquery instead of querying the linked server directly from the SQL Server. OpenQuery makes it more of a pass-through type query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 12, 2008 at 2:02 pm
Sorry to say results in same error message
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
August 13, 2008 at 3:06 pm
I still need help on this topic since drivers 3.5 from IBM Infomix client connect did not work. And I used the SA account to make sure it wasnt a permission issue.
PLEASE HELP ANY SUGGESTION WOULD BE GREAT 🙂
August 13, 2008 at 3:24 pm
I'm tapped out. Never really worked with INFORMIX and when I had similar issues with DB2 using openquery and/or converting to another data type usually worked.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 13, 2008 at 3:57 pm
Ok, thanks for trying Jack. Anyone else willing to man up 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply