Unhandled Exception In Mmc.exe: : Access Violation

Dec 19, 2005

Hi all,

Since yesterday I'm unable to lauch the enterprise manager, it gives
the following error :

Unhandled exception at 0x0101f07e in mmc.exe: 0xC0000005: Access
violation reading location 0x00000064.

The weird thing is that except installing the office xp PIA's I can't
image what else could be changed on my system.
I tried reinstalling, but still the same error.
I tried SP3a, still nothing changed.

Searched in some groups and it seems that not much can be found about
it, so my inspiration is running dry.

Anyone had this problem ? Anyone any suggestions how to solve it ?

Regards,

Koen

View 2 Replies

Bcp_sendrow Causing Unhandled Exception (0xC0000005: Access Violation Reading Location 0x00000123)

Jun 24, 2007

Hi,

Background:

This could be a simple C++ issue as I am not that familiar with the language. I am trying to prototype a small program to test the performance of inserting data using the BCP interface. I want to BCP data that my program generates and passes via program variables.

I have narrowed the issue down to a sprintf call. Following are two variations of the code - one that works and one that does not. The error happens when I try to execute the bcp_sendrow() call.

What is the appropriate way to create / send string data to the BCP interface. Any good examples available? I have created the following from the BulkCopyFromVariables example on the Microsoft SQL Server downloads site.

Thanks in advance, Kerry

---- Works ----

Code Snippet

for(idx=1; idx<=5; idx++){
//sprintf(k1, "%d", idx); //does not work...
sprintf(k1, "oo"); //works....

if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
printf("bcp_sendrow(hdbc1) Failed");
Cleanup();
return(9);
}
}

--- Causes Access Violation ----

Code Snippet

for(idx=1; idx<=5; idx++){
sprintf(k1, "%d", idx); //does not work...
//sprintf(k1, "oo"); //works....

if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
printf("bcp_sendrow(hdbc1) Failed");
Cleanup();
return(9);
}
}

--- Additional information ---

---------------------------
Target Table Definition
---------------------------

Code SnippetCREATE TABLE PtTest(
[ID] [int] IDENTITY(1,1) NOT NULL,
[PtID] [int] NOT NULL,
[ParamID] [nchar](10) NULL DEFAULT ((200)), --Above example trying to insert data here via k1 variable...
[ParamValue] [nchar](10) NULL DEFAULT ((200)),
[InsDate] [datetime] NULL DEFAULT (getdate()),
)

----------------------------

-----------------
Bind statements
-----------------

Code Snippet

int idx;
char k1[5];
char *terminator = "";

retcode = bcp_bind(hdbc1, (BYTE *)&idx, 0, sizeof(DBINT), NULL, 0, SQLINT4, 2);
if ( (retcode != SUCCEED) ) {
printf("bcp_bind(hdbc1) Failed");
Cleanup();
return(9);
}

retcode = bcp_bind(hdbc1, (BYTE *)&k1, 0, SQL_VARLEN_DATA, (UCHAR*)terminator, 1, SQLCHARACTER, 3);
if ( (retcode != SUCCEED) ) {
printf("bcp_bind(hdbc1) Failed");
Cleanup();
return(9);
}

Note: there are other bind statements...
-----------------

View 3 Replies View Related

URGENT - DTS - Need To Run The Object To Perform The Operation - Exception Access Violation

Jul 23, 2005

Aaaaaarrgghh ! (that's better)I am trying to convert a field within my Oracle 9i Database that is oftype BLOB (but this BLOB may contain a combination of clobs/varchars orimages such as gif images, jpg images) to Microsoft SQL Server 2000using Microsoft DTS.On trying to perform this simple conversion I recieved the error "Needto run the object to perform the operation - Exception AccessViolation" from Microsoft DTS and my table that contains this BLOBfield is not converted across.After further investigation I implemented the fixes suggested by theMicrosoft Knowledge Base and "sqldts.com" but still no joy the errorkept occuring.I discovered my modifying the step in the DTS package that handled thistable conversion that contained the BLOB column that when I changed thedata type on my SQL Server target table to VARBINARY and modified thequery so that only the BLOBs that contained clobs/varchars were broughtacross that the error went away.I then proceeded to create another DTS package step that had a querythat only brought across the BLOB column that contained images such asgif images/jpeg images etc. and the error went away and the target typefor the SQL Server target table was set to IMAGE.As the data for this BLOB contains a combination of VARCHARS/CLOBS(concatanted) and also GIF IMAGES/JPEGS in the same source column withOracle 9i I require the same in my target table within SQL server asone column (and I should be able to do that with type IMAGE especiallyas it can store larger objects than VARBINARY but any source BLOBS thatcontain VARCHAR/CLOBs don't seem to want to be loaded as IMAGE theywill only load in to VARBINARY).However judging by my experiences above this doesn't seem to bepossible ?Can anyone help me out with this ?I am on Microsoft SQL Server 2000 Service Pack 4 with latest MDAC(2.8.1).Cheers,Gary