PHP User Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: bbcode_highlight in ..../includes/functions.php on line 4197
Database name missing when loading crystal report-VBForums
Results 1 to 2 of 2

Thread: Database name missing when loading crystal report

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2018
    Location
    France, North
    Posts
    14

    Post Database name missing when loading crystal report

    Hi, I have a big issue and I don't find a solution even if the problem seems common.

    On my computer, my crystal report load perfectly fine, but when I try to run my application on another computer, a pop-up SQL connection appears like this one :

    Name:  Error CR.PNG
Views: 229
Size:  8.9 KB

    As you can see, the database name is missing, I don't understand why , I let you my code below :

    VB.NET Code:
    1. With crConnectionInfo
    2.             .ServerName = "servername"
    3.             .DatabaseName = "databasename"
    4.             .UserID = "id"
    5.             .Password = "password"
    6.         End With
    7.  
    8.         CrTables = cryRpt.Database.Tables
    9.         For Each CrTable In CrTables
    10.             crtableLogoninfo = CrTable.LogOnInfo
    11.             crtableLogoninfo.ConnectionInfo = crConnectionInfo
    12.             CrTable.ApplyLogOnInfo(crtableLogoninfo)
    13.         Next

    I want to deploy on a windows 7 computer with SQL 2008, if you already have the problem or if you have any idea I would be very grateful.

    Have a nice day !

  2. #2

    Thread Starter
    New Member
    Join Date
    Aug 2018
    Location
    France, North
    Posts
    14

    Re: Database name missing when loading crystal report

    After I have tried some tests, I changed the property "Integrated security" on TRUE, and then surprise !
    My Database name is there !

    Name:  Error CR2.PNG
Views: 29
Size:  18.8 KB

    But, because there is always a but, when I click to connect, I have another error, it say : "Connexion failled. Try Again."

    Name:  Error CR3.PNG
Views: 29
Size:  14.9 KB

    As you can imagine, I tried to try again without success

    If anyone can help me to resolve it, I will be very grateful, have a good day, hope read you soon !

Tags for this 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
  •  



Featured


Click Here to Expand Forum to Full Width