"Patrice" <scribe@chez.com> wrote in message
news:eTIjY8UwGHA.4872@TK2MSFTNGP02.phx.gbl...
> Don't know but you could stuff a simple connection string with spaces to
> see if it wokrs at 1023 and fails at 1025 for example...
>
> Is such as length expected ? Heve you checked what the connection string
> actually contains (especially white spaces ?) Looks really huge...
> --
>
> Patrice
>
> <Jon Meyer> a écrit dans le message de news:
> eqWjRnUwGHA.4700@TK2MSFTNGP03.phx.gbl...
>> Does anyone know if there is a limit to the length a connection string
>> can be? Or if there is a configuration setting that I am missing. We
>> have a XML doc which contains the connection strings for multiple
>> database which we pass to our custom data extension which then figures
>> out which database to connect to based on other parameters which are
>> passed in. The error we are getting is that the connection string cannot
>> be > than 1024 characters. Any help would be appreciated.
>>
>> -Jon
>>
>
>

> Does anyone know if there is a limit to the length a connection string can
> be? Or if there is a configuration setting that I am missing. We have a
> XML doc which contains the connection strings for multiple database which
> we pass to our custom data extension which then figures out which database
> to connect to based on other parameters which are passed in. The error we
> are getting is that the connection string cannot be > than 1024
> characters. Any help would be appreciated.
>
> -Jon
>

>I have tried passing in a connection string which is less than 1024
>characters and the problem is resolved. There is another thing I have
>learned. We have an application which programatically adds a subscription
>to the server. When a subscription is added in this manner the reports
>work as expected. However, if I try to run the report from the report
>manager via the intranet the report fails as described below. I not sure
>if this information is of any help. As a further check I'll run some diff
>tools against what I'm passing in. Maybe there is a difference I cannot
>see by looking at the text.
>
> -Jon
>
>
> "Patrice" <scribe@chez.com> wrote in message
> news:eTIjY8UwGHA.4872@TK2MSFTNGP02.phx.gbl...
>> Don't know but you could stuff a simple connection string with spaces to
>> see if it wokrs at 1023 and fails at 1025 for example...
>>
>> Is such as length expected ? Heve you checked what the connection string
>> actually contains (especially white spaces ?) Looks really huge...
>> --
>>
>> Patrice
>>
>> <Jon Meyer> a écrit dans le message de news:
>> eqWjRnUwGHA.4700@TK2MSFTNGP03.phx.gbl...
>>> Does anyone know if there is a limit to the length a connection string
>>> can be? Or if there is a configuration setting that I am missing. We
>>> have a XML doc which contains the connection strings for multiple
>>> database which we pass to our custom data extension which then figures
>>> out which database to connect to based on other parameters which are
>>> passed in. The error we are getting is that the connection string
>>> cannot be > than 1024 characters. Any help would be appreciated.
>>>
>>> -Jon
>>>
>>
>>
>
>