Oracle 8i Lite ASP Requires Alias

From: <sgornick_at_my-deja.com>
Date: Thu, 25 Nov 1999 05:53:45 GMT
Message-ID: <81iit9$1n6$1@nnrp1.deja.com>

I just installed Personal Oracle 8i Lite v4.0 on an NT v4.0 w/SP5 installed, and am experiencing a problem.

I create a user TESTUSR and a table TESTTBL, and when I log in with user TESTUSR in SQL*Plus, the following will work just fine.
SELECT * FROM TESTTBL
but then when my ASP on IIS does the same SELECT, it will report "[POL-5130] table or view not found".

But if I use a schema alias, i.e., change line 10 of the .ASP shown below to read: objCmd.CommandText = "SELECT * FROM TESTUSR.TESTTBL" it will work fine. 8i Lite documentation says when user logs in, objects in his own schema don't need to be referenced with the alias.

ODBC Admin shows: "Oracle Lite 40 ODBC Driver 3.00.00.00".

What gives? Is this a 8i Newbie error, or is this a bug I should report?

Thanks in advance.

File testprob.asp follows:

<%
Set objConn = Server.CreateObject("adodb.connection") Set objCmd = Server.CreateObject("adodb.command")

objConn.Open "DSN=TESTPOL", TESTUSR, TESTPWD

Set objCmd.ActiveConnection = objConn

objCmd.CommandText = "SELECT * FROM TESTTBL" objCmd.CommandType = adCmdText

objCmd.Execute

  Set objCmd = Nothing
  objConn.Close
  Set objConn = Nothing
%>

<HTML>
<BODY>
  No problems found ...
</BODY>
</HTML>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 23:53:45 CST

Oracle 8i Lite ASP Requires Alias - Why?