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.

ASP and Access testing environment; how do I update the DSN?

Discussion in 'Databases' started by yesyoucant, Oct 11, 2013.

0
  1. #1
    This web app/page was given to me for revision. I am completely new to ASP and Access. Right now I am trying to create a test environment so I have copied the ASP files and the MBD file associated with the site into another file on my server.

    How do I update the ASP files to reflect the test MBD file I've just created? For example it is still pulling from the old database.

    In the test ASP page I am working on, this is in the code:

    rsAllStudents.Open "SELECT * FROM students ORDER BY group_num", "DSN=MGMT5133"
    Code (markup):
    However, I need it to reference a different db... So I guess, how and where do I make the "DSN" designation change?
     
    Last edited: Oct 11, 2013
    yesyoucant, Oct 11, 2013 IP