What happened IIS used to have no problem with this ASP

[other3]

// open connection to the database

objConn = Server.CreateObject("ADODB.Connection"
objConn.ConnectionString = "DSN=pb";

objConn.Open();

// create a recordset object

datePublished = this.month + this.year;

objRS = Server.CreateObject("ADODB.Recordset"
strSQL = "SELECT * FROM Magazine WHERE DatePublished = '" + datePublished + "'";
objRS.Open(strSQL, objConn);

this.datePublished = objRS("DatePublished&quot.value;
this.yearPublished = objRS("YearPublished&quot.value;
this.MonthPublished = objRS("MonthPublished&quot.value;
this.Volume = objRS("Volume&quot.value;
this.editionNumber = objRS("EditionNumber&quot.value;
this.cover = objRS("Cover&quot.value;
this.condition = objRS("Condition&quot.value;
this.miscellanous = objRS("Miscellanous&quot.value;
this.personOnCover = objRS("PersonOnCover&quot.value;
this.needsReplaced = objRS("NeedsReplaced&quot.value;

This is the error IE is giving me.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/currentMag.asp, line 56

Line 56 is objConn.Open();


Then I had a crash of sorts and had to reinstall Win2K and IIS. All of my other programs, one in Visual C++ and one in Java have no trouble at all with the DSN

 

[vercesi]

That error ussually occurs when IIS/ODBC/ADO engine doesn't find the database. Check your DSN configuration.

/*Ricardo Vercesi - Web Development*/
<!--

http://www.1000olhares.com

-->
<!--

http://www.simetrias.net

-->