db datatypes: click

Monday, March 12, 2012

Problem with Enterprise Manager 2000

Hi,
After installing XP SP2 security patches on my box, I can not open
Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
I get two error in event log,
========================
1. Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1000
Date:1/18/2005
Time:3:30:09 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
version 5.1.2600.0, fault address 0x0000bb5b.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6d 6d 63 ure mmc
0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
0020: 2e 32 36 30 30 2e 30 20 .2600.0
0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
0038: 36 30 30 2e 30 20 61 74 600.0 at
0040: 20 6f 66 66 73 65 74 20 offset
0048: 30 30 30 30 62 62 35 62 0000bb5b
0050: 0d 0a ..
2.
Event Type:Error
Event Source:Application Error
Event Category:None
Event ID:1001
Date:1/18/2005
Time:3:30:22 PM
User:N/A
Computer:WXPP-LT_AMINH
Description:
Fault bucket 02874011.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 42 75 63 6b 65 74 3a 20 Bucket:
0008: 30 32 38 37 34 30 31 31 02874011
0010: 0d 0a ..
=======================
I removed the patches using reollback option of XP, but after removal even
explorer crashes. I re-installed SQL client tools, but result is same...
Any one has idea how to resolve this?
Thanks,
Hiten
Maybe the snap-in has become corrupt or damaged.
Try renaming the existing SQL Server Enterprise Manager.MSC
file.
Then copy the SQL Server Enterprise Manager.MSC file from
the your SQL Server CD to the same location.
-Sue
On Tue, 18 Jan 2005 12:39:11 -0800, "Hiten"
<Hiten@.discussions.microsoft.com> wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
|||Someone with the same problem before SP2 found this to be a workaround:
http://groups-beta.google.com/group/...e66a3e81c65f5e
[I opened] mmc.exe in the Windows/system32 folder and add[ed]
the Enterprise Manager snap-in. Now I can just run enterprise
manager that way! It's not ideal, but it works :-)
Steve Kass
Drew University
Hiten wrote:

>Hi,
>After installing XP SP2 security patches on my box, I can not open
>Enterprise Manager. It crashes when I click on icon to bring the analyzer up.
>I get two error in event log,
>========================
>1. Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1000
>Date:1/18/2005
>Time:3:30:09 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Faulting application mmc.exe, version 5.1.2600.0, faulting module mmc.exe,
>version 5.1.2600.0, fault address 0x0000bb5b.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 41 70 70 6c 69 63 61 74 Applicat
>0008: 69 6f 6e 20 46 61 69 6c ion Fail
>0010: 75 72 65 20 20 6d 6d 63 ure mmc
>0018: 2e 65 78 65 20 35 2e 31 .exe 5.1
>0020: 2e 32 36 30 30 2e 30 20 .2600.0
>0028: 69 6e 20 6d 6d 63 2e 65 in mmc.e
>0030: 78 65 20 35 2e 31 2e 32 xe 5.1.2
>0038: 36 30 30 2e 30 20 61 74 600.0 at
>0040: 20 6f 66 66 73 65 74 20 offset
>0048: 30 30 30 30 62 62 35 62 0000bb5b
>0050: 0d 0a ..
>2.
>Event Type:Error
>Event Source:Application Error
>Event Category:None
>Event ID:1001
>Date:1/18/2005
>Time:3:30:22 PM
>User:N/A
>Computer:WXPP-LT_AMINH
>Description:
>Fault bucket 02874011.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 42 75 63 6b 65 74 3a 20 Bucket:
>0008: 30 32 38 37 34 30 31 31 02874011
>0010: 0d 0a ..
>=======================
>I removed the patches using reollback option of XP, but after removal even
>explorer crashes. I re-installed SQL client tools, but result is same...
>Any one has idea how to resolve this?
>Thanks,
>Hiten
>

Saturday, February 25, 2012

Problem with Delete function within a Gridview

I've got an issue that when I update a record in the gridview it works fine. When I click the delete link to remove the record from the database, I get the following error, "System.FormatException: Input string was not in a correct format". Part of the Stack Trace refers to "String oldValuesParameterFormatString". This parameter is in my SqlDataSource. It was dynamically created when I originally created the SqlDataSource with VWD 2005 Express Edition. The delete function will work if I remove "OldValuesParameterFormatString="original_{0}"ProviderName="System.Data.SqlClient",and any reference to "original_" in the DeleteCommand the SqlDataSource. But if I do, the update function doesn't work. Anyway, here's the SqlDataSource: Any help would be greatly appreciated!!!!!

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"

