[RESOLVED] Database name missing when loading crystal report

[Macronaute]

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 :



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

With crConnectionInfo
            .ServerName = "servername"
            .DatabaseName = "databasename"
            .UserID = "id"
            .Password = "password"
        End With
 
        CrTables = cryRpt.Database.Tables
        For Each CrTable In CrTables
            crtableLogoninfo = CrTable.LogOnInfo
            crtableLogoninfo.ConnectionInfo = crConnectionInfo
            CrTable.ApplyLogOnInfo(crtableLogoninfo)
        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 !

[Macronaute]

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



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



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 !

[Macronaute]

Hi, I finally found by myself,

I had the problem on windows 7 first, and that was because I do not have the file access on the Client PC to open the crystal report.

And I had it to windows 10, more difficult one, finally, it was the SQL Native Client which was missing on the right version for windows 10.

Hope it will help some people in the same case.

Have a good day !