DataSource Controls :: Start Sql Agent Job From Website
Jun 25, 2010Start Sql Agent Job from Website Can this be done in VB?
View 2 RepliesStart Sql Agent Job from Website Can this be done in VB?
View 2 RepliesWell I would like to get understanding on sql server security. how to map windows user eg:'srm123' to sql server agent so that user when logins in sql server can also work with sql server agent.bydefault u can not see sql server aqent icon in ssms in userlogin.what is a role of a proxy and credentials how to map them with windows user to workwith jobs and alerts.
View 1 RepliesI have setup a job in SQL Server Agent which run a store procedure.
[Code]....
After the job excuted, the temp table have not been created.
If I type "exec data_syn_ClearAllEposData". The temp table has been created.
Global Temp table cannot create in SQL SERVER AGENT?
What is the right approach when users (authenticated domain admins) should be able to start batch jobs (usually exe files) from an IIS (7.x) aspx (c#) page? This is an intranet site. The batch jobs have to run on the web server as Domain Admins. The website pool is executed by network service or some similar restricted account in AD.
Approaches I can think of (and their disadvantages):
1. Start exe file with System.Diagnostics.Process.Start with another account. This feature is disabled in IIS 7.x, how do I allow it?
2. Create a sheduled task and call scheduled task-api. This unmanaged dll is giving VS compiler warnings because it's unsafe to call from managed code.
3. I suppose there's a better approach, because the previous suggestions doesn't appear safe or robust.
I have table from following structure
CREATE TABLE [dbo].[tblChildTest](
[ChildID] [int] IDENTITY(1,1) NOT NULL,
[DOB] [datetime] NOT NULL,
[AdmissionNo] [nvarchar](100) COLLATE Latin1_General_CI_AS NULL,
[FirstName] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
[LastName] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
[Imported] [tinyint] NULL
) ON [PRIMARY]
I want upload csv file data using sql bulk upload . ChildID is autonumber , so i want start data upload from second column. i want omit childid and start from DOB.
I have installed SQL Server 2008 at my machine.
When trying to debug....i am getting following message...
"Unable to start T -SQL Debugging. Could not connect to computer AMIT. The workstation service has not been started."
While writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
How to start at a specific record and returning only the next 5 records with T-SQL command
[Code]....
That is my concatenated SQL statement but it obviously does not work because it only looks at the top 5 records in the entire table instead of what I intended which would be to look at the top 5 records starting with the record where PostNumber equals the value of lastPost. I have been searching for a T-SQL statement that will allow me to do this but I can't find one.
I have a web site in Default Web Site that has been working fine.
Recently I have installed Sharepoint. Now the default web site is not working. I type in http://localhost to even test to see whether asp.net is working fine but all I can see after typing that in is HTTP 404 NOT FOUND error.
I have reasonable experience programming for windows form programs in VB 2005, but I am new in ASP.NET. I have tried the file system website, and it does not seems to have a problem for me. However, when I was trying to create a website to run with IIS, it failed. This is what happened, to start, I chose location:HTTP on the "new web site" dialog box, and using browse button, I opened the "choose location" dialogbox. I choose "Local IIS" on the lefthand side. Then, I create new virtual directory, with the alias name "Test" and folder c:my documentweb site st (new and empty directory). Then I clicked the open button, it was still fine, where it returned to the "new web site" dialog box. However, when I clicked the OK button on the "New Web Site" dialog box, it comes up with this error:
"Configuring web site 'http://localhost/Test' to ASP.NET 2.0 failed. You may need to manually configure this site for ASP.NET 2.0 in order for your site to run correctly"
When I clicked OK, it does come up with a blank website, however if I run it, it will comes up with this error:
"Unable to start debugging on the web server. The server does not support debugging of ASP.NET and ATL Server application. Click Help for more information on how to enable debugging" but there is no Help button!
By the way, all the trials are done in VB2005/ASP.NET 2.0, we are trying to upgrade to VB2010 sometimes next year. The computer is running Windows XP.
how to get control over the Massegbox pup Up prompet ..i login withe C# code to webpage and want to dawnload file form there after chosing day parameter the ansews i have get from javascript the dont give me URL just massegbox show up and i have to click ok to donwload it or cancel!!! i want to download the file without showing the Messegbox and clicking ok wiche C# code how can i get it working? i tried:
1- withe webclient but not working idont have URL
2-withe response i got error iwill be happy if any one got agood ansewr for it.
I have a website hosted in IIS 6 and I can't start the website after I stop it. I have to bounce the whole box just to start the website again. I don't see anything logged in the event viewer and I don't know what is causing it.
View 3 RepliesIam going to develop the Multilingual website using c# asp.net 3.5 i want to know what things are important to know or from where i can get start any resource or links or help is apperiacted.
View 15 RepliesI want to start and stop IIS on remote server using asp.net website.
When i try to stop IIS on remote PC, it raises error. I am using the following syntax "PsExec \Server2 -u Administrator -p somePassword IISReset /STOP". This works fine when called within VS IDE or from another C# code. However does not work when called from within asp.net app. I am using "Administrator" as user which has Admin access to both of machines.
I have worked mostly with PHP when creating web sites driven by dynamic content. However I am wanting to start writting more applications in ASP. So I have a copule of questions that I can't seem to find the exact answers I need.1) I'll be creating a website for a company and then later be adding an online ordering system for them - would I best be served by writting the entire site in MVC2 since I will be getting into an online ordering system?2) Does it make sense to create my own shopping cart system - or are there free packages out there in ASP.NET that I should be utilizing instead of rolling my own? I3)I am currently working in Visual Studio 2010 Beta 2 - this is using the .NET 4.0 framework - I thought it better to use this instead of my older Visual Studio 2005 Professional - if I can't afford the full package of VS 2010 once its released - will theexpress editions support all I need? 4)If I am building in 2010 will I have a problem getting the site hosted since that framework is still in Beta? And can you suggest a good web host to use for .NET hosting - I usually work with GoDaddy for all my hosting needs - but I'm not sure if anyonehas experience in how quickly they will update to the newest frameworks etc , or if I should be hosting somewhere else.
View 2 RepliesProblem Description: A person has to enter all his details and take a photo(While Taking his Snap in our website there will be a Image Component and we have to Initilize the Client System(Any Company Webcam)Webcam and below Image Component there will be a button(Take Snap) When he clicks on it , it should take his snap store it. After He fills all his details when he clicks on Save button, all the details along with that image should be Uploaded to the server.
1) How to Check Whether the Client has Installed any Webcam or Not First.
2) If the Client has Installed any Webcam then Initialize that Webcam When he clicks on Take Picture.
3) Stream that Video that is coming from that Webcam Inside our Image Control in Website.
4) After He Clicks on Save Image button that streaming should stop and still image should be saved.
5) Accessing that Image(Later Converting it to Byte Stream) and uploading Image along with his data to Sql Server.
In development, our Asp.Net 4 website takes a fairly lengthy time to start after the project libraries are built
We do a fair amount of population of statics etc, but not enough to justify the length of time it takes the app to come up (probably 3-4 minutes)
We aren't building the website, just the libraries, and batch != true in the compilation element in the .config file.
I will try log some diagnostics, but any other pointers would be useful
I want to design a website which displays on loading two tables each with it's respective data from a csv file. Then every minute the website automatically refreshes. This problem seems so simple! But yet the solution eludes me.
All of the files will be contained in 1 directory, not on a server but on a local machine. Such as sitting on the desktop. I understand if I use javascript I have to use ADO, and I'm still trying to work out how to use ASP. I am new with both languages. So far the only restriction is that I can't use PHP. So the jist so far as I can think right now is:
1. read the file
2. place the file into an array by splitting at the commas
3. write the array into td's ?????
4. then print all this out into a div ????
I have googled my heart out and can't seem to find what I'm looking for. or even piece together what I'm looking for. Everything with javascript and ADO's leads me to dead ends, I can't find anything on ASP that is helpful. Could someone write up some sample code for a resource? Or have a better solution?
I perform a httpwebrequest without setting the useragent property.The page where I send my request to response with [Code]....
View 3 RepliesI am currently using Request.Useragent.Contains("string1") and if string1 matches with my useragent i am writing it on to the page, now I have to check with a collection ( array or list or ..) which contains {"string1","string2","string3"} and Response.write the useragent if the Request.useragent contains any of the strings collection (string 1,2,3). I am unable to detemine this and if i use a list or array, i am getting a "cannot convert from string[] to string" exception when i use it with Request.Useragent.Contains.
If there is a better way of achieving this, let me know. Its important.
I need to generate small images for certain parts of text. Those will have to fit into the text seamlessly. I know I can not make up for every browser font settings available, but how do I have to check for Linux, Mac and Windows users depending on the user agent? I want to use the right font (of the three "Verdana, Arial, Helvetiva") for the right user agent OS.
So:How do I check for the OS? What do I have to compare to in the user agentWhere can I get the other two fonts. Does the Windows-included Verdana look the same as the one used on Linux (or, is it free anyway? I don't know much about fonts)? Where do I get Helvetica? Is it Mac OS licensed?
Any code examples can be in either c# or VB.NET. I can read both.
For the user agent string
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)
HttpContext.Current.Request.Browser.MajorVersion returns 3 and HttpContext.Current.Request.Browser.MinorVersion returns 5. So far so good.
However for this user agent string (seen in the wild by one of my users)
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2) Gecko/20100115 (CK-Finbu.com) Firefox/3.6 (.NET CLR 3.5.30729)
HttpContext.Current.Request.Browser.MajorVersion returns 1 and HttpContext.Current.Request.Browser.MinorVersion returns 9. It looks like ASP.NET has picked up the numbers from the CVS tag info rather than the browser version. Does this mean that ASP.NET's user agent parsing is broken?
I am trying to run a Stored Proc in 2008 using the sql agent. I read some posts on here and other places that say you can and I have tried what they said but isn't running. I can execute the proc form a query window and its working fine so its not my proc.I setup a job and then created a step named the step run stored procType: not sure here but I left it at default T-SQLChanged the database to the database where my sp is located Then in command i put exec dbo.sp_myprocname
View 2 RepliesI am facing grouping the agent wise in stored procedure, here i showned the table columns,views and stored procedures i used.
User Table columns
User_Id,pwd,Created_Dttm,Role,Status
Table1 columns[code]....
Problem is when i am group by A.Name i am getting error "Column 'V1.Target' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
I am trying to register the route collection in .net based on each session. The code I have works fine, you goto website/username and it loads the correct sub pages, but you have to restart the application to goto website/username2 to load those sub pages. But when the application is restarted the second one works, but then not the first one. Is there some way to create a different route collection per session not per application using system.web.routing.
View 3 Replies