Error when Inserting Record with GoDaddy Hosting

[MBaith-XyRqIV]

When I try to insert a record on a webpage hosted by GoDaddy to a SQL server I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_execute', database 'master', owner 'dbo'.

This error occurs on the line:

MM_editCmd.Prepared = true

After some searching online if I change the line as follows the error goes away, but so does the insert record behavior:

MM_editCmd.Prepared = false

Is it possible to change the behavior so it will always use false instead of true and still show up as a behavior on the page.

This is happening in Dreamweaver 8.0.2. It didn't happen in Dreamweaver MX 2004.

Thanks,
Mike

[MBaith-XyRqIV]

I started looking at the behavior a little closer.

I want to use this method:
C:\Program Files\Macromedia\Dreamweaver 8\Configuration\ServerBehaviors\ASP_Vbs\insertRecord_query.edml

I don't want to use this method: (Causes the error)
C:\Program Files\Macromedia\Dreamweaver 8\Configuration\ServerBehaviors\ASP_Vbs\insertRecord_query2.edml

Anyone know how it chooses which to use?

[Newsgroup_User]

MBaith wrote:

> When I try to insert a record on a webpage hosted by GoDaddy to a SQL
> server I get the error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission
> denied on object 'sp_execute', database 'master', owner 'dbo'.
>

Try dropping the dbo. from your query.

[MBaith-XyRqIV]

I don't see dbo in the query...

I tried this on another computer with Dreamweaver 8 installed and this is very strange.

[Newsgroup_User]

The second method is like I see with my DW8.02. Can you export the
working extension from your other computer and install that extension?
Perhaps the inert extension got overwritten from an extension you
download?

I have no other ideas.

[MBaith-XyRqIV]

I tried copying the contents of the folder C:\Program Files\Macromedia\Dreamweaver 8\Configuration\ServerBehaviors\ASP_Vbs from the "good" computer to the "bad" computer, but when I try to add the insert record behavior I get the error:

Server behavior was not applied. Cound not find a valid XML file that refers to the current server behavior and the current server model.

Is there another way to export/import the behaviors from one computer to another?

Any ideas?

[MBaith-XyRqIV · Accepted solution]

After much tinkering I tried a test with a new table and web page. Dreamweaver added the insert code as before-the same code that would cause the error. I tried the test and it worked. No error?

The only difference I could think of was that the origional table was created on a local SQL server and then I used Generate SQL Script to get the create table statment, which I then ran in Query Analyzer on GoDaddy's SQL server.

I then deleted the table and created it through GoDaddy's user interface and now it works. I'm not sure what the difference is, but at least it's working.

Thanks.

[Newsgroup_User]

In working with mssql I found ownership (like dbo) can create lots of
problems. That you found a way to get it to work is most important. I
will be using godaddy for a project soon and will keep this all in
mind. I have been using fluid hosting with enterprise manager/query
analyzer ,on my local machine, to manage the site db with good success.
The biggest problem there was it creates an owner different than what
you create on the lcoal machine so I have removed the ownship portion
from all of my code.