Devart Forums

List Index Out of Bounds and i can't the stored procedure.

The stored procedure is in schema different to dbo but I have an synonym in dbo schema.

if I create the stored procedure in dbo schema, this fine work.
Help.
e work.

Please check if the problem exists when you specify the stored procedure schema directly.

i'm having the same issue here; once i try to use a stored proc within a different schema, it won't recognize it and also won't execute! it seems like there's some major problem with the "schema" property, for it'll never bring any accurate info about available schemas...

I could not reproduce the problem.
Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com. Also supply me the exact version of DbxSda and the exact version of your IDE.

Hi Dimon,

It's kind of hard for me (at least for me) to make a whole new project to show you this, but I'm sure that if I tell you my setup you'll easily find the problem the out...

Here's my current setup:

- Just downloaded the trial version of the driver;
- Delphi 2007 Professional (without updates or whatsoever);
- Connecting to SQL Server 2005 (SP3) via "sa" user (so it's a dbowner, default schema dbo);
- Created a new schema, called "Tasks";
- All my tables are within dbo schema;
- My new procedure's in Tasks schema;
- My connection's currently in dbo schema, but I want to (and I can) access Tasks.NewTask;
- TSQLStorecProc gets no parameters and, when trying to call the proc, it raises the exception;
- Create dbo.NewTask; everything's ok, parameters are set up and I can call it with no problem!

That's all! Basically, connect via dbo schema and try to access a other-schema stored proc. You should get the error! Hope you'll correct it soon, so that we can buy the license of a working dll! Any doubts, you can find me at henrique*ghnsolucoes dt com dt br

We have answered you by e-mail.

Dimon wrote:We have answered you by e-mail.

i do have the same problem connecting to MySQL server. can you please help me too?

Please describe the problem you encountered in more details. Also, if the problem is connected with dbExpress driver for MySQL, it will be better if you start a new topic in the corresponding forum here: http://www.devart.com/forums/viewforum.php?f=11