Results 1 to 2 of 2

Thread: VB & Crystal Report Connection

Threaded View

  1. Jun 11th, 2005, 11:21 AM #1
    mandianie
    mandianie is offline

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    VB & Crystal Report Connection

    Which is the best method for connecting SQL Server and Crystal Report directly, for eg.ODBC,ADODB,Query Analyzer.

    I have two databases,say DB1 & DB2 with same structure in a single SQL Server.I have created two DSNs for each as DSN1 for DB1 and DSN2 for DB2. Now i have a report(crystal) addressing DSN1. In certain cases I require data from DSN2 to be displayed on the same report instead of DSN1. How can change the DSN Name while running the program. Here I haven't used the connection string, instead I gave the DSN name while creating the report.

    If using the connection string is the easier method, please advice how to use this method in VB (even a URL to any tutorials will do).

    Thank you.
    Last edited by mandianie; Jun 11th, 2005 at 11:44 AM.
    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