Xref: alice comp.databases.oracle:74521 comp.databases.oracle.misc:30571 comp.databases.oracle.server:48339 comp.databases.oracle.tools:24378 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: CC Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Serious problems with IIS,ADO and Oracle.... Date: Wed, 05 May 1999 18:42:20 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 36 Message-ID: <7gq3ea$sa$1@nnrp1.deja.com> References: <37306705.FF4FEEBA@enator.se> X-Article-Creation-Date: Wed May 05 18:42:20 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.1 x2.dejanews.com:80 (Squid/1.1.22) for client 162.114.165.171 I don't know if your doing this or not but when you create your table are you granting permisson on it for the person to do select? In article <37306705.FF4FEEBA@enator.se>, stefan auer wrote: > Hi! > > I'm getting more and more desperate. We're trying to use Oracle > as a DB from an Internet application where during a certain > event a temporary table gets created and filled with data. > > The BIG problem is that we can create, insert and drop the table > but we can't use SELECT! > > We are using the IIS 4.0 as a webserver. In a certain ASP script > (javascript or vbscript doesn't matter) we create a ADO object > and connect to the Oracle 8.0.5 database. There we create the table > and inserts the data. Everything is fine. We can, using SQL*Plus, > see the table in the database. > > In another ASP script we creates a ADO connection and tries to > use SELECT on the table. This always returns EOF that is no records > found. This only happens when we tries to select from a table that > contains a column type other then VARCHAR2. In any other case it works. > > So you say:"JUST USE VARCHAR2!!!" but that is not sufficient. > > If anyone got any hint, idea, code or link PLEASE SEND IT TO US!!! > > Thanks in advance... > > /Micke(through Stefan!) > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own