Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 2nd, 2005, 12:54 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default error '80040e09'

hello all
i've written asp pages with sql server database and i upload my files to internet(i got a host).i recieve error below in my pages:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'UserList', database 'host064', owner 'dbo'.

/login.asp, line 21
and when i want to open my data base that has uploaded to host server with interprise manager i can't open any table it gives me an error like the error that i wrote it above.would some one help me to fix the problem.
thank you

  #2 (permalink)  
Old August 2nd, 2005, 01:52 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi hastikeyvan,

Didn't we do all this here: http://p2p.wrox.com/topic.asp?TOPIC_ID=33110 ??

What did your host say??

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: from the edge of the deep green sea by The Cure (Track 4 from the album: Wish) What's This?
  #3 (permalink)  
Old August 2nd, 2005, 10:48 PM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

My host didn't check it.because the host datarebase responsible is working there parttime.and didn't go there these days.can't i fix it my self?can i delete the database and upload it again???

  #4 (permalink)  
Old August 3rd, 2005, 01:25 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I don't think so, unless the you have the password of the SA or another Admin account.

Security in general would be a bit pointless if you could just grant yourself the necessary rights to an arbitrary database, don't you think?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #5 (permalink)  
Old August 3rd, 2005, 10:34 PM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

thank you for your help.my host fix the problem and it is working now.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Query Error & Run-Time Error 3022 DavidWE Access 1 July 31st, 2008 11:17 AM
Ch 4: Parse error: syntax error, unexpected T_SL hanizar77 BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 23rd, 2008 09:17 PM
Microsoft JET Database Engine error '80040e09' phuc2583 Classic ASP Basics 1 February 28th, 2008 06:45 PM
error '80040e09' hastikeyvan SQL Server 2000 1 August 2nd, 2005 01:53 PM
error '80040e09' Adam H-W SQL Server 2000 5 November 7th, 2003 12:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.