4 Answers, 1 is accepted
0
Iivari
Top achievements
Rank 1
Rank 1
answered on 17 Feb 2012, 08:43 AM
I have problems with Firebird ODBC connection string. Firebird .Net connection string does not work any better. Microsoft SQL Server works fine as always.
0
Hi guys,
Steve
the Telerik team
To connect to a PostgreSQL or FireBird database you will need .Net Framework Data Provider for PostgreSQL and FireBird. If you have installed such provider you can utilize our flexible SqlDataSource component. The SqlDataSource component uses ADO.NET classes to interact with any database supported by ADO.NET.
All the best,Steve
the Telerik team
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
0
Iivari
Top achievements
Rank 1
Rank 1
answered on 22 Feb 2012, 02:26 PM
Hi,
I still to struggle connect to Firebird database. I think my connection string is right because it works fine in Visual Studio editor. Here are my connection strings:
Firebird .Net provider
character set=ISO8859_1;data source=127.0.0.1;initial catalog=Path to database file;user id=SYSDBA;password=password
OBDC driver
DSN=Firebird2;Driver=Firebird/InterBase(r) driver;Dbname=Path to database file;CHARSET=ISO8859_1;UID=SYSDBA;Client=C:\Program Files (x86)\Firebird\Firebird_2_1\bin\fbclient.dll;
I just get "Unable to establish a connection to the database. Please, verify that your connection string is valid...."
Can you please point out what is wrong in my connection strings.
Br,
Iivari Lampi
Update: I needed to select provider name first. Now all good :) Maybe you should include provider name selection into new report wizard.
I still to struggle connect to Firebird database. I think my connection string is right because it works fine in Visual Studio editor. Here are my connection strings:
Firebird .Net provider
character set=ISO8859_1;data source=127.0.0.1;initial catalog=Path to database file;user id=SYSDBA;password=password
OBDC driver
DSN=Firebird2;Driver=Firebird/InterBase(r) driver;Dbname=Path to database file;CHARSET=ISO8859_1;UID=SYSDBA;Client=C:\Program Files (x86)\Firebird\Firebird_2_1\bin\fbclient.dll;
I just get "Unable to establish a connection to the database. Please, verify that your connection string is valid...."
Can you please point out what is wrong in my connection strings.
Br,
Iivari Lampi
Update: I needed to select provider name first. Now all good :) Maybe you should include provider name selection into new report wizard.
0
Hello Iivari,
Do you get this error at runtime only and you are able to preview the reports in Visual Studio? If so be aware that whenever the reports are defined in a class library, you use SqlDataSource component for your DataSource and you save the connectionString in the settings for this class library, always remember to copy the corresponding connection string entries from the class library's config file to the application's config file (in case of web application - web.config. Otherwise at runtime when the application's config file is respected the Settings object will not be able to find such connection strings and will return the default value from its metadata.
Kind regards,
Steve
the Telerik team
Do you get this error at runtime only and you are able to preview the reports in Visual Studio? If so be aware that whenever the reports are defined in a class library, you use SqlDataSource component for your DataSource and you save the connectionString in the settings for this class library, always remember to copy the corresponding connection string entries from the class library's config file to the application's config file (in case of web application - web.config. Otherwise at runtime when the application's config file is respected the Settings object will not be able to find such connection strings and will return the default value from its metadata.
Kind regards,
Steve
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.