C1 Report Designer Connection String

Posted by: frss_berd9 on 10 September 2017, 12:31 pm EST

  • Posted 10 September 2017, 12:31 pm EST

    I'm running into some issues building my connection string through the C1 Report Designer vers. 2.5.20071.231.

    Using the data-link properties, I build out a connection string that should look like:

    Provider=SQLOLEDB.1;

    Password=;

    Persist Security Info=True;

    User ID=;

    Initial Catalog=;

    Data Source=

    Instead, I'm getting a string like this:

    Provider=SQLOLEDB.1;

    Integrated Security=SSPI;

    Persist Security Info=False;

    Initial Catalog=;

    Data Source=



    What I'm entering in and what I'm getting for a connection string are not the same, and it's not letting me connect to build the report properly. Could there be something with SQL User Permissions that's forcing the connection string to be built using SSPI?

    I'm at a loss with this one, any help would be appreciated!

  • Posted 10 September 2017, 12:31 pm EST

    Hello,

    This is, unfortunately, not the correct forum for your issue.

    Please repost your entry at the following link:

    helpcentral.componentone.com/.../14.aspx

    Thanks

    Mateen

  • Posted 24 October 2018, 2:54 am EST

    You can connect to sql server using multiple protocol libraries, check this:

    http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels