Re: ODBC Problem with ORA-01013 Error

Well the view is a good idea but in this datawarehouse we can't define views for every SQL Statement a user will probably thinks of.

This Query is just a simple thing which I think should work for this setup. We have around 1000 physical tables and defining a view for every field with a groug by is quite impossible.

But thanks for your response.

Kind Regards Roland

"MJEvans" <mjevansNOmjSPAM_at_bigfoot.com.invalid> schrieb im Newsbeitrag news:155ccc6c.025db31c_at_usw-ex0106-048.remarq.com...
> Roland and Kurt,
>
> Rather than setting the TIMEOUT to zero, I would think it would be
> better to let the server do the work. Create a view of your select
> statement on the server. Then use Access to select from the view.
>
> HTH
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Jan 27 2000 - 17:16:53 CST