Devart Forums

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.

Hello,

Please provide the used connection string.

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.

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

SDAC 6.19.17, Delphi XE2 and SQL Server 2008

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

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.

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

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

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

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.

Please specify the password used in the first case.

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

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.

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.