Why would I be getting a "Catastrophic failure" error?
Because the code you have causes an error that is Catastrophic.
DSN = "MyDSN"<BR><BR>sql = SELECT * FROM InvTable<BR>Set obj = Server.CreateObject("ADODB.Recordset")<BR>obj.open sql, DSN // <=== Error on this line
Put quotes around the SELECT * From InvTable for starters. Verify your DSN and its corresponding ODBC connection. Verify the account ID/Password that the ODBC uses.
you simply forgot the magic word...<BR><BR>(see your previous posts today...)
the IUSR that I set IIS to use didnt have access to the folder with the dta in it!<BR><BR>DUH!<BR><BR>hehehe
But I DOOOOO believe in magic!<BR><BR>I kept calling for Ronald .... but that big-shoed ******* never showed!<BR><BR>**** you Ronald!<BR>**** you to hell!
Just don't ask how I knew that one right off the bat...<BR><BR>(2 days shot to hell configuring, reconfiguring, re-reconfiguring my webserver and sql server....)