You are probably connecting to the database that you are trying to restore.
When the database is in use, you can't restore it.
Change to master database then execute the statement restore the db.
If I was doing this, I would try to see if the request can be formatted properly. If it's not an option then I would use the Request.ServerVariables("Query_String") method and parse out the parameters.
Question: It seems like you are expecting an integer value, how come var2 is passing in a...
there are a number of ways to do this:
1. use an existing service (SMS gateway provider) which will charge a norminal fee for each message. fast, easy and reliable - they provide all the api calls you need and can even do email to sms so all you do is send an email in certain format to a...
you can use the existing windows feature "run as" to elevate the rights for the application to carry out the task or grant the user the appropriate rights. doing it this way will not require any modification to the existing application.
if you still want to do all this within the app, user...
that's application variable not session variable. try something like this in your page.
session ("blah") = "blah blah"
i think the error you are getting the error because the variable has not been initialized before you try to increment it.
SELECT tbl_Items.item, COALESCE (tbl_CustPrices.CustPrice, tbl_Items.List_Price) AS Price
FROM tbl_Items, tbl_CustPrices
WHERE (tbl_Items.item = @Param1) AND (tbl_CustPrices.CustCode = @Param2) AND (tbl_CustPrices.item = @Param1
you can't run the winform and set the datasource to "localhost" then run it on your machine.
you need to make sure that the database is accessible from your machine and set the datasource to point to the ip address that your hosting company provided.
yes, if you define your own data access class then it will dictate how your code interact with the db.
if your method requires an integer, you pass in an integer (assuming you use this integer to further define which query to run...)
if your method requires an sql statement, you'll need to...
what you are asking is not quite possible with shared hosting and/or web app.
web app isn't capable of firing requests on its own. if you have access to the box you can do it with windows service, windows script host, scheduled tasks, windows app...
if your hosting company is supporting mssql then you should go ahead and take advantage of it.
just one thing though, you'll need to make sure that on the client side, port 1433 (default sql port) must be opened.
PS. If you wish to send some non-english message, you could use private message...