Running SQL Commands Using ASP.Net
I have been trawling the net to find a decent example of a way to connect to an sql 2000 server using asp.net and run a few commands.
One of the commands i need to run is: "EXEC sp_addlogin 'Albert', 'B1r12-36', 'forum2'"
how to do this, and display a 'successful' message on the page if the command completed successfully.
View Replies
ADVERTISEMENT
What is the syntax for running say. a batch file (.bat) from within ASP?
For example... in MS Access you can say something like this...
----------------------------------------------------------
CurrentDBDir = "c:"
ShellWait CurrentDBDir & "runthis.bat", vbNormalFocus
----------------------------------------------------------
This would run the "runthis.bat" file located in the c: directory. How would one accomplish this same thing in ASP?
View Replies
View Related
Is there a way to insert a word page break into an asp script? I have a script which uses the MS Word Document.ContentType to display a long table and I'd like to insert a page break at certain points so I can print it nicely.
View Replies
View Related
i have an asp page and id like to run some DOS commands to copy files around on the server to a new directory on the server, and then run an exe afterwards. some sites tell me its as simple as Code:
View Replies
View Related
I'm attempting to print to a Zebra printer (barcode) by taking the results of an .asp page and sending the output to the Zebra printer, which will interpret the output / embedded Zebra Program Language (ZPL).
Thus, printing the output at runtime. Does anyone know how to send a dos command from an .asp page that will send the .asp result output to a notepad file then send the notepad file to the printer at run-time? I tried the following code:
View Replies
View Related
Can someone explain what kind of commands demand most attention/resources from server and how an internet server distributes its time among web programs/users. You can also refer me to certain pages where I can read through it.
As far as I know, people prefer using objrs.execute statement instead of other commands like .addnew or .edit etc. the problem is since I don't know much about this hardcore stuff of DB, I continuously have to ask people on ASPFREE to help me. although here people here are awesome but the problem is that sometimes it takes too much time so it's better to have first hand info in your head.
View Replies
View Related
Is there a way to tell an asp file which set of commands to run depending on what file they just came from?
View Replies
View Related
I have an ASP page where I build a html table dynamically by reading a database table and populating the <TD> cells with the fields of each record.
I want the last field to be a html drop down list that contains values read from another db relation in the same db. It would seem to me, (i'm novice) that this would require nesting SQL SELECT Code:
View Replies
View Related
I'm trying to execute a Windows command in ASP. For example, this is a snippet of what I have right now:
....
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run("notepad", 1, true)
Set WshShell = Nothing
The strange thing is that notepad.exe actually appears under the list of processes in Task Manager, but its window does not show up on the server's desktop; the client's browser just sort of hangs. I'm led to believe that this has something to do with IIS permissions, but I'm not certain.
View Replies
View Related
Quick question: how can I execute Windows command (like deleting liles from
server) via ASP?
View Replies
View Related
How can I use WScript.Shell to execute Ms-DOS commands and can I see the
outputs commands in the asp page?
In the past, using Win. NT 4 Server and cmd..shell attribute to a variable I
could write the results in the screen page.
Any sample?
I couldnīt find any samples yet for win. 2000,ms-iii 5.0 and asp in my help
files, tutorials and guides, etc...
View Replies
View Related
I've installed iis6.0 on win2003. All static content with
ssi etc rendered fine on the browser, but gives a 500
internal server error if i try access any asp page. The
log file says:
ASP_0134|Invalid_ProgID_attribute 80 - 127.0.0.1
Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1. 1.4322)
500 0 0
All the dll files are in place and I have enabled asp
scripting. Can anybody give me a clue as to where am I
going wrong?
View Replies
View Related
I'm cobbling together an e-commerce site with thousands of items (spares, accessories etc) and want to distribute it as a catalog on CD. I don't fancy rewriting it to HTML. Is there any way to run the ASP and database on a CD-ROM. I've tried Dynamic-CD but it won't do the job and there is little or no help on their web site.
View Replies
View Related
I am trying to run a simple VB exe from the asp. I am using the following code
Set oWSH= Server.CreateObject("WScript.Shell")
oWSH.run "%COMSPEC% /C est est.exe",3, False
The exe is seen in the task manager. But it is not running. When I use this same command in the command window, it works fine. Can some please help me. It is for Intranet development. I am trying to run the exe in the server only.
View Replies
View Related
I have a new W2K3 box running IIS.Is there anything I have to install in order to use ADO?when I perform the following
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"
I get the error
Provider error '80004005'
Unspecified error
View Replies
View Related
I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it.
View Replies
View Related
I need to open asp.net solution files whose source location files have moved. I am creating new virtual directories on the fly (using vbscript) as part of a automated build process that are configured to point to my new source directory. The build is following because I get the following error
<b>Unable to open Web project 'Abc'. The file path 'c:dev...' does not correspond to the URL 'http://localhost/Abc'. The two need to map to the same server location. HTTP Error 404: Object Not Found.</b
I am getting around this in the build process by removing the <b>GlobalSection(ProjectConfiguration)</b> section from the *.sln file
Is there a proper way to avoid this error occuring
View Replies
View Related
is thier any way to run ASP files in apache just like php????? if yes how?
View Replies
View Related
Is there a way to open FrontPage automatically on a user's computer using a
web page?I wan't the user to be able to click a link or a button and have FrontPage
open to a specific URL. The FP permissions should take over from there.
I'm looking for the same kind of execution that you get when you type
View Replies
View Related
I am very new to asp programing, so this may seem a silly question but here goes.
I am creating a page that will generate random lotter numbers. I have created the actual code to generate the numbers and have added the code to the top of the page. the problem is the code runs when the page loads and I want it to run only on the click of a button.
I read various starter tutorials and none seem to mention how to asign code to the click of a button.
View Replies
View Related
I know there have been posts about this issue before, but I can't seem to find what I'm looking for. I'm not well versed in ASP, but in PHP there is a function called exec. This launches a process. I can call a PHP script from the command line and have it run in the background i.e.
<?php
exec(php myscript.php &);
?>
is there a way to do the same thing with ASP? I want to run an ASP script in the background
View Replies
View Related
I am trying to run an ASP page in IIS 6.0 and I keep getting one of
two errors:
-2147467259 (0x80004005)
The remote procedure call failed and did not execute.
I have Win XP. It's been running fine for a long time and then
yesterday, for no apparent reason, I get this. I've tried the links
to asp.faq that I've seen others post and nothing works.
As a test, I created a simple ASP page with just '<%
Response.Write("Hello") %>' in it and still the error occurs so it's
not a scripting or database problem. DotNet seems to run fine and I
can run HTML pages, I also have Apache and can run PHP scripts with no
problem ... everything except classic ASP.
Any ideas? This is driving me crazy and I need IIS running because I
am falling behind in my work. As I mentioned, I've been running ASP
scripts on this machine for years and have never seen this problem.
View Replies
View Related
I have Xp prof, IIs 5.1, .NET2003 on my machine.
I had the error "Visual studio.net has detected that the
specified web server is not runnning ASP.Net version 1.1.
Yow will be unable to run ASP.Net web applications or
services." in .NET 2003.
I fixed it by running the IIS mappings for ASP.NET,
aspnet_regiis -r. But I figured that my IIS had some issue
and I had to register the dll for IIS.
After doing that my .net is throwing the same
error, "Visual studio.net has detected that the specified
web server is not runnning ASP.Net version 1.1. Yow will
be unable to run ASP.Net web applications or services."
I ran the aspnet_regiis -r again it is overwriting the
1.1 .net framework scripts but the error in .Net is not
fixed.
I know my webserver is running Ok because I can develop
ASP pages using Visual Interdev and my default website is
running fine.
View Replies
View Related
Recently, I made a few ASP files connecting to MS Access file with security, I used IIS to test ASP files.
After it is done, I want the ASP files are accessed for each person via network in the company computer with security.
How can I setup a network which allow the person to run the ASP files?
Do I need to create a partition for network drive to run the ASP file/a server for running it?
View Replies
View Related
Here is a simple test class Ive built to try and find out, why another class I built (that works fine on my testing server running iis on xp) throws up an error on the live server running red hat 8.3 on linux, Im new to asp and only just now found out the live server is a linux box. Code:
View Replies
View Related
I want to make a simple simple asp page. All I want is when the page loads
it does "net stop <service>". The code is below, it is not running as
IUSR_<machine>, I am authenticating as Administrator yet the service does
not stop.
The blank page just loads with no errors and the service remains
running, what am I missing? I am completely new to ASP, I just want one
simple page for this purpose. Code:
View Replies
View Related
I installed pws(pws10a.exe) and tried running a sample asp code.I get nothing but a blank page.
View Replies
View Related
I am setting up a new server for an already running website. The problem is the person before me ran ASP scripts on .html extension pages (The old machine is a windows 2000 server with IIS 5.0). Now when I transfer all the pages on to the new machine I am having trouble running the ASP scripts on the .html pages.
The pages work fine when I rename them to .asp. But with the ..html extension I cannot run the scripts. I am thinking that I am missing some settings or some dlls which take care of running the ASP scripts on the ..html page. But I do not know what I am missing. Please post if you know
anything about this.
View Replies
View Related
if there are any disadvantages for running my whole site on SSL server (i.e All pages would run on SSL after the user logs in to their account).PS: The service I provide on my site doesn't require users to login everyday to their account. So I don't expect that heavy load.
View Replies
View Related
I have just moved a project to my laptop and get the message "Visual Studio..NET has detected that the specified Web server is not running ASP.NET v1.1.You will be unable to run ASP.NET Web applications or services"
Presumably there is a d/l on MSDN to rectify this, but I can't find it. Does anyone know the URL?
View Replies
View Related
Does ASP automatically run at the server or is it like .net and you have to tell it too.
View Replies
View Related
I am trying to perform a reboot on my server from an asp page. I have a link on my page that, when clicked on, redirects to a .stm page that displays a message about
the server rebooting and executes the following command:
<!-- #exec CMD="cmd.exe /C iisreset /REBOOT" -->.
When I click on the link the message is displayed but the server does not reboot. I know that in order for the #exec command to work you have to add a key in the registry,
and disable anonymous access to the folder containing the .stm page. I have done both of these and yet I still can't get the server to reboot. Can anyone help me with
this, or know another way that I can browse to an asp page on the server and perform a reboot?
View Replies
View Related
if it is possible to run a process after page has loaded? reason being is i have an application that uploads a file, then zip's it up. These are 50 megs sometimes, so zipping the file can take some time. It is a two stage process though, a user will upload a file, then fill out some more info, then submit, so while the user is filling out more info, I'd like to start zipping the file. Does anyone know if that is possible? and if so how to do it?
View Replies
View Related