pointing to wrong db - but the connection is correct

[specialist]

greetings-

I am trying to define a DSN-less database connection with a connection string but appear to be getting a different database with a similar name. I check the string and everything looks fine (string below). It is pointing the the correct DB, but displaying info and contents from another DB.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_DB_ONE_STRING
MM_OPINTEL_MLCPAC_STRING = "Provider=SQLOLEDB;Data Source=correctSource;"&_"Database=correctDB;User ID=myID;Password=myPW"
%>


has anyone else had this issue? any suggestions on a solution?

many thanks in advance!

michael

 

[specialist]

scratch the post, I removed the "&_" from the string!