This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / hi, I try to upload a sql server database to web server, today, when I running my script page, I got a error "Microsoft OLE DB Provider for ODBC Drivers error '80040e37'hi, I try to upload a sql server database to web server, today, when I running my script page, I got a error "Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'customers'. " anybody have an idea about it????Please help.....
-shinning(dudu);
2003-2-11
{307}
(#1034941@0)
-
go to microsoft.com, search the error number
-zxcvb(昏头昏脑);
2003-2-11
(#1034971@0)
-
I checked error code, it means "The specified table does not exist. The error string should contain the table name." but table does exist,,,,I checked error code, it means "The specified table does not exist. The error string should contain the table name." but table does exist,,,,so I think the connection to database maybe wrong or I need to set up permission or something??????anybody knows?
-shinning(dudu);
2003-2-11
{256}
(#1035009@0)
-
有几个可能的原因。1.spelling mistake. that object doesn't exist in the database at all.
2. the ID u try to connect with the db is not the db owner, meaning u have to use the full identifier
3. that ID doesn't have the permission to access to that object.
4. the incompatibility of MDAC between your web server and your database server.
-yangn(Raymond);
2003-2-11
{322}
(#1034994@0)
-
thank you, the userid I used is not db owner, do you know how to set up full identifier???????
-shinning(dudu);
2003-2-11
(#1035021@0)
-
usually, the identifier should be database_name.owner_name.object_name
-yangn(Raymond);
2003-2-11
(#1035033@0)
-
I don't understand, where to write this??????sorry :(
-shinning(dudu);
2003-2-11
(#1035038@0)
-
where? in your SQL statements which reference that object.
-yangn(Raymond);
2003-2-11
(#1035128@0)
-
do you know why it's working well on my computer, just doesn't work on web server????
-shinning(dudu);
2003-2-11
(#1035059@0)
-
this Q has been answered.
-yangn(Raymond);
2003-2-11
(#1035131@0)
-
It works on your machine because you logon as the owner of that table, ie. ABC. but when you sing on as somebody else, have to specifiy ABC.Customers. So always add owner in front of table name.
-smallguy(oops);
2003-2-11
(#1035116@0)
-
thank you for you reply, but I'm using specify table name "dbo.customers", still does not work....:-(anyway, thaanks a lot
-shinning(dudu);
2003-2-12
{21}
(#1036834@0)