Re: Catastrophic failure

From: <tlc23810_at_my-deja.com>
Date: Mon, 04 Oct 1999 14:52:50 GMT
Message-ID: <7taevq$3f6$1@nnrp1.deja.com>

I moved the BHBSS site back to the d drive and am now receiving the error:
Provider error '8000ffff'
Catastrophic failure
/bhbbs2/itstore/testdb.asp, line 11
This of course is the ODBC connect line.

<%
UsrName = Request.ServerVariables("LOGON_USER") if UsrName="" then

        response.status="401 access denied."
end if

UsrName = Ucase(mid(usrname,12,8))
'UsrName = "CUIJEN"

set conn = Server.CreateObject("ADODB.Connection") conn.open "dsn","name","pass"
sql = "SELECT CONTACT_NAME,FLX_CON_VCHR1 AS DIV FROM EXAV.CONTACTS WHERE FLX_CON_VCHR3='" & UsrName & "'"

'##sql = "SELECT NNAME,LNAME,EMP_Division FROM DIR WHERE LOGNAME='" & UsrName & "'"
Response.Write (sql)
set rs = conn.execute(sql)

if rs.bof and rs.eof then

        response.write "<br><br><br><p
align=""center""><strong><big>You are not in the Tivoli database.</big></strong></p>"

        Response.write "<p align=""center""><strong><big>Please contact Solution Center @ </big></strong></p>"
else

	fullname = rs("CONTACT_NAME")
	div = UCASE(rs(1))
	end if

%>

I am running the script on NT4/ IIS 4 with Oracle 8

Hope this helps you help me : )

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 09:52:50 CDT