Using DSN in VB 6.0 with Crystal Report 10

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bytesbytes
    New Member
    • Apr 2008
    • 16

    Using DSN in VB 6.0 with Crystal Report 10

    Hi,
    Im using VB6.0, Crystal report 10 and MSaccess Database. I was using Crystal report 6 and later upgraded to CR10. In VB6 i used DSN like
    .Connect = "DSN=DBName " & ";UID=admin;PWD =;"
    Now in CR10 i have created reports without using DSN in VB. Can any help how to use DSN in VB6.0 with CR10 or is there any method so that i no need to use DSN in the above said requirements.

    The code used for CR10 is
    Set Report = Appl.OpenReport (App.Path & "\SampleReport. rpt")
    CRViewer1.Repor tSource = Report
    CRViewer1.Visib le = True
    CRViewer1.ViewR eport

    Please guide me in using/without using DSN
    THANKS in advance.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Are you facing any problem with your code ?

    Comment

    • bytesbytes
      New Member
      • Apr 2008
      • 16

      #3
      Originally posted by debasisdas
      Are you facing any problem with your code ?
      I have tested and it not giving any error. Does CR10 works without using DSN in VB6.0 code?

      Comment

      • QVeen72
        Recognized Expert Top Contributor
        • Oct 2006
        • 1445

        #4
        Hi,

        You want to create CRX report with DSN..?
        or pass DSN info from VB6 to CRX..?

        Regards
        Veena

        Comment

        • bytesbytes
          New Member
          • Apr 2008
          • 16

          #5
          Originally posted by QVeen72
          Hi,

          You want to create CRX report with DSN..?
          or pass DSN info from VB6 to CRX..?

          Regards
          Veena
          Thanks for your reply veena. I need to pass DSN from VB6 to crx

          Comment

          Working...