sql server connect: 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 =
DataBASE;UID=USER;PWD=PASSWORD;Trusted_Connection=yes"

What changes did u make to the connection string? Also, you might want to
first test this new connection string and if it works by using a UDL file.

Cheers,

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.