Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft SQL Server
Reload this Page

Invalid object name 'dbo.Products'

Discuss Invalid object name 'dbo.Products' in the Microsoft SQL Server forum on ASP Free.
Invalid object name 'dbo.Products' Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old February 10th, 2005, 01:46 PM
hinch hinch is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 26 hinch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 22 m 45 sec
Reputation Power: 0
Invalid object name 'dbo.Products'




i have an error with my shop system, i get this when i try to update a product:



Microsoft OLE DB Provider for ODBC Driverserror '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Products'. /manager/shop_products_edit.asp, line 159

i did not create this shop, and don;t want to knacker it. anyone know what causes this problem and how i might be able to go about correcting it?

cheers, hinch
Reply With Quote
  #2  
Old February 10th, 2005, 01:50 PM
A2k's Avatar
A2k A2k is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2004
Posts: 166 A2k User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 18 h 44 m 10 sec
Reputation Power: 4
sounds like a table is missing.

Or you could be trying to access another database with the wrong syntax.

In order to be able to fix the error you should post the SQL statement that creats that error.
Reply With Quote
  #3  
Old February 10th, 2005, 04:06 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 23 h 19 m 36 sec
Reputation Power: 181
Are you using a sql login that has the dbo role?
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #4  
Old February 10th, 2005, 08:03 PM
hinch hinch is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 26 hinch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 22 m 45 sec
Reputation Power: 0
no i'm not using the dbo login...
Reply With Quote
  #5  
Old February 13th, 2005, 09:42 PM
Tonny-Soeroso Tonny-Soeroso is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jun 2004
Posts: 36 Tonny-Soeroso User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 h 56 m 27 sec
Reputation Power: 0
Smile
Check your systables.

use yourDb
go
Select * from sysobjects where name = 'Products' and xtype = 'u'
go

if that query return 1 row, it means the table is exists in your db. and the problem is on your SqlSvr Login.


Rgds,

Tonny Soeroso
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Invalid object name 'dbo.Products'

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway. 
Stay green...Green IT