Connection Error
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'GS_UX_RTN'.
/decoe/decoe.asp, line 21
The script is as below-
<%@ Language=VBScript%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=xxxx;uid=xxxx;pwd=xxxxxx"
strSQL = "SELECT GS_UX_RTN.RTN_NUMBER FROM GS_UX_RTN WHERE GS_UX_RTN.RTN_NUMBER
= '101990'"
Set objRs = objConn.Execute (strSQL) 'adCmdText
%>
RTN<br>
<%Do Until objRs.EOF
Response.Write(objRs.Fields("RTN_NUMBER") & "<br>")
objRs.MoveNext
Loop
objRs.Close
Set objRs = Nothing
objConn.Close
Set objConn = Nothing
%>
</BODY>
</HTML>
This script was tested on another web server and it's working but not on
the web server that I'm working on.
Please response asap
[1177 byte] By [Chat Hoo] at [2007-11-9 15:36:07] 