Error connecting crystal reports with server

1

Good I'm doing an application in visual basic 2017 that connects to SQL, the problem comes when I run the .exe on the client's machine and I want to generate a report Note that the program is connected to the database that is on the server perfectly, the problem is only with the report this is the error that pulls

this is the code I use

Dim Reporte As New rpt_Reporte_Procesadas

            Dim boConnectionInfo As ConnectionInfo = New ConnectionInfo
            boConnectionInfo.ServerName = "10.130.XX.XXX"
            boConnectionInfo.DatabaseName = "Base_datos"
            boConnectionInfo.UserID = "Admin"
            boConnectionInfo.Password = "XXXXXX"
            boConnectionInfo.Type = ConnectionInfoType.SQL
            For Each t As Table In Reporte.Database.Tables
                Dim boTableLogOnInfo As TableLogOnInfo = t.LogOnInfo
                boTableLogOnInfo.ConnectionInfo = boConnectionInfo
                t.ApplyLogOnInfo(boTableLogOnInfo)
            Next

What I find strange is that it does not establish the name of the database and at the time of the message it does not let me write in that field either, I think the problem goes around

Thanks in advance

    
asked by Henry Fabián Mata Araya 17.04.2018 в 03:58
source

1 answer

1

I was able to solve my problem, the solution is to change the connection type of the report to Microsoft OLE DB Provider for SQL Server. In my case what I did was create a new report but with that new connection I leave images of where it is done

In the same report follow these steps

I hope the solution will help them

    
answered by 17.04.2018 в 21:46