Prev: Expose event
Next: Newbie bBrowser 3
From: Jorge on 26 Nov 2009 11:19

Hello people

I want to use Sqllisttables from vo sql classes
No problem with MySql

I have problem with sqlserver

After a successfull conection with sqlserver 2008
sqllisttables { , , , , oSQLconn } no execute,
and shows;

EXECUTE NativeError 0 Sqlstate 24000
Sql server native client 10.0 Invalid cursor state

Anybody can help me to use sqllisttables with sqlserver ?

Thanks in advance
Jorge accinelli

From: Geoff Schaller on 27 Nov 2009 05:04
What is your connection string?
Try using the OLDEB client instead.

"Jorge" <jorgeaccinelli(a)dextrasistemas.com.ar> wrote in message
news:29760ccb-623e-4297-94c7-feacec46dd22(a)a21g2000yqc.googlegroups.com:

> Hello people
>
> I want to use Sqllisttables from vo sql classes
> No problem with MySql
>
> I have problem with sqlserver
>
> After a successfull conection with sqlserver 2008
> sqllisttables { , , , , oSQLconn } no execute,
> and shows;
>
> EXECUTE NativeError 0 Sqlstate 24000
> Sql server native client 10.0 Invalid cursor state
>
> Anybody can help me to use sqllisttables with sqlserver ?
>
> Thanks in advance
> Jorge accinelli

From: Jorge on 27 Nov 2009 06:58
On 27 nov, 07:04, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au>
wrote:
> What is your connection string?
> Try using the OLDEB client instead.
>
> "Jorge" <jorgeaccine...(a)dextrasistemas.com.ar> wrote in message
>
> news:29760ccb-623e-4297-94c7-feacec46dd22(a)a21g2000yqc.googlegroups.com:
>
>
>
> > Hello people
>
> >    I want to use Sqllisttables from vo sql classes
> >    No problem with MySql
>
> >   I have problem with sqlserver
>
> >    After a successfull conection with sqlserver 2008
> >    sqllisttables  { , , , , oSQLconn }  no execute,
> >    and shows;
>
> >             EXECUTE NativeError 0   Sqlstate 24000
> >             Sql server native client 10.0  Invalid cursor state
>
> >    Anybody can help me to use sqllisttables with sqlserver ?
>
> > Thanks in advance
> > Jorge accinelli- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -

Thanks for the answer , I have
used sp_tables, with a select, to solve the
problem and obtain the information i needed

Jorge


 | 
Pages: 1
Prev: Expose event
Next: Newbie bBrowser 3