Start Working In Ajax
Apr 9, 2008Hello everybody,
i am Asit Kumar from Delhi
i want to start working in Ajax, currently i am working on .net 2.0
please tell me how to start, any book or online tutorial for a biggner
ADVERTISEMENT
Select Employees By Start Day For 8 Month Working
Jul 15, 2013I have this column Sdate in my Employees table. This value represent the start date working.
I need to get all of the employees that between 8 and 10 month of work from today. How can I do it?
Unable To Start Working On SQLserver Express 2005
Feb 2, 2008I'm having a 3.0 GHz machine with 512MB Ram. however when i tried to run sql server 2005. this is the result of the System Configuration Check
- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed
- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Minimum Hardware Requirement (Warning)
Messages
* Minimum Hardware Requirement
* The current system does not meet the minimum hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.
- IIS Feature Requirement (Warning)
Messages
* IIS Feature Requirement
* Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed
- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed
- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed
- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed
- ASP.Net Version Registration Requirement (Success)
Messages
* ASP.Net Version Registration Requirement
* Check Passed
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed
furthermore i get error 26 when trying to create new sql server database. and while doing the SQL server surface area configuration i got this message.:
SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------
Program Location:
at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)
HOpefully somebody out there will help me...or is this problem only appearing in sql server 2005 and would it be a better decision to install SQL server 2000...or if someone can help me rectify this problem i'll be really thankful.
Ajax Toggle Within A Gridview
Jul 2, 2007Ive got a table of items which holds the privacy settings for each user. The items can either be the value 1 = Yes ,or 0 = No. Is it possible to bind these two options to a checkbox? I tryed to simply bind it to the checkboxes "checked" property, But it errored. Does anyone know how to bind an int feild to a checkbox? cos in the long run I want to add ajax toggle items to the checkboxes, but i was also wondering why that errored, but i think its cos i did my binding wrong. thanks si!
View 2 Replies View RelatedSQL With AJAX Reorder List
Apr 6, 2008So far I'm able to populate an ajax control toolkit reorder list with an SQL table, but I can't get it to reorder through the database.The SQL table is something like this-int ListID, varchar Title, int SortingOrder (SortingOrder always goes 1-n, there are no duplicates and no gaps) When the user changes the position of an entry, I need the reorder list to update the SortingOrder of all the pages between the starting and ending place of the reordered entry. I already have that function written, ReorderListEntries (int OldSortingOrder, int NewSortingOrder), but how and where do I call it?Basically, when the user reorders the list, I need it to-1. get the old and new positions of the reordered entry.2. pass this information back to the server3. call ReorderListEntries (old,new)4. partial page refresh the listHelp with this one will be greatly appreciated.
View 1 Replies View RelatedAjax AutoSuggst Problem With LTR Languages
Aug 26, 2007Hi,
I Use Ajax auto suggest text box. this autosuggest text box lookup throw table string field(nvarchar).It works find for Numbers and English words. But When I use LTR languages like arabic,the textbox does not show anything at all.
I use UTF-8 and when I search this field it leads to correct results. and I use "sql Latin1 CP CI AS"but I don't know what is the problem with it.
Server Error In '/Reports' Application. With Ajax?
Apr 21, 2008default web site runs as a 2.0 application in a 2.0 application pool, the reports and reportserver run in application pool for 1.1
after adding the entries necessary to run ASP.NET AJAX stuff on my default web site the report manager and server both error out when trying to browse to
http://server/reports or http://server/reportserver
do I need to add something into the ReportManager web.config?
Server Error in '/Reports' Application.
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Child nodes are not allowed.
Source Error:
Line 33: -->
Line 34: <pages autoEventWireup="true" validateRequest="false">
Line 35: <controls>
Line 36: <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
Line 37: </controls>
Source File: d:inetpubwwwrootweb.config Line: 35
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
How To Make Ajax Accordion Visible Based On Drop
Jul 17, 2013I have a drop down list as stated below,
<asp:DropDownList ID="ddlStandardReports" runat="server" Height="25px" Style="font-family: Arial"
Width="250px">
<asp:ListItem Value="1">Patient Information Report</asp:ListItem>
<asp:ListItem Value="2">Patient Billing Report </asp:ListItem>
<asp:ListItem Value="3">Bill Collection Report</asp:ListItem>
Now for this 3 dropdownlist values, I have 3 Ajax Accordions in which i have designed my reports as stated below,
<div class="style1">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<div style="padding: 10px; width: 98%">
[code]....
Actually i have 20 reports like this (ie;2O DROPDOWNLIST VALUES AND 20 ACCORDIONS ONE FOR EACH),for reference i have added only 3 dropdownlist values and 3 accordions of code here.
My requirement is , on page_load only the first report (Patient Information Report)should be selected in dropdownlist and the report for the same(accordion)should be visible, and now if i select some other report name in the dropdownlist then that particular report accordion only should be visible,and all other reports(accordions)should be not visible.
IS Same? (RS Start In Window Severvices V RS Start In Configration)
Mar 30, 2007
1) RS Start in Window Severvices
2) RS Start in Configration
1) and 2) Is Same?
I think that It looks like same Operation.
Some Things Not Working In 2005 And Working In 2000
Mar 3, 2006hi
I had a view in which I did something like this
isnull(fld,val) as 'alias'
when I assign a value to this in the client (vb 6.0) it works ok in sql2000 but fails in 2005.
When I change the query to fld as 'alias' then it works ok in sql 2005 .
why ?? I still have sql 2000 (8.0) compatability.
Also some queries which are pretty badly written run on sql 2000 but dont run at all in sql 2005 ???
any clues or answers ?? it is some configuration issue ?
Thanks in advance.
ExecuteNonQuery - Add Working/Update Not Working
Jan 7, 2004I am writing a pgm that attaches to a SQL Server database. I have an Add stored procedure and an Update stored procedure. The two are almost identical, except for a couple parameters. However, the Add function works and the Update does not. Can anyone see why? I can't seem to find what the problem is...
This was my test:
Dim cmd As New SqlCommand("pContact_Update", cn)
'Dim cmd As New SqlCommand("pContact_Add", cn)
Try
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@UserId", SqlDbType.VarChar).Value = UserId
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = TextBox1.Text
[...etc more parameters...]
cmd.Parameters.Add("@Id", SqlDbType.VarChar).Value = ContactId
cn.Open()
cmd.ExecuteNonQuery()
Label1.Text = "done"
cn.Close()
Catch ex As Exception
Label1.Text = ex.Message
End Try
When I use the Add procedure, a record is added correctly and I receive the "done" message. When I use the Update procedure, the record is not updated, but I still receive the "done" message.
I have looked at the stored procedures and the syntax is correct according to SQL Server.
Please I would appreciate any advice...
SQL Won't Start. HELP
Mar 13, 2000I am experiencing a big problem with my SQL Server- it won't start. Every time I attempt to start it I get an error "Error 1069 (The service did not start due to logon failure) occurred while performing this service operation on the MSSQLService service. " sa will not work either. I have not made any system changes recently. I tried to use regrbld but nothing happened. Is there anything else I can do short of reinstalling SQL7?
View 3 Replies View RelatedCan I Start A DTS Pkg Via A SQL SP?
Jan 18, 2002Is it possible to start a DTS package from a SQL Stored Procedure? If so, do you have sample code for this invocation?
thx-
BT
Can't Start SQL 6.5
Jul 10, 2001...So glad there are still folks out there running 6.5! We've been running 6.5 and 7.0 for the last year or so (one of our apps required 6.5). SQL 6.5 is running on an Alpha box, and SQL 7.0 is running on an Intel box. I want to install 6.5 on yet another Intel box, then install 7.0 on that SAME box so that I can perform the DTS. (Doing DTS across different CPU types failed to transfer application objects.) After that is successful, I will uninstall the 6.5 on the Intel box and no longer use the Alpha box for SQL. Both the Alpha and Intel boxes are on the same Windows NT domain.
Here is the issue. After performing the CD install of 6.5 on the Intel box, I get a message that the install could not be performed successfully because the MSSQL service could not be started. When I attempt to start it manually from Control Panel, I get an NT Error 3 - that the path cannot be found. (And the errorlog says that the server is unnamed.) So the MSSQL folder exists, the MSSQL Server and SQL Exec services are visible in Control Panel (unstarted), the registry contains SQL Server info, but the only way I've been able to start SQL Server at all is by using the Net Start MSSQLserv command.
I have repeated this step a few times - by deleting the MSSQL folder and re-running SETUP. At no point does NT remove the MSSQL services or the registry entries. In the end, NT or MSSQL still cannot find the "path" needed to start up SQL Server.
What do I need to do to "reset the clock" so that NT knows where to find these services?
Is The Re-start Done?
Jan 27, 2006Hi,
I was trying to restore a master database. This is what I did:
1. rebuild the master database and it was successful
2. restart server in single mode with
sqlservr.exe -c -m
and I got the following window:
************************************************** ********
2006-01-27 10:30:01.49 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X
86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-01-27 10:30:01.52 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-27 10:30:01.52 server All rights reserved.
2006-01-27 10:30:01.52 server Server Process ID is 600.
2006-01-27 10:30:01.52 server Logging SQL Server messages in file 'e:Microso
ft SQL ServerMSSQLlogERRORLOG'.
2006-01-27 10:30:01.54 server SQL Server is starting at priority class 'norma
l'(4 CPUs detected).
2006-01-27 10:30:01.71 server SQL Server configured for thread mode processin
g.
2006-01-27 10:30:01.74 server Using dynamic lock allocation. [2500] Lock Bloc
ks, [5000] Lock Owner Blocks.
2006-01-27 10:30:01.99 server Attempting to initialize Distributed Transactio
n Coordinator.
2006-01-27 10:30:04.04 spid3 Warning ******************
2006-01-27 10:30:04.04 spid3 SQL Server started in single user mode. Updates
allowed to system catalogs.
2006-01-27 10:30:04.04 spid3 Starting up database 'master'.
2006-01-27 10:30:04.29 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2006-01-27 10:30:04.29 spid5 Starting up database 'model'.
2006-01-27 10:30:04.29 spid3 Server name is 'SQLTEST1'.
2006-01-27 10:30:04.31 spid7 Starting up database 'msdb'.
2006-01-27 10:30:04.31 spid8 Starting up database 'pubs'.
2006-01-27 10:30:04.31 spid9 Starting up database 'Northwind'.
2006-01-27 10:30:04.31 server SQL server listening on 10.10.4.17: 1433.
2006-01-27 10:30:04.33 server SQL server listening on 127.0.0.1: 1433.
2006-01-27 10:30:04.34 server SQL server listening on TCP, Shared Memory, Nam
ed Pipes.
2006-01-27 10:30:04.36 server SQL Server is ready for client connections
2006-01-27 10:30:04.67 spid5 Clearing tempdb database.
2006-01-27 10:30:05.54 spid5 Starting up database 'tempdb'.
2006-01-27 10:30:05.70 spid3 Recovery complete.
2006-01-27 10:30:05.70 spid3 SQL global counter collection task is created.
************************************************** **
Now an hour passed and the window is still there. The SSQL service manager on the toolbars still has a red icon but not green. My questions are how do I know the process is done? What is the next step after SQL global counter collection task? Where can I find more information?
Thanks a lot.
Mark
Where To Start?
Mar 1, 2004I have recently invested in a new server that is running SBS premium, this come with SQL server and as a result of which I feel its time for me to start getting to grips with it.
I have reasonable knowledge of database design and SQL, extensive experience with access and some with Oracle. I have however never dealt with SQL server.
I generally don't have too much trouble picking up new technologies, and was wondering if anyone can point me in the right direction for learning SQL server from scratch? Is it realistic to be able to achieve this without doing a formal course? I intend to start using it to develop data-driven websites and applications.
Any help, advice and/or pointers are greatly appreciated.
Cheers
Dan
Not Able To Start Any Job...
Apr 19, 2004Hi,
I am not able to start any SQL Server job. Trying to start a job from Enterprise Manger, I get no error but the job doesnt execute.
Looks like in the Application Log there was an error 'Unable to read local eventlog'. Is this related to the problem or what should I do to fix this.
Thanks for the help.
Get Start And End Of Given Day.
Apr 9, 2008Hi,
Getdate() will get me the date, but how I can calculate two other datetime values corresponding to the very first second and the very last second of the current day?
Eg.
Today is 2008-04-09 <whatever time>
Startdate should be 2008-04-09 00:00:01
Enddate should be 2008-04-09 23:59:59
Cheers,
Matt
Where To Start?
Sep 28, 2004Here's what I want to do:
I have a lot of instructions on how to do certain things for our department. I want to put these into a searchable database.
Right now, the way it's setup, there's a list of catagories, and under each catagory, a list of articles. Easy enough.
But, now I want to have an option to search for keywords that bring up different articles.
I realize that I will probably have to recode certain things which is fine.
How do I get started?? I have IIS 6.0 on Server 2003 with SQL Server 2005 Express installed.
I have no experience with databases, SQL, Access, etc.
Where Can I Start !!!!!
Feb 1, 2007Ram writes "Hi mate,
I am New in this forum.
I am working as developer in C++ and .net ( 4 Years).
I plan to do the SQL SERVER 2005 and do some Microsoft certification.
I really don't know where I can start and which source is suitable for me.
I already download the express edition and I play arround that.
could you all please help me for this.
I am awaiting your good response.
Cheer
Ram"
Get Start Day + End Day
Apr 24, 2008hi how to get the start day end day one row for each employee
like this
ID fname start day end day val_holiday
-------------------------------------------------------------------------------------
111 aaaa 15/03/2008 21/03/2008 1
222 bbb 02/05/2008 09/05/2008 3
333 ccc 03/04/2008 04/04/2008 3
-------------------------------------------------------------------------------------------------------- this is my table
ID fname new_date val_holiday
----------------------------------------------------
111 aaaa 15/03/2008 1
111 aaaa 16/03/2008 1
111 aaaa 18/03/2008 1
111 aaaa 19/03/2008 1
111 aaaa 20/03/2008 1
111 aaaa 21/03/2008 1
222 bbb 02/05/2008 3
222 bbb 03/05/2008 3
222 bbb 04/05/2008 3
222 bbb 05/05/2008 3
222 bbb 06/05/2008 3
222 bbb 07/05/2008 3
222 bbb 08/05/2008 3
222 bbb 09/05/2008 3
333 ccc 03/04/2008 4
333 ccc 04/04/2008 4
TNX
SQL Job Don't Start
Aug 22, 2006Hello
I have created a jon in the SQL Server Agent. This job will start 2 Integration Packages
One package for the etl, and one package for processing the cube
70 % of the time the job wil end success. But 30 % of the time the job wil fail.
I don't see anything in the log. This is the only message I see :
Executed as user: RLS01BIP01SYSTEM. The package execution failed. The step failed
anyone an idea??
Thx
Where To Start
Feb 22, 2008Where would be a good place to start learning SQL? I know all the links in the e-mail that I got sent when I registered....but there not very help full.
View 1 Replies View RelatedHow To Start
Apr 21, 2008Hello,
I'm new in the field of Microsoft products and particularly with the Microsoft SQL Server.
So in the beginning I would like to ask some questions and to understand the base lines.
First thing is, I heard that there are several editions of Microsoft SQL Server 2005 : standard, workgroup, express, developer.
I would like to know what is the difference between each of them. I suppose that developer means that it should be good for a developers to use this edition, but compared to the Standard edition or to the Express edition what are the main differences.
In my case I'll use the server for a little, not complicated, database and may be there will be a migration to do from some old Access database to the new one (under SQL Server). Is the edition of the SQL Server important for doing that ?
And my last question is about the compatibility between the SQL Server 2000 and 2005. In fact the server that is in use currently is version 2000 but in the future months the administrator plans to upgrade the software to the 2005 version.
So I'm asking myself, if I start to develop for directly for 2005 version, is the product will be entirely compatible with the current version (2000)?
That's all I think for now.
Best regards,
Tonio
Quick Start
Dec 15, 2006What is the parameters for starting & stoping sqlserver 2005 from start/run or from the command prompti tried 'sqlservr' & it didn't work
View 1 Replies View RelatedSQL Server Does Not Start
Aug 8, 2007I had a small power outage and after that, SQL Server (2000) is not starting. I press the start button, it looks like it tries to do something (since all the buttons get disabled) and then its back to square one. I tried this from command line: sqlservr.exe -c -f but it does not help either.
I checked the SQL Server logs and this is what I found:
2007-08-08 10:05:09.63 spid3 Starting up database 'master'.
2007-08-08 10:05:09.63 spid3 Error: 823, Severity: 24, State: 6.
2007-08-08 10:05:09.63 spid3 08/08/07 10:05:09 Stack Overflow Dump not possible - Exception c00000fd E at 0x004436DD
2007-08-08 10:05:09.63 spid3 Address=4436dd Exception Code = c00000fd
I tried to google but could not find a solid solution.
Cannot Start SQL Server
Jan 3, 2008Dear Friends,I cannot start my SQL Server 2005. When I'm trying to conect to local database it's showing me error:TITLE: Connect to Server------------------------------Cannot connect to WIN2006.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)This error mean that server not started.When I read more details (error log in SQL Configuration Manager) I found that the source of the problem - "master" table was compressed. It should be decompressed to start server. What's this? I'm seeing this kind of error first time. Need your advise guys!
View 9 Replies View RelatedCan't Start Services
Oct 26, 2004Sorry for the newbie question here:
I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.
How do I connect to the server?
Start N End Dates
Nov 7, 2004hi may i know how do i load a report based on the entered value for start and end date?
I understand that i have to create parameters and dataset but how to make use of them?
How Do I Start MSDE
Mar 1, 2005After installing WebMatrix on my computer, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Nothing displayed after I installed MSDE, such as the typical "Installation is complete."
Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP Home.
Any help or suggestions are truly appreciated.
SQL Server Will Not Start
Oct 13, 2005All,
I am having a problem and cannot get my instance of SQL Server 2000 to
start. When I check the event viewer, this is the error I see:
Error: 9003, Severity: 20, State: 1
The LSN (6:308:1) passed to log scan in database 'model' is invalid.
Any ideas?
Karls
SQLMail Won't Start Help !!!
Feb 27, 2001I have the following error when trying to test EMail from SQL.
I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330
mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.
Here's the error message.
xp_startmail 'eweb02mail'
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040106
Or right clicking on SQLMail and click on Test
xp_test_mapi_mail 0x80040106
Using Job To Start Job On Another Server
Apr 10, 2001Is there a way to start a job on another server from within a job?
View 1 Replies View Related