SQL Server 2005 Link server to ODBC driver *SEVERE ERROR*

This is a discussion on SQL Server 2005 Link server to ODBC driver *SEVERE ERROR* within the sqlserver-odbc forums in Microsoft SQL Server category; I am using the latest IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL I then use a SQL Server 2005 link server – Microsoft OLE Database Provider for ODBC Driver. Both ODBC and SQL Server 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 ...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-odbc

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-14-2008, 06:17 PM
Default SQL Server 2005 Link server to ODBC driver *SEVERE ERROR*

I am using the latest IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL I
then use a SQL Server 2005 link server – Microsoft OLE Database Provider for ODBC
Driver. Both ODBC and SQL Server 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 driver route.

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

Any help will be much obliged.



Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 02:41 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.