1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

need asp help!

Discussion in 'C#' started by jim_323, Jul 28, 2008.

  1. #1
    Hi,

    I want to connect to a remote server to connect to a database that is on a different ftp.
    SEMrush
    I currently use the following code to connect to the database on the same ftp, but want to change it so it will connect to the database now on a different website/server.

    <%
    DIM CONNECT,DBCONN,SQL
    CONNECT="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("DBASE/USERMAN.MDB")
    Set DBCONN=Server.CreateObject("ADODB.Connection")
    DBCONN.OPEN CONNECT
    %>
    Code (markup):
    How can I do this?

    Regards,
     
    jim_323, Jul 28, 2008 IP
    SEMrush
  2. VishalVasani

    VishalVasani Peon

    Messages:
    560
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Hello,

    Access not allow remote connection. But you required to change the "Data Source" property according to your new server. Also required to shift your .mdb file to new FTP.
     
    VishalVasani, Jul 28, 2008 IP
  3. BABUPATHAN

    BABUPATHAN Member

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    never saw any script to connect remote db MS ACCESS
     
    BABUPATHAN, Jul 28, 2008 IP