January 14, 2002 at 6:48 am
Hi there,
Let me prefrence this with ..."I'm a total SQL novice." However, I've had excellent help from a power user. But I (we) are stuck now with a problem of existing tables not being found on the remote server. Here's the senario.
The ISP has two machines. Both of which we are on a shared platform with other customers. The SQL DB is on an NT box and the web site is on Win2K box. I'm able to make a connection as the error message says this....
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'tblPageHome'.
But when I use Enterprise Manager the tables are all there. Plus...if I do a response.write command to display the connection string, with server, DB, login, password info..it is all correct. Have ever encounter such a thing? Where would you start trying to fix something that doesn't seem to be broken?
January 14, 2002 at 7:52 am
I know you specified a database, but it almost sounds like it's not at the correct one. The sysobjects table is in every database. Try and execute the query:
SELECT name FROM sysobjects WHERE type = 'U'
and see if your web server gets back the list of user tables you expect.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply