Crystal Reports and VB

[Chopstik]

I am trying to run a previously created Crystal report in a VB 6 application. I can get it to ask for the parameters, but when it attempts to open, get an error message stating that the server is not yet opened. However, when I try to logon to the server using the following code, nothing seems to happen. I am using Crystal 7.0, VB 6, and I know that the server with the database I'm trying to access is Unix (not sure if that makes a difference). I'm familiar with both Crystal and VB, though not an "expert" in either. I would appreciate any help anyone could offer. Thanks!

TestConnect.LogOnServer ,ServerName,DatabaseName,myUserID,myPassword

 

[JHerr]

i experencied similar problems with vb6 and sql server 2000.
i found this page

http://support.crystaldecisions.com/library/kbase/articles/c2002649.asp

while it may not have exactly what you need, it nudged me in the right direction.
good luck!
-jacob

 

[balves]

You're missing the first parameter to .LogonServer. The DLL that you are using to connect to the database.

 

[Chopstik]

I'm not sure what .dll that it is referencing. Sorry to be thick-headed, but is it referencing the craxdt.dll file or something along this line or something else? Thanks!

 

[balves]

It's "p2sodbc.dll" or "p2ssql.dll".

Or use .SetLogonInfo which has exactly the parameters you are using for .LogonServer (i.e., 1 less)