locked
DataSource Error: Format of the initialization string does not conform to specification starting at index 0 RRS feed

  • Question

  • I'm trying to create a dynamic data source while deploying report in Report Server.

    I created a data source, and in connection string passing 

    "Data Source=lab-" & Parameters!Login.Value & "-" & Parameters!Register.Value & ";Initial Catalog=MyDatabase"

    E.g:

    Server Name: lab-100-01

    where Login=100

    and Register=01

    I'm getting Error "Format of the initialization string does not conform to specification starting at index 0"

    Please let me know how to pass dynamic connection expression in connection string while creating a datasource in report server.

    Thanks in Advance!


    ZK

    Thursday, March 7, 2013 11:05 PM

Answers

  • I found the solution and posted in the following thread.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d7019ed7-85d6-4e4a-bb4e-6667fa524613


    ZK

    • Marked as answer by SQL_Admirer Tuesday, March 12, 2013 8:06 PM
    Tuesday, March 12, 2013 8:06 PM