Windows Service Install System.Security.SecurityException

by ebarcza 12/7/2015 7:23:00 AM

An exception occurred during the Install phase. System.Security.SecurityException: The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.

 

To get around this issue, just right mouse click on the 

Tags:

Paypal button and .NET aspx page

by ebarcza 9/21/2015 12:59:00 PM

Paypal buttons don't work on aspx pages with a master page usually b/c of the embedded form tags. You can't have a form within a form.

Quick fix hack alert - Before the paypal code enter a closing form tag (This will close the asp pages form) then remove the closing form tag from the paypal code and allow the end of .net page end form tag to close the paypals form.

Tags:

View Server State permisssion was denied on object 'server', database 'master'

by ebarcza 9/1/2015 2:29:00 PM

I just ran into this error when creating a new user. Hope this helps somebody

 

Run this query in the master database

GRANT VIEW SERVER STATE TO username;

 

Tags:

Remove all objects from a SQL Schema - Cannot drop schema because it is being referenced by object

by ebarcza 9/1/2015 2:09:00 PM

IF you run into this error when trying to delete a schema(usually as a result of trying to delete a user that owns a schema)

"Cannot drop schema because it is being referenced by object"

 

First run this sql to generate the statements that will execute the move

SELECT 'ALTER SCHEMA dbo TRANSFER [' + SysSchemas.Name + '].[' + DbObjects.Name + '];'
FROM sys.Objects DbObjects
INNER JOIN sys.Schemas SysSchemas ON DbObjects.schema_id = SysSchemas.schema_id
WHERE SysSchemas.Name = 'upstreamgasmgmt'
AND (DbObjects.Type IN ('U', 'P', 'V'))

The previous sql statement will return a set of records like this

ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[GetReportPoints];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[mappingTest];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[vwPhysicalZones];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[PantoneStaging_MeasurementVolumes];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[tbl_Volumes_PantonTest];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[test];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[ReportLAUFWellhead];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[November204BidWeek];

 

Copy and paste that result set into a query window and run it.

 

Now try and delete the schema again!

Tags:

Visual Studio - Command to collapse all sections of code?

by ebarcza 7/17/2013 1:22:00 PM
CTRL + M + O will collapse all.
 
CTRL + M + L will expand all.
 
CTRL + M + P will expand all and disable outlining.
 
CTRL + M + M will collapse/expand the current section.

Tags: ,

Visual Studio 2010

Pervasive drivers not showing up in ODBC

by ebarcza 7/3/2013 1:50:00 PM
I order to set up an ODBC connection to Pervasive SQL engine to grab some Sage 50/Peachtree data I had to use the odbc32.exe from the sysWOW64 folder. I hope this helps someone!

Tags:

Visual Studio Zoom

by ebarcza 7/3/2013 10:17:00 AM
Keyboard commands

You can use Control+Shift+Comma to zoom out and Control+Shift+Period to zoom in.

Tags:

Telerik radbutton Icons

by ebarcza 7/3/2013 10:10:00 AM
http://demos.telerik.com/aspnet-ajax/button/examples/embeddedicons/defaultcs.aspx

Tags:

GoDaddy Domain forwarding does not work

by ebarcza 7/2/2013 9:49:00 AM
This was my issue: For your domain name to forward, its A record must be pointed to 50.63.202.1.

Tags:

HOSTGATOR will shut you down with little to no notice - be careful

by ebarcza 6/28/2013 10:08:00 AM
(1:56:57pm)Joseph A.:Erik, we gave you plenty notice. 
(1:57:14pm)ERIK:what does plenty mean? 
(1:57:25pm)ERIK:you never contacted or called me 
(1:57:35pm)ERIK:you just shut me down 
(1:57:57pm)Joseph A.:While I do understand your frustrated, we notified you per that ticket. 
(1:58:31pm)ERIK:can you fix it? Or do I have to move things to another host 
(1:58:39pm)Joseph A.:I am working on that now. 
(1:59:08pm)ERIK:so when was this ticket started? I'd really like to know 
(1:59:29pm)Joseph A.:You can see it in your billing client. 
(1:59:38pm)ERIK:where is that 
(1:59:39pm)Joseph A.:2013-06-27 13:43:57 
(1:59:51pm)ERIK:that was yesterday 
(2:00:10pm)ERIK:You call less than 24 hours "PLENTY OF NOTICE" ???? 
(2:00:13pm)Joseph A.:Yes, we have to reclaim it if you don't reply back. 
(2:00:24pm)Joseph A.:There is a global shortage of IPs. The SSL was expired too long. 
(2:00:33pm)Joseph A.: have added the new information to the ticket and reopened it. Our admins will be checking it shortly and they will respond to you via email. 
(2:00:37pm)ERIK:that's going on my blog 
(2:01:02pm)ERIK:is 24 hours notice industry standard? 
(2:01:26pm)ERIK:curious to know 
(2:01:47pm)Joseph A.:It is, due to the global shortage of IPv4 addresses. 
(2:03:23pm)ERIK:first i've heard of 24 hours being industry standard... but oh well 
(2:04:07pm)Joseph A.:I can absolutely understand. 
(2:04:13pm)ERIK:I'll spread the word about hostgator's new 24 hour policy 
(2:04:45pm)ERIK:regardless, thanks for your help Joseph 
(2:05:13pm)Joseph A.:You're welcome! Is there anything else I can help you with today? 
(2:05:58pm)ERIK:where is the policy that states you only have 24 hours? I'd like to post that on my hosting blog 
(2:06:15pm)ERIK:so other people are aware 
(2:08:00pm)Joseph A.:I am sorry, there is no policy to disclaim to you. You can let your blog know that there is a global shortage in IPv4 IPs 
and we have to reclaim the IP if we do not get a prompt response in renewing the domain's SSL.

Tags:

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail

Calendar

<<  August 2016  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar

Recent comments

Tags

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2016

Sign in