Format of the initialization string does not conform to specification starting at index 0
Hello!
Has anyone received this error when using a SQL Query component? I even tried to use the Initialize data component to set the value to 0 and I still got the same error. Does anyone know how to address this? I bolded the error message that I'm getting in the debugger. Hopefully someone can shed some light on this for me!
Tom
Component Link Executed
Exception Type : System.Exception
Message: (GetAltirisHD6ActiveWorkers GetAltirisHD6ActiveWorkers) - Format of the initialization string does not conform to specification starting at index 0.
Stack Trace
(inner exception)
Format of the initialization string does not conform to specification starting at index 0. at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at GetAltirisHD6ActiveWorkers.SqlQuery.GetAltirisHD6ActiveWorkers.GetConnection(IData data)
at GetAltirisHD6ActiveWorkers.SqlQuery.GetAltirisHD6ActiveWorkers.Run(IData data)
at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context)
at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.DoRunComp(IOrchestrationComponent comp, IData data, TLExecutionContext context)
Comments
Connection String
I think it's having a problem with your SQL Connection String. Open up the Integration project that contains your SQL Query/Script generator, choose Adjust Definitions and double click the generator that pertains to the SQL Query component in your project. On the first part of the wizard, click the "Test Connection" button under the Connection String drop-down and make sure you are getting the "Connection Test Success" message. If not, you need to modify your connection string. If that's not it close your Workflow project, reset server extensions and then reopen your project and see if it still gives the error.
- Bruce
*** If a forum post solves your problem, please flag it as a solution. If you like an article or forum post, vote it up. ***
I rebooted the computer,
I rebooted the computer, restarted the services and checked the connection. The SQL connection was working when I was creating the component. I double checked it and it's still good. I'm still getting the same error though.
Here is the workflow. It doesn't get past the component for GetAltirisHD6ActiveWorkers
Will you paste the connection string?
Will you paste the connection string for your "GetAltirisHD6ActiveWorkers" component? It should read something like "Data Source=mySQLServerName;Initial Catalog=myDatabaseName;User ID=myUsername;Password=myPassword;"
Also, if you disable/remove the "GetAltirisHD6ActiveWorkers" component, does the "GetAltirisHD6Licenses" component throw the same ConnectionString error?
Wes
All the components throw the
All the components throw the same error when I'm going through the debugger (such as if I remove one and substitute with another). The connection string to the SQL Server works fine.
Here is the string...
Data Source=Altiris11;Initial Catalog=Altiris_11_incidents;User ID=SysPrep;Password=xxxxxx;
I want to try to cover all bases
The part of the error that says "index 0" means that the beginning of the connection string does not contain valid input. If you use a connection string like "0", "Data Source", or random text like "asldkfjaslkg", it will return an error with "index 0".
What did you mean when you said: "I even tried to use the Initialize data component to set the value to 0 and I still got the same error."? If your connection string is set to "0", you will get that error for sure.
Is the connection string you pasted coming from the component in your workflow ("Edit Component" --> "Connection Configuration" tab --> "Connection String:") or from the integration project ("Integration Library"-->"Adjust Definitions"-->"Connection String")? The connection string property of the component in your workflow is the one that will be used when the project is run.
Thanks freEner-g_Wes, I had
Thanks freEner-g_Wes, I had to check the properties and make a quick edit!
Would you like to reply?
Login or Register to post your comment.