Professional Web Applications Themes

Connecting DB on other server - ASP Database

I use this string today: Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;D ata Source=" & Server.MapPath ("db/data.mdb") is it possible to use something like Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;D ata Source=" http:www.another-server.com/db/data.mdb") Maarten....

  1. #1

    Default Connecting DB on other server

    I use this string today:
    Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;D ata Source=" &
    Server.MapPath ("db/data.mdb")

    is it possible to use something like
    Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;D ata Source="
    http:www.another-server.com/db/data.mdb")

    Maarten.


    Maarten Guest

  2. #2

    Default Re: Connecting DB on other server

    Maarten wrote: 

    No. It has to be a file path (Access is a file-based database).

    See www.aspfaq.com or www.able-consulting.com/ado_conn.htm for ideas about
    connecting to an Access database on a remote server.

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  3. #3

    Default Re: Connecting DB on other server

    See http://www.aspfaq.com/2168

    (Hint: you need to know specifics about the file system on the remote
    server, and hope that they don't change.)

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Maarten" <com> wrote in message
    news:F%0id.9342$telenet-ops.be... 


    Aaron Guest

Similar Threads

  1. Connecting to SQL server
    By oscar in forum Dreamweaver AppDev
    Replies: 4
    Last Post: March 18th, 01:08 AM
  2. Connecting SQL Server with DW using ASP.NET VB
    By Mike1500 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 20th, 11:57 AM
  3. Connecting SQL Server to DW
    By Mike1500 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 17th, 06:49 PM
  4. Web Server connecting to Informix Server
    By Wilson, John in forum Informix
    Replies: 4
    Last Post: September 4th, 07:37 AM
  5. connecting to db on another server
    By Microsoft in forum ASP Database
    Replies: 0
    Last Post: July 26th, 03:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139