Report Wizard Connection String for ODBC

6 posts, 0 answers
  1. Sebastian
    Sebastian avatar
    6 posts
    Member since:
    Sep 2011

    Posted 15 Mar 2012 Link to this post

    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).




  2. Massimiliano Bassili
    Massimiliano Bassili avatar
    323 posts
    Member since:
    May 2006

    Posted 16 Mar 2012 Link to this post

    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!
  3. DevCraft banner
  4. Sebastian
    Sebastian avatar
    6 posts
    Member since:
    Sep 2011

    Posted 16 Mar 2012 Link to this post

    @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.
  5. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 16 Mar 2012 Link to this post

    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
    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.
  6. Sebastian
    Sebastian avatar
    6 posts
    Member since:
    Sep 2011

    Posted 19 Mar 2012 Link to this post

    Thanks, that works for me.
    Will it be fixed in the next release?
  7. Elian
    Admin
    Elian avatar
    435 posts

    Posted 21 Mar 2012 Link to this post

    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
    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.
Back to Top
DevCraft banner