Connection String Length error

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.
-JonDon'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
>|||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
>|||Really strange. 1024 is more than 10 lines of 80 characters which look like
really huge for a connection string... My guess would be that you have
indenting or something similar in your XML file that causes white spaces to
be added...
--
Patrice
<Jon Meyer> a écrit dans le message de news:
e2sL%23sVwGHA.5044@.TK2MSFTNGP05.phx.gbl...
>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
>>
>