Invalid Character in connection

[Valgardur]

I see this is an old issue, and should have been solved... but it keeps returning, both in the latest version and the one before.

If I define a connection and test, and Test connection is successful.. I still (sometimes) get "Invalid character '=' in non-quoted connection parameter value." - and my defintions are lost.

[AlexP]

Hello,

Please provide the used connection string.

[Valgardur]

Thanks,

But it doesn't get generated, I get this error and then the dialog closes and all my changes are lost.

In this case I was setting a connection with Windows authentication.

[AlexP]

Please specify the versions of SDAC, IDE and SQL Server client.

[Valgardur]

SDAC 6.19.17, Delphi XE2 and SQL Server 2008

[AlexP]

We cannot reproduce the problem on the latest SDAC version. Please specify the used connection parameters - the names of the server and database.

[Valgardur]

The server is called "Staki-SQL2008" and the database is called "Textavarp" (without the quote, of course).

I modified the DFM file manually and the connection works fine.

[AlexP]

Please provide the source code and the modified code of the DFM. The problem may be due to reading properties from the DFM

[Valgardur]

The source code is both big and not to be distributed..

The important lines though were.. (with names and password a bit changed)

Database = 'tt'
Username = 'ur'
Server = 'ur.xxx.is'
LoginPrompt = False
Left = 28
Top = 20
EncryptedPassword = '..'

and are now

Database = 'Textavarp'
Authentication = auWindows
Options.Provider = prSQL
Server = 'Staki-SQL2008'
LoginPrompt = False
Left = 80
Top = 196

[AlexP]

The problem is not reproduced with the connection parameters you provided. Please specify the exact parameter values.

[Valgardur]

I'm sorry, but at least not without confirmation from my client..

More importantly, the first parameter values are probably not the problem, as the error occurs when I have entered new values, test connection works fine, but when I confirm I get the error.

I sent the exact correct values that cause the problem.

[AlexP]

Please specify the password used in the first case.

[Valgardur]

Surely you are not asking me for the password used to access my client's database??

[AlexP]

All the parameters except EncryptedPassword are correctly parsed when building ConnectionString. The password can contain specific characters that can cause the error. You can send the password to alexp*devart*com or specify the password characters that are not letters or digits.

[Valgardur]

The password only has lower case letters and digits.. like "d3v4rt" or "d3v0rt"

Again, these are the old values not the ones I am entering.