Using RDC with Crystal Report in VB connecting SQL2000

[lemonade]

Hello!

Here is my problem and I hope to get a solution.

I am using CRViewer in VB app to display reports that located in the current directory of application.
It works perfectly on the machines that have Crystal installed. However, I was absolutely convinced that by loading all appropriate DLLs I will be able to uninstall Srystall from users machine and still use crystal viewer in VB.
So, testing the very same exe on the machines wthout Crystal gives me the following error:

"Server has not yet been opened"
I read various thhreads on this forum concerning the very same error and my code looks correct + it is working on my machine when compiled.

If anybody has a solution or at least suggestion please reply asap.
We are implemention application today!!!!! Thanks.

[brucevde]

You are correct, Crystal Reports does not need to be installed in order to use the Viewer

That error message could mean

the login to sql server is incorrect.
no user priviledges on the tables, views, stored procedures.
missing dlls.


Did you install all dlls and did they install properly? Check the Crystal RunTime.hlp file for more information.

How are you connecting to SQL Server?

[lemonade]

I am connecting to SQL Server through report using file dsn with windows authentication.
I also placed this piece of code in VB app:

For i = 1 To Report.Database.Tables.Count
Report.Database.Tables(i).SetLogOnInfo "ServerName", "DBname", oSession.CurrentUser
Next i

I am connectiing my reports to sp not tables, can this be an issue.
I have included the following DLLs into istallation kit:

CRAXDRT.DLL CRVIEWER.DLL IMPLODE.DLL SSCSDK80.DLL
CRPAIG80.DLL MFC42.DLL MSVCRT.DLL

as well as p2soledb and p2sodbc


As for the use priveledges - I was testing with my user id.

I really appriciate your time and help. Thanks

[techgnome]

Does the file DSN exist on everyone's machine? Double check and make sure before syaing yes or no.... if it isn't included as part of the install.... it might not be there.....
Also... if it is there.... I think you might be missing some of the Crystal Dlls.... I think there is also ps2sqloledb that's needed.

[brucevde]

Are there any sub reports in your reports? You must make sure the login information is correct for each table in your sub reports as well.