Can't connet to stored procedure

Report · Jun 13, 2008

Hi,

Im using DW CS3, MSSQL Server Manager 2005, .asp

First time using stored procedures and Im having some issues.

I created the stored procedure on the sql server, and applied Execute permission to the dbo schema.

I modified my SQL connection in DW to use the dbo schema.

In the Bindings panel, i create a new command. In the Stored Procedure list being called from the database, it shows, I select it, the variables are popluated. also checked return recordset with a name.

However, when I click Test -- DW is having problems loading the database schema, and then eventually times out.

Is there a setting in DW or part of my connection string or permissions on the db that Im missing here?

Thanks!

Report · Jun 13, 2008

fmeenz wrote:
> Hi,
>
> Im using DW CS3, MSSQL Server Manager 2005, .asp
>
> First time using stored procedures and Im having some issues.
>
> I created the stored procedure on the sql server, and applied Execute
> permission to the dbo schema.
>
> I modified my SQL connection in DW to use the dbo schema.
>
> In the Bindings panel, i create a new command. In the Stored Procedure list
> being called from the database, it shows, I select it, the variables are
> popluated. also checked return recordset with a name.
>
> However, when I click Test -- DW is having problems loading the database
> schema, and then eventually times out.
>
> Is there a setting in DW or part of my connection string or permissions on the
> db that Im missing here?
>
> Thanks!
>

You are going to have problems using Stored Procedures and Dreamweaver,
its buggy at best, but you can get them to work. The first thing is not
to use the Command, use a Recordset instead. You may find it only lets
you enter one parameter, if you do, save the recordset and go back in,
you will then be able to enter more.

Make sure the user that use in the connection string has Execute
permissions on the stored procedure. I always create a new user with
very limited security rights, and then issue right permissions to the
user for each object it needs access to as I create them. That way your
nice and secure, well, as secure as can be.

Good luck!

Steve

Report · Jun 13, 2008

Steve --

thanks for getting back to me. I tried your procedure and it works. Such a drag that the regular command insert doesnt work. It would be helpful if the people writing the help files would tell you these things rather than post instructions that arent going to work, right? :)

best -
eric

Report · Jun 13, 2008

fmeenz wrote:
> Steve --
>
> thanks for getting back to me. I tried your procedure and it works. Such a
> drag that the regular command insert doesnt work. It would be helpful if the
> people writing the help files would tell you these things rather than post
> instructions that arent going to work, right? :)

Hi Eric,
What you could do is report it as a bug to Adobe, as the more people who
complain about it, the more likely it is to get fixed. I have tried the
CS4 BETA and its not been fixed 😞 which is very sad, so to get this
fixed everyone who is effected by this bug must complain, and get it
recognised as being a problem.

In web application development Stored Procedures are the best way to
work, yet Dreamweaver falls over at the mere sight of them. Very strange!

Steve