DbExpress Error in Delphi 7 with SQL Server TStoredProcedure

jcasmu · Post by **jcasmu** » Fri 13 Mar 2009 16:43

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.

Dimon · Post by **Dimon** » Mon 23 Mar 2009 12:16

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

ghn.henrique · Post by **ghn.henrique** » Fri 27 Mar 2009 01:44

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...

Dimon · Post by **Dimon** » Fri 27 Mar 2009 07:38

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.

ghn.henrique · Post by **ghn.henrique** » Wed 01 Apr 2009 01:32

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

Dimon · Post by **Dimon** » Thu 02 Apr 2009 06:42

We have answered you by e-mail.

amirhadibi · Post by **amirhadibi** » Wed 20 Jul 2011 19:06

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?

AndreyZ · Post by **AndreyZ** » Thu 21 Jul 2011 11:37

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