ORA-00911: invalid character when try to query with .net app

Yes it because when use command like
SELECT TABLE_NAME FROM user_TABLES; in sqlplus in don't have any problem.

But when use in command string in .net APP
it will throw exception "ORA-00911: invalid character"

yes get rid of ";" in the end of line solve problem.

- -'

enjoy your coding.

Oracle 10g Express listener.ora and connection files default location

I try to find this information finally I found it.

C:/oraclxe/app/oracle/product/10.2.0/server/NETWORK/ADMIN/

listener.ora
sqlnet.ora
tnsnames.ora

NUnit 2.5.5 and .NET 4 Testing

I have problem to load assembly .NET 4 to test
Yes compile to .NET 2 will don't have any problem but .NET 4 I can't open dll to test

To fix this we need to modified nunit.exe.config
In folder nunit.exe we used

by 2 step

1. Under <configuration> add:
<startup><requiredRuntime version="v4.0.30319" /></startup>
2. Under <runtime> add:
<loadFromRemoteSources enabled="true" />

Yes for me .NET is version 4.0.30319 (for now)

Thanks to this ref : http://beta.blogs.microsoft.co.il/blogs/dhelper/archive/2010/01/25/how-to-run-nunit-tests-created-with-vs2010-and-net-4.aspx

Change Facebook Group Name

For many mistake

Log in your Group as admin and to to tab "Info"
Click "Edit Information"
and change anything as you want.

Link between Area and not Area.

because if you are in some area you must change area before use other control in other area.

Html.ActionLink( "Home", "Index", "Home", new { area = "" }, null )

Html.ActionLink( "About", "About", "Home", new { area = "" }, null )

Html.ActionLink("Install", "Index", "Install", new { area = "Install" }, null)

How to set default route to Area

Is simple by open your {AreaName}AreaRegistration.cs

and use (Example I add Install Area and need it default page.)

public override void RegisterArea( AreaRegistrationContext context )
{
//context.MapRoute(
// "Install_default",
// "Install/{controller}/{action}/{id}",
// new { action = "Index", id = UrlParameter.Optional }
//);

context.MapRoute(
"Install_default",
"{controller}/{action}/{id}",
new { action = "Index", id = UrlParameter.Optional, controller = "Install" },
new { controller = "Install" }
);
}

No need to change other.

ref url is http://stackoverflow.com/questions/2140208/how-to-set-a-default-route-to-an-area-in-mvc

web.config error Column 'InvariantName' when use MySql.Data.MySqlClient

An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present.

It' happened when i move my webapp to localhost today
Yes I comment out for now to work on

DbProviderFactories

May be check later.

ICQ search in Firefox address bar

In your Firefox address bar type (without quotes) "about:config". In the filter box type browser.search.defaultenginename . Check what the value is (probably ICQ). Double-click (or right-click & select "Modify") anywhere on that line and a box should come up with the current default engine name. Just change it to Google and see if that fixes the problem. another parameter 'browser.search.selectedEngine', which was also set to ICQ search, but only in one account. I couldn't actually find it in any other account.
I also deactivated a heap of 'icqtoolbar.xxx' parameters. But none of that helped. What finally did the trick was changing 'keyword.url' from
'http://search.icq.com/search/afe_results.php?ch_id=afex&q='
to
'http://www.google.de/search?q='
which I got from doing a google search, and deleting everything after the search term.

ref : from http://support.mozilla.com/tiki-view_forum_thread.php?comments_parentId=650923&forumId=1

Email port services.

For default email port service is

POP3: 110
IMAP: 143
SMTP : 25


Secure SMTP (SSMTP) - port 465

Secure IMAP (IMAP4-SSL) - port 585

IMAP4 over SSL (IMAPS) - port 993

Secure POP3 (SSL-POP) - port 99

Check this port when server not response.

The transaction log is full sql fixed way.

With my current hosting i got this second time for this

Message: The transaction log for database 'horrorclub_net_DB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

this problem can resolve by runt two command.

DBCC SHRINKFILE ("HorrorClubStandUp_log", TRUNCATEONLY )
BACKUP LOG horrorclub_net_DB WITH TRUNCATE_ONLY

Yes Shrinkfile and backup it.

look like my database grow up everyday.


ref url : http://blog.nerdbank.net/2006/07/how-to-empty-sql-server-database.html

SmarterEmail permission check failed.

Will show this error

Failed /MailProcessing/ Folder Permissions Test
Notes: Cannot WRITE to the directory. Cannot DELETE from the directory. Please modify the permissions using NTFS.
Failed /App_Data/ Folder Permissions Test
Notes: Cannot WRITE to the directory. Cannot DELETE from the directory. Please modify the permissions using NTFS.

Just give permission Modify to user to pass permission test on both