microsoft.public.cert.exam.mcsd - Universe data access through ODBC

Author

Universe data access through ODBC

rasikasw

2003-07-22, 2:14 am

Hi all,
I am trying to access universe data from though the VB (VIA ODBC). when I was executing following sql though VB
{NATIVE "select * from test;" }
it gives the error message no table exists.
But I can get the output from the universe prompt by typing the above sql.

What is the reason for above error.
regards
Rasika

Sergey Krutous

2003-07-22, 3:23 am

Try to remove semicolon from the query.

"rasikasw" <rasikasw.qyiwc@mail.examnotes.net> wrote in message
news:rasikasw.qyiwc@mail.examnotes.net...
>
> Hi all,
> I am trying to access universe data from though the VB (VIA ODBC). when
> I was executing following sql though VB
> {NATIVE "select * from test;" }
> it gives the error message no table exists.
> But I can get the output from the universe prompt by typing the above
> sql.
>
> What is the reason for above error.
> regards
> Rasika
>
> ---
> Sign up to get free daily practice questions at:
http://www.QoD.US/i-54.htm
> View this thread: http://www.examnotes.net/article1017014.html
>
rasikasw--------------------------------------------------------------------
----
> rasikasw's Profile:
http://www.examnotes.net/forums/mem...o&userid=144016
>

Sponsored Links