Recent content by DynamicArray

Ken and Balves, :-D Thanks for all the help! Its finally working properly, here's the code that did it: ' Set the report and connect to the server Set report = crxApplication.OpenReport("c:/path/aReport.rpt") report.Database.LogOnServer "p2sora7.dll&quot...

That sounded promising, but unfortunately it didn't work (you've guessed it, 'Server has not yet been opened'). Here are the parameters I have set (replaced for obvious reasons): (In Crystal Reports) Dll used: pdsora7.dll (the Crystal Oracle driver didn't work) Server Type: Oracle Server Server...

Ken, I have tried pdsora7.dll already, and it gives the 'Server has not yet been opened' error! DynamicArray

The reports are currently using pdsora7.dll We can launch reports from VB, but only if they have saved information, and only using: Set report = crxApplication.OpenReport("Cancellations By Product.rpt") report.Database.Tables(1).SetLogOnInfo "myServer&quot...

Ken, I've tried LogonServer, LogonServerEx (each with and without DSNs) and SetLoginInfo, and all say 'Error detected by database DLL' (using p2sodbc.dll) or 'Server has not yet been opened' (using pdsora7.dll - from the CR designer). How do I know whether I need LogonServer or LogonServerEx...

Ken, I'm trying to use the Report Designer Component with a .rpt file, as described in your Crystal/VB Quick Reference. I'm trying to connect directly to the Oracle 8i database through ODBC. Regards, DynamicArray

Hi, Thanks for the suggestions, unfortunately I'm still getting errors. Using the .LogonServer method, an error message opens that says 'Server has not yet been opened'. Using the .SetLoginInfo method, I can enter Crystal parameter values (sounds more hopeful), but when I continue from that...

Oops, forgot to add the error that was produced by the previous code! Run-time eror '-2147192179 (8004728d)'; Error detected by database DLL. I'm not sure if I've got the right dll, but I've tried using odbc32.dll, and that gives an error message that says it can't find odbc3d.dll (I can't...

I've got a similar problem, with VB6, Oracle8i, and Crystal Reports 8. I've tried to connect to the database using the following: report.Database.SetDataSource "Provider=OraOLEDB.Oracle.1;Password=MyPassword;Persist Security Info=True;User ID=MyUsername;Data Source=MyServer", which...