Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimjamjo
Starting Member
10 Posts |
 Posted - 2005-07-15 : 13:12:35
|
| Hi againI've had an Access db linked to MSDE on the same pc working fine for a few weeks. Two days ago a sql job starting failing with the following error:Error on Server:, Source:.Net SqlClient Data ProviderClass:19, Msg 0, State 0, Line 1SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.I also get sqlclient general network error. The job failed about 20 times until I thought i fixed it by applying msde SP4. But no.. it started failing again todayI get the same error if I use Jet or odbc (with various timeouts) to add the server. I also get it if I add a linked Excel spreadsheet and try to link to that!Here's another way of producing the same error:select * from opendatasource ( 'Microsoft.Jet.OLEDB.4.0', 'Data Source = D:\catalog.mdb')...tblAddressI'm running the latest MDAC 2.8 SP1 by the way.any ideas? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jimjamjo
Starting Member
10 Posts |
Posted - 2005-07-17 : 15:48:15
|
| Thanks but I'm getting this problem even just trying to return rows from a linked excel spreadsheet (without using BULK INSERT). I've already applied all the service packs but no luck.If I get the error, the file I'm trying to access becomes locked by sql until I stop the server and restart |
 |
|
|
jimjamjo
Starting Member
10 Posts |
Posted - 2005-07-18 : 05:05:45
|
| This is getting pretty grim!!I'm getting this message even when I alter a stored procedure now:SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. |
|
|
|
|
|
|
EXCEPTION_ACCESS_VIOLATION