sql 7 database setup in IIS 4.0

<i><b>Originally posted by : adeeb ziada (adeeb.ziada@ussynergy.com)</b></i><br /><br />i am having a hard time seting up SQL 7 on IIS 4.0<br />can someone help on what i need to do to setup the database to work with the site, the site is done, using ASP and CGI but the database is not working on it. the code is running right, because it was tested. but once i upload it to the server, i cannot use the database, what do i need to do in ODBC. please help

<i><b>Originally posted by : Taufik HIdayat (htaufik@hotmail.com)</b></i><br /><br />Please, explain what your connection with database. I think you wrong with your connection script, example :<br /><br />1.Wrong : with name server site <br />"Server=mySite.com;Database=myDatabase;UID=sa;<br />PWD=;"<br /><br />2.Right : with name server local<br />"Server=myServer;Database=myDatabase;UID=sa;PWD=;"<br /><br />You must know what "name server local" where your project put it, don't using "name server site".<br /><br />Name server site : mySite.com<br />Name server local : myServer<br /><br />If you test before upload your ASP with "name server site" is do it, but if you upload your ASP you must change with name "name server local" where your ASP put it.<br /><br />Please, contact me if i wrong what do you mean. <br /><br />Best Regards,<br />Taufik Hidayat<br /><br />------------<br />adeeb ziada at 3/1/2001 11:50:40 AM<br /><br /><br />i am having a hard time seting up SQL 7 on IIS 4.0<br />can someone help on what i need to do to setup the database to work with the site, the site is done, using ASP and CGI but the database is not working on it. the code is running right, because it was tested. but once i upload it to the server, i cannot use the database, what do i need to do in ODBC. please help