ASP '80004005' Data source name not found and no default driver specified

<i><b>Originally posted by : Brett (bbailey@elliseverard.com)</b></i><br />Working with a server that has IIS4, and MSDE (SQL 7 eqivalent (almost)) running on NT4. I have been unable to connect to the database. I've created a DSN without any luck. I tried DNS-less entries in the asp code. My most recent coding attempt is below but I've tried this atleast 50 different way. Any assistance would be unbelivably appreciated. I keep thinking that maybe it has something to do with security, but I'm not sure. I'm using windows NT authentication for the DSN with a server name of (local) for the MSDE server.<br /><br />dim conn<br />dim strconn<br />dim strsql<br />strsql = ""<br /><br />set conn = server.createobject("adodb.connection")<br />conn.open "asset" <br /><br /><br /><br />strSQL = "INSERT INTO details(OrderID, Item, Quantity)"<br />strSQL = strSQL & " SELECT "<br />strSQL = strSQL & "'" & request("OrderID") & "' as OrderID," <br />strSQL = strSQL & "'" & request("LastName") & "' as Item,"<br />strSQL = strSQL & "'" & request("FavoriteColor") & "' as Quantity"<br /><br />conn.execute(strSQL)<br />conn.close<br />set conn = nothing<br /><br /><br />Thanks!

<i><b>Originally posted by : Adrian Crooks (Bandit_109@hotmail.com)</b></i><br />try using "DSN=asset;UID=;PWD=" and don't forget to insert the user id and password. Also, when you set up the odbc "system" dsn, remember to click on the test connection button to verify the connection.<br /><br /><br />------------<br />Brett at 6/5/2000 1:49:38 PM<br /><br />Working with a server that has IIS4, and MSDE (SQL 7 eqivalent (almost)) running on NT4. I have been unable to connect to the database. I've created a DSN without any luck. I tried DNS-less entries in the asp code. My most recent coding attempt is below but I've tried this atleast 50 different way. Any assistance would be unbelivably appreciated. I keep thinking that maybe it has something to do with security, but I'm not sure. I'm using windows NT authentication for the DSN with a server name of (local) for the MSDE server.<br /><br />dim conn<br />dim strconn<br />dim strsql<br />strsql = ""<br /><br />set conn = server.createobject("adodb.connection")<br />conn.open "asset" <br /><br /><br /><br />strSQL = "INSERT INTO details(OrderID, Item, Quantity)"<br />strSQL = strSQL & " SELECT "<br />strSQL = strSQL & "'" & request("OrderID") & "' as OrderID," <br />strSQL = strSQL & "'" & request("LastName") & "' as Item,"<br />strSQL = strSQL & "'" & request("FavoriteColor") & "' as Quantity"<br /><br />conn.execute(strSQL)<br />conn.close<br />set conn = nothing<br /><br /><br />Thanks!