Hi, I was using the oledbconnection to connect to my remote hosting server. But the hosting server has upgraded from ms sql 2000 to ms sql 2005. Now I am unable to get connection for my web application thro' ole db,while it is working for sql db connection. How can I get the connection enabled for oledb? Error message is Connection failed. SQLState '08001' SQL Server Error: 14 [DBNETLIB][ConnectionOpen(Invalid Instance()).Invalid Connection. Thanks Jith

Hi Mr. Paul I have one more doubt. If I want to get a value using SELECT Command in EXECUTE while using Stored Procedure. How to get it I tried Statement 1 : @GetValue = Exec('Select Id from table_'+@Category+' where name = @Name') Statement 2 : Exec('Select @GetValue = Id from table_'+@Category+' where name = @Name') But both are not working, Thanks Jith

Hi Paul, Thanks for you suggestion. It works well. Thanks Jith

Hi Guys I have a stored procedure which has the coding to insert values in tables with different suffix but one prefix. Eg table_fruits, table_vegetables, table_pulses etc., I am passing the suffix in the procedure. I dont know how to concat the suffix to insert the value in the specific table. create procedure [dbo].[my_proc]( @category varchar(30), @Name varchar(50)) As Begin insert into table_+@category+ value name=@Name; End I dont want to follow if(@category = 'fruits') insert into table_fruits values name=@Name; else if(@category = 'vegetables') etc ., etc., Is there any way to do this. Kindly help me. Thanks Jith

Hi Guys, I want to block the customer from logging in after 3 continuous attempts.I would like to block them for some duration(eg. 6 hours) so that they will not be able to login during that time period and afterwards the block is released. If anybody have coding or suggestion for my problem. please do reply. Thanks Jith

Hai Guys In my hosting site SSL is enabled. I am able to access login page in secure(https)mode. After this page i need to convert the url from https mode to http. How to do it? If you have any suggestions or coding, please reply. Thanks Jith

Hi guys, In my project I have to use a text area in which the description is entered. I want to restrict the users to use the html and script tags. I would like to allow the following tags bold , break , paragraph and underline. What is the coding that I have to use? If anybody knows the answer or have any suggestions , please reply. Thanks Jith

Hi, I tried using Gridview1.PageIndex = 0; in the SubmitButton Click Event after DataBinding, but it is not working. thanks, jith

Hi Guys, I am doing a search in which the results are displayed in a grid view.In the grid view attributes i have declared the PageSize=5 and PageIndex=10. My problem is when I have viewed the next pages in the grid view, If I give a new search condition the result set in the grid view loads with the same PageIndex. I would like to show my search result in the grid view starting from the first page, irrespective of the page index viewed for the last search. If anyone knows the solution or suggestion Please reply Thanks Jith

Hi Fred, Thanks for your solution. Thanks Jith

Hi, I just want to know how to extend/modify the session timing for an particular page in asp 2.0. Thanks Jith

Give commandname to the controls you use. then use e.commandname to get the control

Ensure that you have loaded the web.config file in your root directory Jith

Hi Guys, I have placed a google site search on my web site.The problem is, this search is working fine in a html page.but not on my web site.I have placed this code in my user control and called it. If anybody has suggestions for this please reply. Thanks Jith

Hi guys, I am programming web.sitemap for my web application.I am using one default page on which i am retrieving the content for the menus from the database with the help of querystring. The problem is I am unable to achieve the sitemap for my application.The asp:SiteMapPath control is unable to produce the navigating path. if anybody has suggestions for this problem please reply. Thanks Jith

Hi, How can I redirect other extensions files ? to my default page Thanks Jith

Hi, Is there any way that I could redirect the other extensions to my default page? Thanks, Jith

Hi Guys, I using the followiing code in my Web.config file <customErrors mode="RemoteOnly" defaultRedirect="default.aspx"> <error statusCode="404" redirect="default.aspx"/> </customErrors> My problem is if give an file name with extensions(like .htm,.php,.asp etc) other than .aspx the page is not redirecting to the default page. It shows the error page of the Browser. HTTP Error 404 -File or directory not found. I want to redirect it to my default page. If anybody has suggestions or coding .Please reply. Thanks Jith -- modified at 3:04 Friday 18th May, 2007

Hi Guys, I want my images on the page to load after the contents of the page are loaded.I have about 10 images in my page which causes the delay to load my page. If anyone has suggestions or coding please reply. Thanks jith

Hi Guys, I am using the ready made rss code for my site.The problem is that the feeds opens in the same page of my site.I want it to open in a separate page The rss coding is in the format If anybody have the coding or suggestions kindly reply. Thanks Jith