EXCEPTION_ACCESS_VIOLATION

Question

EXCEPTION_ACCESS_VIOLATION

NBD4K27

SSC-Addicted

Points: 456
More actions
August 12, 2008 at 12:09 pm

#190911

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. 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

JJ-251245 SSC Veteran Points: 233 More actions · Answer 1

Rich,

I am looking for something similar, except my linked servers are two SQL 2000 servers talking to each other, same issue you are having.

I hope you find your answer! 🙂

ggoble Hall of Fame Points: 3337 More actions · Answer 2

Try to disable the job and then enable it.

It worked for me.

manolomalaga SSCommitted Points: 1697 More actions · Answer 3

Here is a very interesting info from MS

http://support.microsoft.com/?scid=kb;en-us;306212&x=10&y=16

Scott MacCready SSC Eights! Points: 991 More actions · Answer 4

HI,

We are trying to establish a connection to an informix 10 server from ss05 and can find NO documentation about how to configure the linked server.

Could you please provide details on provider configuration and what to use for the parameters of the linked server?

One fact that may be pertinent is that we have to use the ip number for the server host name because the host is not supported by our DNS system. Yes, we could modify the hosts file but we don't want to do that everywhere this is needed.

Any information would be very much appreciated.

thanks.

Scott

manolomalaga SSCommitted Points: 1697 More actions · Answer 5

Hi, you need the ibm informix odbc driver.

http://www-01.ibm.com/software/data/informix/pubs/library/csdk_29.html

Next you could create a linked server throw windows ODBC

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/a89c8f71-c9af-4769-badf-3548faffaa66/