FTP Login failure to ASP VBScript database using Visual Web Developer

Discussion in 'Databases' started by Kevred, Feb 6, 2010.

  1. Have recently started trying to set up Visual Web Developer Express to try to upload ASP VBScript database using FTP.

    Settings used:

    o Server: s02.Winhost.com
    o Port: 21
    o Directory: blank
    o Passive Mode: checked (have tried unchecked)
    o Anonymous Login: unchecked, "DB_3606_bailgate93ht_user"
    o Password: *******

    It seems to try 3 times and then I get this error message:

    "Unable to open website at 'ftp://s02.Winhost.com'. Could not find web server at s02.Winhost.com on port 21".

    Any help would be greatly received.
    Last edited by a moderator: Oct 14, 2015
  2. Ray


    s02.Winhost.com is the SQL server, this is not the web server. You cannot FTP to the SQL server. That port has been closed. It only listens to database calls. Log into your hosting control panel and under the Site Info Manager, you will see the server name for the web server and you should see your primary FTP address and secondary FTP address.
    Last edited by a moderator: Oct 14, 2015
  3. Thanks for this reply. I have already up loaded my website files to the web server. How do I up load my database file to the SQL server then? Sorry but I am missing a bit here. Sounds reasonable that you can not FTP the SQL server. So how do you get your database file onto the SQL server?
  4. Ray


    Last edited by a moderator: Oct 14, 2015
  5. Thnks, Ray!
  6. I have already tried to upload the MS database using the steps in the Win Host guidance notes. I am using MS Visual Web Developer 2008 Express Edition as suggested by the notes. The steps say: right click on database mdb file and choose “Publish to Provider”. But that option isn't there!
  7. Ray


  8. Thanks. I have worked out that for high volume database work I would need SQL etc. but my site is very low volume.

    I have got the MS Database working with a STRING = "DSN=DSN_[DSN name]" The Database is inside a folder within the actual website folder and I have used ftp to get it there. I read this somewhere and it works.
    This does not have a high level of security however. Does anyone know of an improved string or more importantly the routing from the website files to the database which is inside the website files. Probably something like "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/DWDynamic/mydatabase.mdb;User Id=admin;Password=;" Any ideas?
  9. Ray


    You really need not worry about the connection string being passed over the internet. Because you are passing it within the same network it will never go out through the internet. But if you want the data transfer to be encrypted then you cannot do this with Access only with MS SQL.
  10. Many thanks.

Share This Page