Delphi 7 En + dbExpress + SQLServer 2000 + StoredProc = List index out of bounds (0)

[Nelson Nepomuceno]

Hi,

I am using Delphi 7 Enterprise, MS-SQLServer 2000 sp 3, dbExpress with
driver dbexpmss.dll (updated!).
I am trying to execute a stored procedure with params using TSQLDataSet. I
have some problems:

1 - I have selected these properties:
SQLConnection := SQLConnection1
CommandType := ctStoredProcedure

But when I try navigate to CommandText property, it does not show my stored
procedures.

2 - If I try fill CommandText with my StoredProcedure name, it doesn't fetch
parameters.

3 - If I fill parameters manually and try execute TSQLDataSet, I receive
this message "List index out of bounds (0)".

4 - If I try compile and execute running aplication, the same error occurs.

4 - The same problems occurs when I try these operations using TStoredProc.

What's wrong?

Thank you in advance.

Nelson
nel...@datagricolae.com.br

[Ramesh Theivendran]

Check if the SchemaName property is set to the Owner of the SP.

T.Ramesh.

"Nelson Nepomuceno" <nel...@datagricolae.com.br> wrote in message
news:3ea8...@newsgroups.borland.com...

[Nelson Nepomuceno]

Thanks Ramesh!
You solved my problem!

Nelson :)

----- Original Message -----
From: "Ramesh Theivendran" <rtheiv...@borland.com>
Newsgroups: borland.public.delphi.database.dbexpress
Sent: Friday, April 25, 2003 12:53 AM
Subject: Re: Delphi 7 En + dbExpress + SQLServer 2000 + StoredProc = List
index out of bounds (0)

> Check if the SchemaName property is set to the Owner of the SP.
>
> T.Ramesh.

"Ramesh Theivendran" <rtheiv...@borland.com> escreveu na mensagem
news:3ea8b0b4$1...@newsgroups.borland.com...