need asp help!

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

0
  1. #1
    Hi,

    I want to connect to a remote server to connect to a database that is on a different ftp.

    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
  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