Results 1 to 5 of 5

Thread: Using RDC with Crystal Report in VB connecting SQL2000

  1. Jun 12th, 2003, 02:30 PM #1
    lemonade
    lemonade is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 2002
    Posts
    28

    Using RDC with Crystal Report in VB connecting SQL2000

    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.
    Reply With Quote Reply With Quote
  2. Jun 12th, 2003, 03:41 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    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?
    Reply With Quote Reply With Quote
  3. Jun 12th, 2003, 04:05 PM #3
    lemonade
    lemonade is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 2002
    Posts
    28
    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
    Reply With Quote Reply With Quote
  4. Jun 12th, 2003, 04:09 PM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    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.
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Jun 12th, 2003, 06:32 PM #5
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width