Results 1 to 3 of 3

Thread: how to connect to hosted MS Access database @ godaddy

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2021
    Posts
    10

    how to connect to hosted MS Access database @ godaddy

    Hi!

    We have an old website developed in classic ASP on a shared hosting plan @ Godaddy that uses an access database which is stored in a folder \access_db.

    The website attracts very low traffic and a refresh is not on the cards in the immediate term.

    I understand Godaddy offers MS SQL or MySQL db support but not MS Access and it would be too much work to upgrade the local vb6 application which also works off a MS Access database.

    We currently FTP a copy of the database (ie. full not incremental) on a daily basis however randomly and we suspect it is because the site is being used it goes down most likely due to the database locked/in use.

    Instead of closing the DB connection and showing a temporary landing page 'under maintenance' until we have the database uploaded we are investing how we can connect to the database to insert the new rows which is the preferred option but stuck! Any ideas please if there is an option?

    cheers

    Jay
    Last edited by jaybeegee66; Oct 1st, 2021 at 02:36 PM.

  2. #2
    PowerPoster
    Join Date
    Jun 2013
    Posts
    7,219

    Re: how to connect to hosted MS Access database @ godaddy

    Quote Originally Posted by jaybeegee66 View Post
    ... how we can connect to the database to insert the new rows which is the preferred option but stuck!
    It kind of depends, how you currently handle these "Inserts" in your normal Desktop-App.

    What I mean is, whether you're using "String-Concats" of the form:
    Cnn.Execute "Insert Into SomeTable(ID, SomeField,...) Values(...,...,...)"

    ...or whether you currently use Rs.Update or Rs.UpdateBatch in your App
    (to do your DB-changes).

    In the end, you will not "connect directly from the clientside" to your DB on the WebServer.
    You will have to go "through an *.asp Script instead" ... which will then contain VBScript-Functions which:
    - create a serverside, temporary Cnn-Object against the serverside located "local DB"
    - and then does either a serverside Cnn.Execute (on the String you passed along into that script)
    - or alternatively you do an Rs.UpdateBatch call, to change the DB-state (after you uploaded the Rs, which contains the changes)

    HTH

    Olaf

  3. #3

    Thread Starter
    New Member
    Join Date
    Oct 2021
    Posts
    10

    Re: how to connect to hosted MS Access database @ godaddy

    thank you - that does help indeed as it gives some ideas. So we will upload a db containing the records to insert and see how to figure out a way to insert the records. appreciate you taking the time to respond. br
    jay

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width