Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a connection to a linked server from sql server 2012 to pervasive sql.

When I do select field1, field2, field3 from mytable everything works!

However, when I do select field1, field2, field3, field4, ...field10+ from mytable I get this erro message:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "KSLAP208" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "KSLAP208".

I looked at the logs and this is what it says:

2013-02-08 11:27:30.93 spid55      ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0049.txt
2013-02-08 11:27:30.93 spid55      SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2013-02-08 11:27:30.93 spid55      * *******************************************************************************
2013-02-08 11:27:30.93 spid55      *
2013-02-08 11:27:30.93 spid55      * BEGIN STACK DUMP:
2013-02-08 11:27:30.93 spid55      *   02/08/13 11:27:30 spid 55
2013-02-08 11:27:30.93 spid55      *
2013-02-08 11:27:30.93 spid55      *
2013-02-08 11:27:30.93 spid55      *   Exception Address = 00000000018F5BBE Module(UNKNOWN+0000000000000000)
2013-02-08 11:27:30.93 spid55      *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
2013-02-08 11:27:30.93 spid55      *   Access Violation occurred reading address 0000000009400090
2013-02-08 11:27:30.93 spid55      * Input Buffer 128 bytes -
2013-02-08 11:27:30.93 spid55      *             select * from [KSLAP208].[C003]..PA_Profile_BASE_1119

I am able to do this same exact select * from a different server without problems!

What's happening here? Is this some kind of 2012 bug or a memory issue?

share|improve this question
    
what happens when you select field1, field2, field3, field4, ...field10+ from mytable from another table? You said select * works, but is everything you do from the other server exactly the same with different results? –  Amanda Feb 8 '13 at 20:12
    
amanda thank you for your comment. no i am unable to select more than some number of columns from another table. select* works from a different server, and any number of fields works from a different server, but not this one –  Yuck Feb 8 '13 at 20:14
    
let me clarify. i have sql 2005 and sql 2012, they are both linking to this one server. the 2005 is able to do any select, the 2012 is not –  Yuck Feb 8 '13 at 20:15
1  
related question. Do you have anything in the event log that can help you? What about anything in the logs of the server hosting your Pervasive instance? –  swasheck Feb 8 '13 at 20:26
1  
So have you checked that Stack Dump file? That should help guide you to what actually crashed. –  Marian Feb 8 '13 at 20:46
show 8 more comments

1 Answer 1

up vote 1 down vote accepted

So you are using Microsoft OLE DB Provider for ODBC (MSDASQL) which is presumably pointing to the ODBC DSN for your Pervasive data source. Since the error is an Access Violation (AV), I'm willing to bet that the AV is raised due to something going wrong in the Pervasive ODBC driver. Since you also mention that this query works from some other machine, can you double check the:

  1. ODBC DSN configuration between the 'bad' machine and the 'good' machine?
  2. The ODBC driver version for Pervasive - is it the same on both 'good' and 'bad' machines?
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.