Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: Multiple Databases

    I'm using VB 6 to run Crystal 8.5 reports. I have reports with 2 databases being accessed. I currently use the following code:

    Report.Database.Tables.Item(1).SetLogOnInfo "database 1 info"
    Report.Database.Tables.Item(2).SetLogOnInfo "database 2 info"

    This works fine when running on my machine, but not on others. The ODBC configuration is identical on both machines. I can get reports that use either of these connections by themselves to work, but not a report with both.

    Any ideas?

  2. #2
    Join Date
    Nov 2007
    Posts
    3
    similar problem i am facing .
    but i am using two server name.
    same database.
    it is working for my system .
    but the user can't.
    user can see the report for one country.
    please help
    Last edited by lalith_mca; 11-30-07 at 05:39.

  3. #3
    Join Date
    Feb 2007
    Posts
    348
    does your user connect to both servers any other time? They may not have the ODBC set up.

  4. #4
    Join Date
    Nov 2007
    Posts
    3
    Quote Originally Posted by starkmann
    does your user connect to both servers any other time? They may not have the ODBC set up.
    yes the user can connect.
    because the user can login with username password.
    from that i can understand that she/he can connect with the database.

Posting Permissions

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