muhammad Jubair's Blog

SQL Server 2005 linking another server in management studio express

2008-12-24T04:26:00.000-08:00

If you have two servers A and B. and you want to link Server B in managment studio express within Server A so that you can use queries to get data from a database in the Server B while remaining in Server A.

or if you want to create join queries from data in both the servers. You can use the link server facility of SQL Server.

here is the query you can use to link a new server

EXEC sp_addlinkedserver
@server='linkedsql', --this will be the server name that will be used in queries later onwards
@srvproduct='',
@provider='SQLNCLI', -- this is the product information
@datasrc='ip\servername' -- this is the server information

when you have linked the server and you want to query the server you can use query like

select * from linkedsql.dbname.dbo.tablename

but it will give you this error

Msg 18452, Level 14, State 1, Line 1

Login failed for user ''. The user is not associated with a trusted SQL Server connection

you have to provide the user credentials and the password for the sql server

You can use the following query to create the password and userid for the linked server.

EXEC sp_addlinkedsrvlogin 'linkedsql', 'false', NULL, 'userid', 'password'

You can also use the object explorer->linked server->properties->security-> be made using this security context. then enter the userid and password and click ok

SEO Related Issues in Drupal

2008-08-15T06:30:00.000-07:00

For enabling SEO on a website in Drupal you need to address the following issues:
1: You Need to enable Clean URLS on the site if these are not enabled.
2: install nodewords/metatag module of drupal
3: installation of Path module
4: installation of pathauto/config

then you need to configure static paths of the pages like

www.mysite.com/home instead of www.mysite.com/node/1

after doing this

edit each page and add meta tags like description and keywords to each page this will be enabled if you have installed nodewords/metatag.

Now you should install XML-sitemap and configure it so that it creates an XML of your site each time it is updated and send that XML to google yahoo and other search engines for parsing.

now you should install SEO - checklist and configure. This only checks the status of other modules listed above. Currently it is available for Drupal version 5.x and not for 6.x so please install 5.x for it else do not panic because this is not a required module for SEO in Drupal, it just helps a lot in checking the status.

ASP.NET popup with return values.

2008-05-22T23:50:00.000-07:00

Some people have problem creating a page that returns value to master window.

I found this article by Peter A. Bromberg, Ph.D. which is good to create popups with return values.

http://www.eggheadcafe.com/articles/20060117.asp

You can use the registerstartupscript and registerclientscript for many purposes.

string script = "<script language='javascript'>"
script += "alert('Hello');"
script += "</script>"

RegisterStartupScript("StartUp",script)

Remove HTML Tags from string in ASP Classic

2008-04-14T03:07:00.000-07:00

function removeHtmlChar(strText)
    l=len(strText)
          for i=1 to l
              ch=mid(strText,i,1)
x=i
if(ch="<")then
x=i
do while(mid(strText,x,1)<>">")

x=x+1

loop

t=t & " "
             elseif
(ch="&") then

x=i                  do While(mid(strText,x,1)<>";")
x=x+1                   loop

t=t & " "             else

t=t &ch              end
if
    i=x
    next
    strText=t
end function

How to Delete a file from Server (ASP Classic / ASP.NET)

2008-03-13T03:52:00.000-07:00

If you are using ASP Classic to delete a file from server you can use the following script:
<%
Dim filepath, strPhysicalPath
filepath = Session("filetodelete")
strPhysicalPath = Server.MapPath("directoryvirtualpath" & filepath)
set oFile = CreateObject("Scripting.FileSystemObject")
oFile.DeleteFile (strPhysicalPath), True
set oFile = nothing
%>

but if you are using ASP.Net You will need the Following Code:
Dim oDir As New DirectoryInfo(path)
Dim oFile As FileInfo
For Each oFile In oDir.GetFiles(SearchPattern)
oFile.Delete()
Next

AJAX.net Full page postBack Problem

2008-03-04T03:54:00.000-08:00

If you have this line in your web.config file

<xhtmlconformance mode="Legacy"></xhtmlconformance>

Then there will be a postback of whole page. Remove this from your Web.config for AJAX to run.

CSS Hover and I.E. 7

2008-03-04T02:26:00.000-08:00

I had a problem with cssHover. it was running fine in I.E.6 but with I.E. 7 it stopped hovering.
here is how to solve the problem.
Read the Article:
http://blogger.xs4all.nl/peterned/archive/2006/10/27/140300.aspx

To sum the Article you can use.

in csshover.htc, near line 34, change this :

if(!/MSIE (5|6)/.test(navigator.userAgent)) return;
to this:

if(!/MSIE (5|6|7)/.test(navigator.userAgent)) return;

Also please update the stylesheet to

Cache in ASP Classic

2008-02-14T22:18:00.001-08:00

Expire Cache and Cookies in ASP Classic

Here are the the commands to place at the top of your ASP scripts to ensure that the page is not cached:

<% Response.Expires = 60 Response.Expiresabsolute = Now() - 1 Response.AddHeader "pragma","no-cache" Response.AddHeader "cache-control","private" Response.CacheControl = "no-cache" %>

Response.Expires = 60
is said to expire at 60 seconds, not 0.

Response.Expiresabsolute=Now()-2
says "expire this page 48 hours ago", allowing for time differences, rather than specify a static date.

Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "no-cache"