We are working on a application using sql server 2000 and vs 2003. We have recently migrated the database on an application to a new server and the application stopped working. We are getting the below error.
OleDBProperty 'Initial Catalog' was not found. The code that we are using where the error is coming is givent below.
[Code]....
The code was working fine earliar and became erroroneous only after database migration.
My application is hosted on IIS6.0 web server. And we observed that the initial page load time is high (30-40 sec) and further page loads take only 5sec.To bring down the page load time, I have deployed the precompiled web solution on IIS.But unfortunately the initial page load time did not came down to larger extent.
View 3 RepliesI just reinstalled VS 2010 Ultimate, and I accidently selected vb project as my preffered default VS settings, but I really wanted to select the Web Application as my default. Can somone guide me in the right place so I can correct this?
View 1 RepliesI have a simple web application that loads very slow the very first time after i deploy it. I am using ASP.NET 3.5 SP1 / VS 2008 / Linq / Web forms to load the default.aspx home page. It is a very light page with nothing too fancy.Now to debug this load issue, I logged all the events in the global file and got the following log text:
2010-04-10 11:58:38,083 - Application_Start
2010-04-10 11:58:38,111 - Application_BeginRequest
2010-04-10 11:58:38,117 - Application_AuthenticateRequest
2010-04-10 11:58:52,321 - Session_Start
2010-04-10 11:58:52,454 - Page_Load
2010-04-10 11:58:53,951 - End Page_load
2010-04-10 11:58:53,981 - Application_EndRequest
Now my question is, between the Application_AuthenticateRequest and Session_Start functions, there is generally around 10 - 15 seconds - which i believe seems to be the problem.The thing, I am unsure why this is slow between these two functions.I am not using any forms authentication.Also, I am not doing anything fancy in the global file besides setting a session variable.
I have created a webservice, which debugs fine with no errors, and published this on my localhost server for testing.
I have created a windows app which calls the webservice but am hitting problems as soon as I reach the point where the webservice tries to connect to its database.
The connectionstring is held within the web.config file of the webservice as
>><connectionStrings>
<add name="MyConnectionName" providerName="System.Data.ProviderName" connectionString="server=MyServerName; database=MyDataBaseName;uid=MyUser;pwd=MyPassword;"/>
</connectionStrings>
and called within the code by using the statement
>> System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionName"].ConnectionString
, and as I said before, this works perfectly when debugging the webservice application directly.
However, the windows application is not seeing the connection properly, if I use the statement as above I get a debug error stating that it is a NULL reference. If I change it to
>> System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString
I no longer get a debug error, but the connection is not made. On testing the above code it believes the name for connection 0 is "localSqlServer" and in both the web app and the webservice the error below is returned.
>>An attempt to attach an auto-named database for file \MyServerMyDirectoryMyProjectMyProjectApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
why the windows application see's the correct connection string code as null? Is there additional security I need to add for the web.config file to be accessible? Or does the connection strings need to be relicated within the app.config of the windows app?
Both applications are written in C# and I use Visual Studio 2010, ASP.Net version 4.0.30319
Over the last week I've been investigating an issue for one of our clients whereby the initial page load following a deployment of their website takes around 1 minute, resulting in unacceptable downtime for end users. This was happening not only for code deplyments (bin dll's and .config files) but also if there were large numbers of .aspx pages updated. For code deployments it's not an issue, but for aspx updates it is; in this particular scenario, we are making use of a 3rd party content management system (RedDot from OpenText) in which every page of the site is published out as a distinct .aspx page. This means that for this website there's somewhere in the region of 2,400 separate .aspx pages. I realise this isn't an ideal situation but we're working within the constraints of the CMS, and we managed to correlate the instances where the site was unresponsive with App pool restarts, which also corresponded to publications of of .aspx pages.
I found an article by Tess Ferandez [URL] which describes all the reasons why the app pool may restart, and it does seem that if more than 15 .aspx pages are changed then the app pool will recycle and the pages will be re-compiled. Another msdn article [URL] then gave me a few pointers on how to start addressing this problem, and for the moment I've set a flag on the compilation options to prevent batch compilation:
<compilation batch="false">
This means that the initial page load now takes around 6 seconds instead of 1 minute, which is a great improvement. However, I also used the "Compilations Total" performance counter to investigate the number of pages that have been compiled by ASP.NET for my site and was quite surprised that the total number of pages that get compiled peaks at 44, which is odd given that there are 2,400 aspx pages in the site. If the batch flag is set to false, the counter slowly increments by 1 page at a time as you click around on the site; if batch mode is true, the initial compilation takes the number straight to 44 over the course of ~60 seconds. What I'm really struggling to understand is why all 2,400 pages aren't compiled. Does anyone have any inside info on what might be going on as all the documentation I've read seems to indicate that all of the pages should be compiled and this counter should be much higher.
I have a catalog that hase standard pricing now i need to increase this to 5% for each product. this is the way i bind the data:
Price:<%#Eval("Price",
"{0:c}")%>
I am wondering if there are any good articles you could point me to that would present the implementation details or options for delivering advanced search capabilities. Like what we see at [url] and similar Web sites offering vast numbers of products to be searched. The search process for these starts with a simple "Search" text box - usually with auto-suggest. Then the user can drill down and narrow the search by [for example] price, manufacture, size, capacity, and other relevant attributes of the product being searched.
When I navigate such sites and search for products, drilling down into the various categories, it's easy to think that there is some complex engine behind the scenes that generates dynamic SQL to satisfy the various and potentially extensive criterion required to satisfy the search requests.
Or could it be simpler than that? In any case, I understand this question may not have a specific answer; so I'm hoping for some article or reference implementation I could study. Short of that, if any of you have implemented advanced search of a product catalog (presumably searching products stored in a reasonably normalized database; through 3NF or so); any critical implementation considerations would be appreciated. I'm particularly interested in the meta data that may have to be present in the underlying data set in order to satisfy some of the search requests.
I have created SQL CLR database project in 2010. when I try to deploy it to sql server 2008, it gives me error like Msg 6528, Level 16, State 1, Procedure UmAlQuraConverter, Line 2 Assembly 'SqlClassLibrary' was not found in the SQL catalog of database so, how to add SqlClasslibrary to sql catalog
View 1 Repliesi m developing a product Catalog. All fine, i want to manage wish list for product, which user wish to see, now my question is that how can i manage this wish list, coz i have no uniqueness of the user, coz ny one whether it is registerd or not can wish the product in my scope, i thought to distinguish the user by their IP address becoz this wish list is temporaray, how can i delete the record when user close the browser if go to the IP address for distinguish..
View 2 RepliesI am building UI for a large product catalog (millions of products).
I am using Sql Server, FreeText search and ASP.NET MVC.
Tables are normalized and indexed. Most queries take less then a second to return.
The issue is this. Let's say user does the search by keyword. On search results page I need to display/query for:
Display 20 matching products on first page(paged, sorted)
Total count of matching products for paging
List of stores only of all matching products
List of brands only of all matching products
List of colors only of all matching products
Each query takes about .5 to 1 seconds. Altogether it is like 5 seconds.
I would like to get the whole page to load under 1 second. There are several approaches:
Optimize queries even more. I already spent a lot of time on this one, so not sure it can be pushed further.Load products first, then load the rest of the information using AJAX. More like a workaround. Will need to revise UI.Re-organize data to be more Report friendly. Already aggregated a lot of fields.
I checked out several similar sites. For ex. [URL]. Not only they display the same information as I would like in under 1 second, but they also include statistics (number of results in each category).
The following is the search for keyword "white" [URL] How do sites like zappos, amazon make their results, filters and stats appear almost instantly?
Is there any good code (paid or open source) out there for:Handling PPC ads on our site? This would (hopefully) include pages to create ads, reports of ads run, determining what ad to show, and tracking billing.Adding comments to our site? This would (hopefully) include up/down/inappropiate votes on other's comments.A product catalog? This would (hopefully) include advanced search and entering product items.
View 1 RepliesI'm looking for a way to add 3 level product catalog to cart based on MVC musicstore sample:
root product categories
sub categories
products
Clicking in catalog item should show subitems with pictures.
Control is placed to Site.Master. It can be treeview in cart left side or horizontal menu in upper part of screen.
Data is read from database from controller.
How to implement this ? Which free control is best for this or is there sample code for this ?
I have different roles like Administrator ,Accountant, Clerk,Enforcment When user open Catalog Zone to add parts to Web part Zone i want only those parts should apper on the screen for which user selected Group,like if user selected Enforcement Group then Parts of that group should only appear in the Catalog Zone.
I want Catalog Zone cantains to be depend on which Group user was selected.
i want to add control 1, control 2 etc.. by default in Declarative Catalog Part
and using following code
[Code]....
but it only displays last item in it
any one guide me what mistake am i doing or what is the solution to my problem?
actually i want to give default 4-5 webparts options so that user could add it to page
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee
a list appears
kneepads
here's my getCompletionList
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim items As New List(Of String)
Dim myConnectionString As String
myConnectionString = GetSQLConnString()
Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK()
OVER (Order BY PartNumber, ShortDescription, LongDescription)"
[Code]....
I am debating between 2 scenarios for handling the display of a product catalog for a website redesign I am performing. I will be using the IIRF isapi filter to perform the rewriting for an asp.net website.
Here is what the urls will look like
[URL]
[URL]
[URL]
etc...
There will be a total of 8 or 9 product group pages
Scenario 1: I have these pages rewrite to one general purpose page that will look something like this:
[URL]
Then I decide which catalog to display with a switch/case based on the querystring. All of the code for displaying the catalogs would be based off of one page.
Scenario 2: I create a separate page for processing each different catalog page. The rewriting would look something like this then:
[URL]
Then each catalog page would have it's own .aspx to handle the processing and display of that group of items.
I am developing an intranet application that needs to authenticate against a global catalog server (containing about 14 domains). What would I use for the connection string?
GC://DC=mb,DC=rellish,DC=com
I'm really new at asp.net 3.5 I'm comming from Classic ASP and I have been experimenting with ASP.NET. I'm trying to use the ListView Control to display a products catalog comming from a database. My first test was succesfull but I have a question.I want to be able to display the title of the product in Bold if certain conditions exists for that product. I tried using the ItemDataBound event but I don't know how I to get the value from the database field.I have the following code
ASPX PAGE
[Code]....
CODE BEHIND
Protected Sub productsList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles productsList.ItemDataBound
Is it possible to have an initial drop box item that has a null value. For instance I have a drop box that iss linked to the EmployeeName column in the table Employees in and SQL Database. When running the page it shows the first employee, cn i hae it so when the page loads instead of selecting the first employee it would say something along the lines of "Please select employee..." Maybe have the text in grey to show that it needs something selecting.
View 3 RepliesOn our web server we have a search form that fires off multiple searches and combines the results into 1 page. The main search is of the indexing catalog for our web site. We have used this for several years and it works just fine. The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error. The word "weigh" works fine but if we add that "t" on the end it fails. Here is the error:
Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF, STRING, PREFIX_STRING. SQLSTATE=42000
This is the query at the time of execution:Select DocTitle,URL from SCOPE() where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by Rank DescDoes anyone have an idea of how to get past this problem? I'm guessing that "weight" is probably a key word or something similar.
I am trying to convert a asp page to asp.net.
I changed everything except this one line Set dbC = Server.CreateObject("ADOX.Catalog")
Can anyone suggest an equivalent to this ADOX.Catalog in asp.net This dbC is being used in the following way in asp
[code]....
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 RepliesI know that this question has been asked here before and I tried to implement the solutions I have found here but without success
View 2 RepliesI encounter a weird problem when I am run the app via F5 or View In Browser. When I run the following page for the first time, "Hello" is shown on the textbox. Clicked on the 'Click Me' button, the text is changed to "Clicked!". That's fine. Close the brower and run F5 (or View in Browser) again, the Textbox shows "Clicked!". It doesn't display the initial value anymore. I see this problem on IE6 (and thatis the only option for my employer), but not on FF3.6 nor Googgle Chrome 4.x. I thought it could be related ViewState. But, the problem persists after ViewState is disable.
Default.aspx File below:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
[Code].....