July 8, 2002 at 12:08 am
I am trying to connect one SQL server 7 to Another SQL Server. My Query is : select * from ServerName.DatabaseName.tableowner.TableName. I get following exception : ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 15 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. or ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 12 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. At the same time i can access other tables from the same database using same query structure. Can anybody help me in getting what's going on?
July 8, 2002 at 10:04 am
Does this table have a different collation? Can you access it from Query Analyzer?
Might be a data issue.
Steve Jones
July 8, 2002 at 10:06 pm
No the query also does not work through Query Analyzer.
But it is not related to data issue.
July 9, 2002 at 6:02 am
What error does QA return when you run the query? Also have you set up a linked server and what parameters did you use?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 9, 2002 at 9:38 pm
Can you post the dump information? Should be in your SQL Server logfile. That may help us track down a Q article which corresponds to the problem you are seeing.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 10, 2002 at 2:20 am
(What error does QA return when you run the query)
Error return is as below....
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 38 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
(Also have you set up a linked server and what parameters did you use?)
Yes I Have set up the linked server
I have set up the remote server entry in master..sysservers of the sourceserver and the remote server, using sp_addlinkedserver command . Also theMSDTC service is up and running on both database servers.configured the WINS correctly on both servers
July 10, 2002 at 2:20 am
(What error does QA return when you run the query)
Error return is as below....
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 38 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
(Also have you set up a linked server and what parameters did you use?)
Yes I Have set up the linked server
I have set up the remote server entry in master..sysservers of the sourceserver and the remote server, using sp_addlinkedserver command . Also theMSDTC service is up and running on both database servers.configured the WINS correctly on both servers
July 10, 2002 at 9:22 am
Do you have any files like SQL00001.dmp on your server? The datestamp should match the time you ran the queries. The first couple of sections of those dumps have good info in them.
July 10, 2002 at 9:30 am
This isn't a linked server issue from the sound of it, but a data or other client side issue (or server side i guess).
A couple other things (besides those listed above):
Can you run this query from the server? Can you run it from another workstation?
Steve Jones
July 10, 2002 at 7:57 pm
There are a lot of possibilities and I don't know why I did not see the error message previously.
Check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224996
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 11, 2002 at 3:19 am
I searched for the log file but related to that query there is no specfic log file.
also i have Checked out
below url
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224996
according to the info specified in this url
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack SP1 for Microsoft SQL Server 7.0.
I had Ms SQL Server 7.0 with no Service Pack applied on it and also it is not possible to take risk to install service pack on production server,cause after installing service pack , server response becomes extremely slow.I am using people soft database and PeopleSoft Database is not compatible with Ms SQL Server7.0 SP
July 11, 2002 at 6:06 am
Ok first the database structure does not change and the speed should not degrade. I also would go with SP4. You also state PeopleSoft is not compatible, have you check with the software vendor to find out why and how to correct (I had not heard this at all from them). Finally the only way you will know for sure then is setup a test box and backup the database from the one server and restore to the test and try linked server. If error continues then try SP method and see if does fix. If so then you know this is the only option as it is a known bug or try to unmeet the conditions that cause it by moving the data to a single server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply