Report Wizard Connection String for ODBC

[Sebastian]

I'm trying to use the standalone Reportgenerator with an existing ODBC System-DSN with following connection string:
DSN=myDSN;UID=myUserid;PWD=myPwd

After inserting this connection string into the wizard, and specifying "select * from KnownTableName", following error accours:
"Unable to establish a connection to the database. Please, verify that your connection string is valid...".

This connection string works fine with WinSQL and seems to be valid (See attachment).

[Massimiliano Bassili]

Sebastian,

Use the Visual Studio designer where the SqlDataSource uses the VS tools to generate a valid connection string and then when you successfully connect there, you can use it for the standalone designer.

Cheers!

[Sebastian]

@Massimiliano
Seems legit,
but the VS wizard allows you to specify a Data Connection with the option to select "Microsoft ODBC-Datasource". This option is not available using the standalone wizard.

I think the missing option is the problem with the standalone wizard.

[Steve]

Hello Sebastian,

This is a known problem in the Beta release of the standalone report designer. Please cancel the SqlDataSource wizard and set manually from the properties of the SqlDataSource a valid providerName, in your case System.Data.Odbc and run the wizard again.

Regards,
Steve
the Telerik team

[Sebastian]

Thanks, that works for me.
Will it be fixed in the next release?

[Elian]

Hi Sebastian,

The Telerik Report Designer is still in Beta and lots of improvements are yet to be done. We have ordered the tasks by importance and will complete as many of them as possible for the next release.

Kind regards,
Elian
the Telerik team