ODBC connection

<i><b>Originally posted by : Chong (c_huei_huei@hotmail.com)</b></i><br />I'd develop a Access97 database and going to publish it on web. I'd save it into ASP format. But I confused on what shall key in Data Source Name. However, I create an ODBC locally and use it. But after I publish it on my web server, this message show:<br /><br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br /><br />/test/Categories_1.asp, line 17 <br /><br /><br />Who had overcome this problem?? Please Help.<br /><br /><br />Rgds,<br />Chong<br />

<i><b>Originally posted by : erik</b></i><br />The odbc is on your local machine, try this:<br />(or use sql-server)<br /><br />strSQL="SELECT * FROM table"<br />set conn=server.createobject("ADODB.Connection")<br />conn.Provider="Microsoft.Jet.OLEDB.4.0"<br />conn.ConnectionString="Data Source=" & Server.MapPath(yourFilePath)<br />conn.Open <br />set rs=conn.execute(strSQL)<br /><br />etc<br /><br />------------<br />Chong at 2/27/2001 10:20:12 PM<br /><br />I'd develop a Access97 database and going to publish it on web. I'd save it into ASP format. But I confused on what shall key in Data Source Name. However, I create an ODBC locally and use it. But after I publish it on my web server, this message show:<br /><br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br /><br />/test/Categories_1.asp, line 17 <br /><br /><br />Who had overcome this problem?? Please Help.<br /><br /><br />Rgds,<br />Chong<br />