Error

[ChrisBrown]

I'm getting an error - went to the line in the code and it looks like an ok object to me - so I'm perplexed...

Anyone have an idea to spur me along?

Error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Shelby.vw_MBMstOrg'.
/Shelby/Shelbycnxn.asp, line 23

Code refererenced:
Set CNX = Server.CreateObject("ADODB.Connection")
strCNX = "driver={SQL Server};server=" & SQL_Server_Name & ";Initial Catalog=ShelbyDB;User ID=ShelbyREAD;Password="
CNX.Open strCNX
Set objRST = Server.CreateObject("ADODB.RecordSet")
objRST.Open strSQL, CNX
If strSQLPhoneList <> "" Then
Set RstPhones = Server.CreateObject("ADODB.RecordSet")
RstPhones.Open strSQLPhoneList, CNX
End If

[TheBearMay]

I'm guessing that Shelby.vw_MBMstOrg is a column in one of your tables and may be incorrectly referenced in your SQL statement.

[Bullschmidt]

Perhaps check this out:

http://www.aspfaq.com/search.asp?q=0x80040E37&type=ALL&category=0&numDays=0&order=1

[ChrisBrown]

Thanks for the help. We narrowed it down to suspecting that this code we're integrating was originally developed with a version of the database that was developed with SQL 2000 - and right now the DB we have is on SQL 7 - an older version and we suspect a difference in the tables and their structure. So yea, it seems DB related.