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

This is a discussion on EXCEPTION_ACCESS_VIOLATION Error: 17310, Severity: 20, State: 1. within the sqlserver-datamining forums in Data Warehousing category; 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 ...

Go Back   Database Forum > Data Warehousing > sqlserver-datamining

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-12-2008, 06:04 PM
Default EXCEPTION_ACCESS_VIOLATION Error: 17310, Severity: 20, State: 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.

Any help will be much obliged.

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 03:31 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.