Re: SQL Invalid Object...

Sounds like the table simply doesn't exist on the live server. Is your
production server and development server using the SAME SQL Server db or two
different versions? Can your local (production) web site successfully
connect to the SQL Server and can the live web site as well?




"3D Peruna" <w!h#a$r%o^l&d@w!e#i$r%d&n*e(s)s.com> wrote

I ran the Upsizing wizard to convert an Access file to a SQL file.
Everything worked fine before. I changed my connection string and now I
get:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'tbl_MRSongs'.
/impulse/impulse_MR.asp, line 77

For the record, the connection works fine in Live Data in DW.

Here's the offending code:

%
var rs_MRSong = Server.CreateObject("ADODB.Recordset");
rs_MRSong.ActiveConnection = MM_con_MR_STRING;
rs_MRSong.Source = "SELECT * FROM tbl_MRSongs WHERE ID_Song = "+
rs_MRSong__MMColParam.replace(/'/g, "''") + "";
rs_MRSong.CursorType = 0;
rs_MRSong.CursorLocation = 2;
rs_MRSong.LockType = 1;
rs_MRSong.Open(); <--- This is line 77
var rs_MRSong_numRows = 0;
%

Here's the connection string:

var MM_con_MR_STRING = "Provider=MSDASQL;Driver={SQL
Server};Server=(local);Database =
MR_ImpulseSQL;UID=USER;PWD=PASSWORD;Trusted_Connec tion=yes"