Search results

  1. G

    database move 2000 > 2005

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

    Querystring Questions

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

    SQL MS Access

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

    Passing Public Variables between Web Forms

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

    sending text messages to cellphone

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

    Launch application with admin rights

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

    Passing Public Variables between Web Forms

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

    Passing Public Variables between Web Forms

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

    Help with a select statement from 2 tables pls

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

    Can connect to database on Net? I need help.

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

    How to Archiving Database?

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

    Help needed - displaying sql COUNT value

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

    Constant polling of API with Web App

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

    TextBox Display

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

    Can connect to database on Net? I need help.

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

    Help needed - displaying sql COUNT value

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

    Can connect to database on Net? I need help.

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

    textbox not saving full text...saving only first 128 characters?

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

    Can connect to database on Net? I need help.

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

    Help needed - displaying sql COUNT value

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