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

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

  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