Skip to main content
M
MBaith-XyRqIV
Inspiring
February 14, 2007
Answered

Error when Inserting Record with GoDaddy Hosting

  • February 14, 2007
  • 4 replies
  • 815 views
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
This topic has been closed for replies.
Correct answer MBaith-XyRqIV
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.

4 replies

N
Newsgroup_User
Inspiring
February 15, 2007
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.

M
MBaith-XyRqIVAuthorCorrect answer
Inspiring
February 15, 2007
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.
N
Newsgroup_User
Inspiring
February 14, 2007
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.
M
MBaith-XyRqIVAuthor
Inspiring
February 14, 2007
I don't see dbo in the query...

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

M
MBaith-XyRqIVAuthor
Inspiring
February 14, 2007
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?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices