Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb Accessing the database on a remote server

    Hi!

    I need to insert records into an Access database that is on a remote server (accessible via internet). How can I connect to it?

    Thanks,
    Bostjan

  • #2
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    you need to know the connection parameters for the server

    server name/location, database name and password...

    http://www.google.com/search?hl=en&i...ccess+Database

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Location
    The sunny side of the Alps
    Posts
    230
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, but I have troubles with connection string.

    This is what I use on a local server, but I cannot modify it for connection on a remote server
    PHP Code:
    adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" Server.MapPath("database.mdb"
    If i specify Server.MapPath("http://www.myweb.com/database.mdb") I get
    PHP Code:
    Server.MapPath() error 'ASP 0173 : 80004005' 

    Invalid Path Character 

    /schoolgrad/admin/admin_first_www.aspline 14 

    An invalid character was specified in the Path parameter 
    for the MapPath method


  •  

    Posting Permissions

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