DSN setup

<i><b>Originally posted by : Max</b></i><br /><br />My web hosting company has configure a DSN(mydatabase) for me at this path:e:/project/.<br />Initially, I set the "DSN=mydatabase" in the script. Its working fine.<br />Then later, the database is move to a new directory e:/project/DB called DB(under the same path).<br />So I change the script accordingly to "DSN=DB/mydatabase". But this time, it no longer work with error saying no DSN found. What can be the problem.<br />Thank You.

<i><b>Originally posted by : Mike B (mikeb811@hotmail.com)</b></i><br />The system administrator must use ODBC Manager on server to reconfigure DSN connection to point to new database location.<br /><br />Mike<br /><br /><br />------------<br />Max at 4/6/2000 2:17:05 AM<br /><br /><br />My web hosting company has configure a DSN(mydatabase) for me at this path:e:/project/.<br />Initially, I set the "DSN=mydatabase" in the script. Its working fine.<br />Then later, the database is move to a new directory e:/project/DB called DB(under the same path).<br />So I change the script accordingly to "DSN=DB/mydatabase". But this time, it no longer work with error saying no DSN found. What can be the problem.<br />Thank You.

<i><b>Originally posted by : Max</b></i><br /><br /><br /><br />I think the database is working fine. Because when I put my script in the same folder(DB) as the database. It work fine, it is only when my script is not in the same folder when the error occurs. The problem now is I don't know how write the script to access the database in the DB folder.<br />When both the scipt and database is in the same folder my script is "DSN=mydatabase" it work fine.<br />But now when the database is in another folder, how should I write my script. Should it be "DSN=DB=mydatabase" or somethingother way?

<i><b>Originally posted by : D.Alpha (d_alpha@zdnetmail.com)</b></i><br />Try using "global.asa" file. Whenever you change your database or Dsn file's location, just change the mapping path in the Session"ConnectionName_connectionstring"'s "DBQ" (database's path) or "FILEDSN" (Dsn file's path)<br /><br />In your script, just call the ConnectionName you declared in global.asa and it will be available within the entire site. <br /><br />Tips: you can create multiple ConnectionNames' as long as the names aren't the same.<br />:-)<br /><br />------------<br />Max at 4/6/2000 9:18:03 PM<br /><br /><br /><br /><br />I think the database is working fine. Because when I put my script in the same folder(DB) as the database. It work fine, it is only when my script is not in the same folder when the error occurs. The problem now is I don't know how write the script to access the database in the DB folder.<br />When both the scipt and database is in the same folder my script is "DSN=mydatabase" it work fine.<br />But now when the database is in another folder, how should I write my script. Should it be "DSN=DB=mydatabase" or somethingother way?