I have a report that uses a stored procedure on a SQL server source. I
change the Logon Info at runtime from my VB code to try and connect to the
desired database at run-time. Unfortunately crystal always connects to the
database used in the designer inspite of setting the logon info. In the
report I have got rid of the database prefix and retained just the stored
procedure name for Database Location.

I'm also having trubble with this. The code below seems to work if (in
my case a big if) you use a report created in the RDC-designer. If you
got a .rpt file (change first row in code-example)   it doesn't seem
to work.

Is there something I'm missing here?

////////////////////////////
 'Set CRReport = CRapp.OpenReport(REPORT_PATH & "\Notes.rpt", 1)
    Set CRReport = New CR_Notes

    Set crxDatabase = CRReport.Database
    Set crxdatabaseTables = crxDatabase.Tables

    For Each crxdatabaseTable In crxdatabaseTables
        strServer = "ServerName"
        strDataBase = "DB"
        strUserName = "sa"
        strPassWord = ""

        Call crxdatabaseTable.SetLogOnInfo(strDSN, strDataBase,
strUserName, strPassWord)
        strLocation =
"Database.dbo.Proc(sp_GetInformationRowReport;1)"
        Call crxdatabaseTable.SetTableLocation(strLocation, "", "")
    Next

///////////////////////