Active Reports and SQL: cannot find stored procedure

[GolphknutInChains]

A simple VB project, with a couple of stored proc hits...

this one works fine:

objCNN.ConnectionString = "DSN=MyCNNString"
objCNN.Open
If objRS.State = adStateOpen Then objRS.Close
objCNN.sp_Tefra_GetARConstants_New 1, objRS

10 lines later, this one does not:
Dim arTefra As New arTefraGenLetters
...
...
...
arTefra.dcData.Source = "sp_Tefra_GetDataForAR " & CStr(iYearOf) & ", " & CStr(lngSSN) & ", " & CStr(iUpdatePrintDate) & ", '" & CStr(sPrintDate) & "' "
arTefra.Run False
arTefra.Export arExp

The Err Msg I get (on arTefra.Export arExp):

Error 5000 : Error in processing report.
[ Extended Info:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sp_Tefra_GetDataForAR'.]

and then:

Run-time error '-2147352567 (80020009)'
Method 'Export of object '_arTefraGenLetters' failed

DETAILS: At one time, it was finding the stored proc in ANOTHER DATABASE on the same server... I renamed the stored proc there to another name, and then started getting the "cannot find stored proc". ODBC DSN settings on my machine have been repeatedly double checked, the stored proc IS THERE on the new database (I even deleted and re-created it...) I've destroyed and re-created the ODBC settings on my machine, rebooted, refreshed databases, have even sacrificed eight users to the digi-gods... all to no avail...

It's as if the AR component is trying to connect to the OLD database, while the VB sp_ hit (the first one) finds the NEW database...

At a loss, looking for help suggestions any ray of hope...

Many thanks!

 

[GolphknutInChains]

found it... anther dsn setting in the properties of the datacontrol... who'd have thought!!!