Search results for query: *

restore db 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...

strPatientD = "Select * From tblPatientRegister Where Surname = '" & Replace(txtSurname.Text, "'", "''") & "' And DoB = #" & dtpDoB.Text & "# And Gender = '" & Replace(cboGender.Text, "'", "''") & "'"

hmmm, i only meant to use the response.write(session("blah")) to illustrate how you can use the session variable. remove that response.write line and you should be okay.

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" response.write(session("blah")) i think the error you are getting the error because the variable has not been initialized before you try to increment it. also, with...

why don't you save the data to session variables?

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.

you can use the backup feature in sql management studio to backup the complete database

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...

TextBox7.Text = DateAndTime.Now if you want this code to run when your program to run then one of the places you can put it in is the form load event.

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...

Dim objConnection As DataTier.Connection Dim objQueryCount As DataTier.Query i do not recognize this code. is this some custom data access you are using? if so, lookup the syntax for the methods you are using. make sure you passing the datatype which the interface of the calling method is...

No, it's not entirely impossible to access remote mdb file. But given the circumstances, especially hosted ISP environment, it is not feasible to do what you normally can in a local LAN environment. But that doesn't mean you are completely locked out of your mdb file. you can still create web...

i don't see anything that would limit the size of the input text on the frontend code. what's the backend code like?

Hi Xuan, support for remote access with regards to CSDL Access is very limited especially if it's not on a local network. If it is hosted in an ISP environment, you will not be able to take advantage of it from distributed applications. You might look into the possibility of mySql as almost...

objQueryCount = objConnection.CreateQuery(countsql) don't you want to pass a sql string in to createquery()???