Below show how to change stored procedure owner in MS SQL 2000 and 2005
http://dotnetfish.blogspot.com/2008/04/change-table-and-stored-procedure.html
Saturday, September 27, 2008
Friday, September 19, 2008
Remove Messenger (MSN or Yahoo) advertisement
I have applied a patch that able to remove the annoying advertisement for MSN Messenger. The patch not only able to remove the advertisement but many others [features] that come with the messenger.
My MSN Messenger is Version 2008 (Build 8.5.xxxxx). Go to http://apatch.org/downloads.php and download A-Patch for Windows Live Messenger 8.5. Extract the zip file and run the .exe file. No worry, it's safe. This is a cool patch with preview feature during the selection of unwanted feature. Try it.
My MSN Messenger is Version 2008 (Build 8.5.xxxxx). Go to http://apatch.org/downloads.php and download A-Patch for Windows Live Messenger 8.5. Extract the zip file and run the .exe file. No worry, it's safe. This is a cool patch with preview feature during the selection of unwanted feature. Try it.
Wednesday, September 17, 2008
DllRegisterServer failed with error code 0x80004005 ...
I was trying to register a dll with command prompt in Vista but error message prompt ".. DllRegisterServer failed with error code 0x80004005 ...."
finally i found out that is because of security issue. To solve this,
Go to Start --> All Programs --> Accessories, right-click Command Prompt, and then click Run as Administrator
finally i found out that is because of security issue. To solve this,
Go to Start --> All Programs --> Accessories, right-click Command Prompt, and then click Run as Administrator
Then use regsvr32 to register the DLL.
It's work.
It's work.
Tuesday, September 16, 2008
Automate SQL 2005 Express Database backup
I just want to share a very cool SQL Agent that allowed us to automate the database backup by simple setting. Thanks to the author Danilo Corallo for sharing and make life our easier.
Please check on http://www.codeproject.com/KB/database/SQLAgent.aspx
Sunday, September 14, 2008
osticket - admin login error "Authentication Required"
i have tried to setup osticket few times and i'm very sure that my admin username and password is correct but i still got error message "Authentication Required"
After browse and google around, i found one solution to enable me to login but i'm not sure what is the effact for this change.
go to scp/staff.inc.php, and find the line below
//1) is the user Logged in for real && is staff.
if(!is_object($thisuser) !$thisuser->getId() !$thisuser->isValid()){
comment out !$thisuser->isValid() and now become
if(!is_object($thisuser) !$thisuser->getId() /* !$thisuser->isValid()*/){
go to try again. it's working. Perhap, someone can tell me what is the issue and i'm not php expert. Not working on 15 Sep 2008
Update: 15 Sep 2008
No Luck. It only work for one day. Not sure what happen and now not working. I'll keep updating this post until get some solution or work around. I have to un comment previous changes.
Solution:
line 41 in scp\login.php, comment out @header("Location: $dest"); and try again.
// @header("Location: $dest");
it's work for me, at least for now.
Update: 21 Sep 2008
It's working fine since changes on 15 Sep 2008. SOLVED!
After browse and google around, i found one solution to enable me to login but i'm not sure what is the effact for this change.
go to scp/staff.inc.php, and find the line below
//1) is the user Logged in for real && is staff.
if(!is_object($thisuser) !$thisuser->getId() !$thisuser->isValid()){
comment out !$thisuser->isValid() and now become
if(!is_object($thisuser) !$thisuser->getId() /* !$thisuser->isValid()*/){
go to try again. it's working. Perhap, someone can tell me what is the issue and i'm not php expert. Not working on 15 Sep 2008
Update: 15 Sep 2008
No Luck. It only work for one day. Not sure what happen and now not working. I'll keep updating this post until get some solution or work around. I have to un comment previous changes.
Solution:
line 41 in scp\login.php, comment out @header("Location: $dest"); and try again.
// @header("Location: $dest");
it's work for me, at least for now.
Update: 21 Sep 2008
It's working fine since changes on 15 Sep 2008. SOLVED!
The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
I have download an open source asp.net app. The database supported is SQL Express. When i try to run the app, error message [The user instance login flag is not supported on this version of SQL Server. The connection will be closed. ].
The reason is my installed database is full version of mssql 2005 and not express version. In order to make it run in my development machine, i have change the connectionstring in tag
<connectionstrings> from
<add name="TDConnectionString" connectionString="data source=.\SQLExpress;Integrated Security=SSPI;AttachDBFilename=DataDirectoryTD.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
to
<add name="TDConnectionString"
connectionString="server=.\SQLSERVER2005;database=TD;uid=xxx;pwd=xxxxx"
providerName="System.Data.SqlClient" />
where ".\SQLSERVER2005" is my database server.
It's works now.
The reason is my installed database is full version of mssql 2005 and not express version. In order to make it run in my development machine, i have change the connectionstring in tag
<connectionstrings> from
<add name="TDConnectionString" connectionString="data source=.\SQLExpress;Integrated Security=SSPI;AttachDBFilename=DataDirectoryTD.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
to
<add name="TDConnectionString"
connectionString="server=.\SQLSERVER2005;database=TD;uid=xxx;pwd=xxxxx"
providerName="System.Data.SqlClient" />
where ".\SQLSERVER2005" is my database server.
It's works now.
Monday, September 8, 2008
Call VBScript in Javascript
Well, it's actually working fine in IE but not other browser. As we all know, client side vbscript is microsoft product and it's only support in IE.
Try this,
<HTML>
<HEAD>
<SCRIPT LANGUAGE=vbscript>
Function vbFunc()
Msgbox("VBScript: Vb function")
End Function
</SCRIPT>
<SCRIPT LANGUAGE=javascript>
function jsFunc()
{
alert("Javascript: jsFunc function");
vbFunc();
}
</SCRIPT>
</HEAD>
<BODY onload="jsFunc()" >
</BODY>
</HTML>
Try this,
<HTML>
<HEAD>
<SCRIPT LANGUAGE=vbscript>
Function vbFunc()
Msgbox("VBScript: Vb function")
End Function
</SCRIPT>
<SCRIPT LANGUAGE=javascript>
function jsFunc()
{
alert("Javascript: jsFunc function");
vbFunc();
}
</SCRIPT>
</HEAD>
<BODY onload="jsFunc()" >
</BODY>
</HTML>
Sunday, September 7, 2008
Streamyx with D-Link 2640T Wireless ADSL Router
Just test on streamyx connection with D-Link 2640T Wireless ADSL Router.
For streamyx setting:
Happy surfing!
For streamyx setting:
- Open your internet browser and go to http://192.168.1.1/, default user name/password: admin/admin
- Click on wizard to run the setting. Click next to begin.
- 1st setting will be "Choose Time Zone", select the one relavent to your time zone. For me, i select [(GMT+08:00) Hong Kong,Perth,Singapore,Taipei] since there is no Kuala Lumpur. Click on Next.
- 2nd setting will be "Select Internet Connection Type (WAN)". For streamyx i select PPPoE/PPPoA and click next.
- 3rd setting is "Set PPPoE / PPPoA". For steamyx user, keyin your user name and password.
User Name: xxx@streamyx
Password: xxxxxxxx
VPI: 0 ---- 8 wont work for me, the status is waiting for response if i choose VPI: 8
VCI: 35
Connection Type: PPPOE LLC - 4th setting is "Set Wireless LAN Connection". This is up to user to set on it. Read the menu correctly.
- Save and restart your router. The status should be "connected" if you check the status tab.
Happy surfing!
Subscribe to:
Posts (Atom)