About connectionstring

Reply

Volar

Member

72 Points

292 Posts

About connectionstring

Jun 08, 2013 04:21 AM|Volar|LINK

Hi all:

I have in web.config

<connectionStrings>
		<add name="Cresolia" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cresolia;Integrated Security=sspi"/>
		<add name="Cresoliaza" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cresoliaza;Integrated Security=sspi"/>
		<add name="Cresolina" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cresolina;Integrated Security=sspi"/>
		<add name="Cresolined" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cresolined;Integrated Security=sspi"/>
		<add name="Cresolis" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cresolis;Integrated Security=sspi"/>
		<add name="Cuentas" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Cuentas;Integrated Security=sspi"/>
		<add name="Historico Cresolia" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolia;Integrated Security=sspi"/>
		<add name="Historico Cresoliaza" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresoliaza;Integrated Security=sspi"/>
		<add name="Historico Cresolina" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolina;Integrated Security=sspi"/>
		<add name="Historico Cresolined" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolined;Integrated Security=sspi"/>
		<add name="Historico Cresolis" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolis;Integrated Security=sspi"/>
	</connectionStrings>

In codebehind I have

        Dim strconexion As String
        If Request.QueryString("historico") IsNot Nothing Then
            strconexion = "Historico Cresolia"
        Else
            strconexion = "Cresolia"
        End If
        Dim cnconexion As New SqlConnection(ConfigurationManager.ConnectionStrings(strconexion).ConnectionString)

When strconexion is "Cresolia" it is ok. But when it is "Historico Cresolia" it fails and I receive an System.ArgumentException.

El formato de la cadena de inicialización no se ajusta a la especificación que comienza en el índice 0.

This error tells me something is wrong with the coneectionstring. What is wrong?

Thanks in advance

Reply

adeelehsan

Star

14742 Points

3114 Posts

Re: About connectionstring

Jun 08, 2013 04:57 AM|adeelehsan|LINK

Have a look at the following:

http://stackoverflow.com/questions/11235416/format-of-the-initialization-string-does-not-conform-to-specification-starting-a

Please Mark As Answer if it helped.

MCSD[ASP.NET 4.5, SharePoint 2013], MCTS [WSS 3.0, MOSS 2007, SharePoint 2010], MCT
Microsoft Community Contributor Award 2011

Reply

Rajneesh Ver...

All-Star

28957 Points

7244 Posts

Re: About connectionstring

Jun 08, 2013 05:00 AM|Rajneesh Verma|LINK

Volar

<add name="Historico Cresolia" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolia;Integrated Security=sspi"/>
		<add name="Historico Cresoliaza" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresoliaza;Integrated Security=sspi"/>
		<add name="Historico Cresolina" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolina;Integrated Security=sspi"/>
		<add name="Historico Cresolined" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolined;Integrated Security=sspi"/>
		<add name="Historico Cresolis" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolis;Integrated Security=sspi"/>

Ideally speaking you should not have white spaces in config name or key values, Relplace White spaces with _ and then compare

<add name="Historico_Cresolia" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolia;Integrated Security=sspi"/>
		<add name="Historico_Cresoliaza" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresoliaza;Integrated Security=sspi"/>
		<add name="Historico_Cresolina" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolina;Integrated Security=sspi"/>
		<add name="Historico_Cresolined" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolined;Integrated Security=sspi"/>
		<add name="Historico_Cresolis" connectionString="Data Source=USUARIO-HP\CRESOLIA;Initial Catalog=Historico Cresolis;Integrated Security=sspi"/>

 Dim a As String = "historico"
        Dim strconexion As String
        If a IsNot Nothing Then
            strconexion = "Historico_Cresolia"
        Else
            strconexion = "Cresolia"
        End If
        Dim cnconexion As New SqlConnection(ConfigurationManager.ConnectionStrings(strconexion).ConnectionString)

Rajneesh Verma's Blog
www.rajneeshverma.com