Re: Oracle and ASP

One thing you may want to look into:

Are you using the same user name/password in the ASP as the SQL Prompt.

It may be a synonym problem or user priv problem.

And, as simple as it sounds, make sure your connection string in the ASP is pointing to the right db and SID (I bet more than a few have slapped their forehead red when they've finally realized Test Backup hasn't been updated to production).

Otherwise, post the statement; perhaps there is an error.

"Jacob" <Jay_at_cob.com> wrote in message
news:3ac91734_6_at_news.uncensored-news.com...
> Something wierd is happening. When I execute an SQL statement in the
 Oracle
> console of SQL+, I get data as a result. OK, fine, but if I shove that
 same
> SQL statement in my asp page to populate a recordset, I get nothing. And
 it
> only occurs with one particular table. Any other table, I'm getting
 results
> in my asp page. But with this one particular table, I get nothing. But if
 I
> were to execute the same SQL statement in the SQL+ console, I get data.
> Wierd. Any suggestions?
>
>
>
>
> ______________________________________________________________________
> Posted Via Uncensored-News.Com - Still Only $9.95 -
 http://www.uncensored-news.com
> With Seven Servers In California And Texas - The Worlds Uncensored News
 Source
>
Received on Mon Apr 02 2001 - 23:04:27 CDT