Unable to establish a connection to the database

[Nagadurgababu ankem]

Hi  Telerik
I am creating the report with attaching database connection and tables by taking the class library , and i am saw the report on preview tab with database records(up to this working fine)

Now i am take the visual studio project , and attach the above report to ReportViewer and run the project then it shows following error
-----------------------------------------------

An error has occurred while processing Report '': Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. ------------- InnerException ------------- Format of the initialization string does not conform to specification starting at index 0.

-------------------------------------------------

[Steve]

Hi Nagadurgababu,

As the message clearly states, you should copy the connectionString from the report class library to the config file of your actual application (web.config for web site/app, app.config for windows forms).

Best wishes,
Steve
the Telerik team

[Yusuf]

Hi Steve,

I'm getting the same error as Nagadurgababu.

At design time I have bound data to my Table (using the Table Wizard) via an SQLDataSource, which i have created previously. It renders fine in the Preview tab. However when i try to bind a DataTable (with the same schema as the one coming through my SQLDataSource) programmatically to the DataSource property (actually it is: ReportSource.DataSource) of my report then i get the exact same error as mentioned (by Nagadurgababu).

This is the first Telerik report I'm building, so i might be missing a trick or two. I have searched and read wide to try and get to the bottom of this problem, but haven't come up with a solution yet.

So, your guidance would be much appreciated.

I'm using Reporting Q1 2011

Thanks IA
Yusuf

[Massimiliano Bassili]

So Yusuf, did you copy the connectionString from the class library where your reports reside to the configuration file of your actual application as Steve explained? Also the ReportSource Property is specific to the subreport item and not the Table, so I am not sure whether you're doing things correctly.

Cheers!

[Yusuf]

Thanks for your reply Massimiliano. The trick was the ReportSource property in order to gain access to the items of the subreport, viz. the table in my case.

Cheers
Yusuf

[Sonali]

Hello telerik ,
I am also getting the same error when using telerik reports.Unable to establish a connection to the database.
Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. 

I have check the connection string in web config file of project and in class library also.They both are same. 
 

[Steve]

Hi Sonali,

Something must be different, note that the report is looking for the name of the connection, so even if the connectionString is correct, if the name differs, it would not find it. Also note that this scenario is only valid if you have used a saved connection string as connectionString for your report data source, otherwise the connectionString would be hardcoded in the report itself, in the InitializeComponent method. So if that connectionString is not valid for your SQL Server you should change it accordingly.

Greetings,
Steve
the Telerik team

[Marek]

I had the same error. In my case visual designer was showing different connection string name then it was set in code so I modified connection string name in telerik designer class manually and that worked. Sometimes visual designer hangs when number of fields is large - 200 - 300.

[Keith Rowe]

I followed the solution closely.  Still the same problem.

Would love to see updated Telerik TV episodes.  The ones I am watching are from 2009.

[Stef]

Hi Keith,

You can follow the steps illustrated in the SqlDataSource Wizard article to set your SqlDataSource component.

In your support ticket #833478 you can find additional information on your concrete connectivity problem with the SqlDataSource component.

Regards,
Stef
Telerik

 

 

[Gunjan]

Got same error , unable to get connection string....   
After adding MySql.Data and MySqlConnector Packages  from NuGet the error removed and Report Application work properly 

Hope this will help ..!

 

Regards, 

Gunjan