DeleteCommand="DELETE FROM [houses] WHERE [intID] = @.original_intID AND [street] = @.original_street AND [city] = @.original_city AND [state] = @.original_state AND [zip] = @.original_zip AND [status] = @.original_status AND [pDate] = @.original_pDate AND [sPrice] = @.original_sPrice AND [asPrice] = @.original_asPrice AND [actSalePrice] = @.original_actSalePrice AND [cToDate] = @.original_cToDate AND [rehabBudget] = @.original_rehabBudget AND [tDay] = @.original_tDay AND [eDate] = @.original_eDate AND [loDate] = @.original_loDate AND [rsDate] = @.original_rsDate AND [flooringDate] = @.original_flooringDate AND [estCompDate] = @.original_estCompDate AND [actCompDate] = @.original_actCompDate AND [coe] = @.original_coe AND [lDate] = @.original_lDate AND [credits] = @.original_credits AND [agent] = @.original_agent AND [insComplete] = @.original_insComplete AND [cEscrowDate] = @.original_cEscrowDate AND [bidValue] = @.original_bidValue AND [thomGuideNumber] = @.original_thomGuideNumber AND [locksmith] = @.original_locksmith AND [notes] = @.original_notes AND [hoa] = @.original_hoa"

InsertCommand="INSERT INTO [houses] ([street], [city], [state], [zip], [status], [pDate], [sPrice], [asPrice], [actSalePrice], [cToDate], [rehabBudget], [tDay], [eDate], [loDate], [rsDate], [flooringDate], [estCompDate], [actCompDate], [coe], [lDate], [credits], [agent], [insComplete], [cEscrowDate], [bidValue], [thomGuideNumber], [locksmith], [notes], [hoa]) VALUES (@.street, @.city, @.state, @.zip, @.status, @.pDate, @.sPrice, @.asPrice, @.actSalePrice, @.cToDate, @.rehabBudget, @.tDay, @.eDate, @.loDate, @.rsDate, @.flooringDate, @.estCompDate, @.actCompDate, @.coe, @.lDate, @.credits, @.agent, @.insComplete, @.cEscrowDate, @.bidValue, @.thomGuideNumber, @.locksmith, @.notes, @.hoa)"

OldValuesParameterFormatString="original_{0}"ProviderName="System.Data.SqlClient"

SelectCommand="SELECT * FROM [houses] WHERE ([intID] = @.intID)"

UpdateCommand="UPDATE [houses] SET [street] = @.street, [city] = @.city, [state] = @.state, [zip] = @.zip, [status] = @.status, [pDate] = @.pDate, [sPrice] = @.sPrice, [asPrice] = @.asPrice, [actSalePrice] = @.actSalePrice, [cToDate] = @.cToDate, [rehabBudget] = @.rehabBudget, [tDay] = @.tDay, [eDate] = @.eDate, [loDate] = @.loDate, [rsDate] = @.rsDate, [flooringDate] = @.flooringDate, [estCompDate] = @.estCompDate, [actCompDate] = @.actCompDate, [coe] = @.coe, [lDate] = @.lDate, [credits] = @.credits, [agent] = @.agent, [insComplete] = @.insComplete, [cEscrowDate] = @.cEscrowDate, [bidValue] = @.bidValue, [thomGuideNumber] = @.thomGuideNumber, [locksmith] = @.locksmith, [notes] = @.notes, [hoa] = @.hoa WHERE [intID] = @.original_intID">

If intID is your primary key fo the table, you can do it in a simple way. Please set DataKeyNames="intID" in your gridview and try:

DeleteCommand="DELETE FROM [houses] WHERE [intID] = @.intID"

<DeleteParameters>
<asp:ParameterName="intID"Type="Int32"/>

</DeleteParameters>

|||

limno:
If intID is your primary key fo the table, you can do it in a simple way. Please set DataKeyNames="intID" in your gridview and try:
DeleteCommand="DELETE FROM [houses] WHERE [intID] = @.intID"
<DeleteParameters>
<asp:ParameterName="intID"Type="Int32"/>

</DeleteParameters> 

Hey limno, thanks for the help. Unfortunately, it doesn't work. The record is not deleted. When I click the delete link, the page simply refreshes with the same data fields.

|||

Something strange happened to the reply above. Here it is again...

Hey limno, thanks for the help. Unfortunately, it doesn't work. The record is not deleted. When I click the delete link, the page simply refreshes with the same data fields.

|||

Hi tobias,

Please check in your Page_Load event handler to see if you have reloaded the DataSource by calling DataBind() method again. You need to check if it is a postback by using IsPostBack property.

If DataBind() is called, the operation will have no effect.

Monday, March 12, 2012

Problem with Enterprise Manager 2000

Saturday, February 25, 2012

Problem with Delete function within a Gridview

db datatypes

Blog Archive

About Me