"Operation must use an updateable query" error
I was into developing a website using ASP.Net 2.0 and MS Access. I don’t have IIS installed on my development machine, so I was using default webserver from VS.Net and the code I was written was working fine.
Few days back, I got a Windows 2003 SP1 machine in my network, and I created a Virtual directory and pointed there. But while instering values in to DB I am getting “Operation must use an updateable query” error. And I got this page.
And I think (I am not sure) it may be because of this “The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the “Everyone” group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.(Microsoft Support)”
The search request was unable to connect to the Search Service
The WSS project I was working, we have to implement a search mechanism, it should search all the stuff. But the problem, I didn’t see the sharepoint search, and how the results will getting display? While clicking on the search button it will throws an error like “The search request was unable to connect to the Search Service”. I have tried lot of things like changing the Search service running permissions, etc. But nothing happend. And from one MSDN blog I got that I have to start the Indexing service, which is disabled by default. I have logged as Administartor and started the Indexing service from Administrative Tools > Services. Then Indexing Service. Changed the properties, disabled to manual. And started the service. Then I resets the IIS. Clicked Search, in the WSS screen
volia ! it is giving some results.
Update: How to install the Indexing service : Goto Control Panel > Add / Remove Programs > Add / Remove Windows Components > Select Indexing service, if not selected, Click Next, it will ask for Windows XP Service Pack 2 CD(If you are using Windows XP SP2). Then select the location, click ok, Windows will start installing the service. After installing, restart the system, Go to Services from Control Panel > Administrative Tools > Services Or Select Run > Type “Services.msc”, select Indexing service, right click and choose the option start
Error : WPSC is undefined
While playing with custom master page file in WSS 3.0, suddenly my Picture Library’s was stopped working. Getting some javascript error like “WPSC is undefined”. I am getting this error only in the picture librarys.
Suddenly I found I have removed on line from the default.master page while copy / paste.
<SharePoint:ScriptLink language=”javascript” name=”core.js” Defer=”true” runat=”server”/>
Now it is works fine.
Dynamically changing class name in javascript
We can change the class of an element in javascript using
document.getElementById("element").class = "new Style";
We don’t need to use style.attribute name. We can also change the style using, style property
document.getElementById("element").style.color="red";
Updating webparts
When working in a sharepoint project I have to create some webparts. Initially it was for the port 80 application, and was going fine, but when we created a new application in a different port, thing gone crazy. I have developed the web parts using VS Webpart template, clicking deploy webpart menu, only deploys the webpart on port 80 application. I have tried to modify the setup.bat and changed the url http://localhost to http://localhost:9090 but it is also not helped.
After some time, I un-installed the webprt assembly from GAC, re-installed the same with gacutil -i command. Then resets the IIS using “iisreset” command.
Now it is working fine.