CR 10 LogonServer failure using RDC - Recent upgrade CR 8.5 2

[pc66]

Recently purchased Crystal Reports 10 Professional.
Installed on PC with Windows 2000 Professional and MS Office 2000

Using Crystal to report on a Lotus Notes Database.

We have a scheduler that was built using MS Access and works fine to schedule and run reports on the PC which Crystal 8.5 is installed, but when we try to run on the PC with Crystal 10, receive the message "Logon failed.
Details: 28000:[Lotus][ODBC Lotus Notes]Invalid authorization specification"

The references have been updated as per

http://support.businessobjects.com/library/kbase/articles/c2015230.asp

Problem appears to be at the line crxApp.LogOnServer "pdsodbc.DLL", mLogonServer, mLogonDB, mlogonUserID, mPwd
********************************
Private Sub runBatch()

On Error GoTo ErrorHandler

Dim crxApp As New CRAXDRT.Application
Dim Rpt As New CRAXDRT.Report
Dim subrpt As CRAXDRT.Report
Dim rptObject As Object
Dim sect As CRAXDRT.section
Dim promptUser As Boolean
Dim prmDefs As CRAXDRT.ParameterFieldDefinitions
Dim prmDef As CRAXDRT.ParameterFieldDefinition
Dim prmField As New CRAXDRT.ParameterValue
Dim mRecs As Integer
Dim mReportName As String
Dim mFormat As String
Dim mpath As String
Dim mStartDate As Date
Dim mEndDate As Date
Dim mAsAtDate As Date
Dim mStyle As String
Dim mPwd As String

mPwd = getpassword()
'mlogonUserID = WhoIsSignedOn()
crxApp.LogOnServer "pdsodbc.DLL", mLogonServer, mLogonDB, mlogonUserID, mPwd

*****************************************************

As we only have the 1 working copy of CR 8.5, we wish to update the batch process so that it will run on any of the CR10 installed PCs.

Any help is appreciated, although not critical the scheduler enables us have reports available each morning.
Scheduler was built in house, but the person who built is no longer with the company.

We would also look at purchasing a scheduler that would do the job if it will meet the basic requirements. So any recommendations to Schedulers for CR10 that we can trial and purchase would help.

Thanks

Paul

 

[vidru]

pdsodbc.dll is no longer used for CR 9 and up. The 'new' .dll for odbc connectivity is crdb_odbc.dll.

You can try dropping the LogOnServer method altogether, and try the SetLogOnInfo method instead, which doesn't require you to explicitly state the name of the .dll you're using:

Rpt.Database.Tables(1).SetLogOnInfo mLogonServer, mLogonDB, mlogonUserID, mPwd

Another potential issue here is that you don't have a Developer version of CR 10, which is required (so I thought) to develop an application using the Crystal Reports ActiveX Designer Runtime Library 10.0.

-dave

 

[pc66]

Dave,
Many thanks, while I still had trouble with the LogOnServer method and was unable to get it working, your suggestion of SetLogOnInfo worked perfectly.
Reference to SetLogOnInfo did not appear when I added reference to Crystal Reports ActiveX Designer Runtime Library 10.0, so I had to add a few more References, and do not know which was the correct one before SetLogOnInfo worked, but will go through and work that out now.
Thanks for the help, greatly appreciated as now have our scheduler up and running again and can switch all our users across to CR 10 without worry.

Thanks Paul