Invalid Character in connection

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Invalid Character in connection

Post by Valgardur » Fri 07 Feb 2014 12:41

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Mon 10 Feb 2014 11:02

Hello,

Please provide the used connection string.

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Mon 10 Feb 2014 11:48

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Mon 10 Feb 2014 13:34

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

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Mon 10 Feb 2014 14:09

SDAC 6.19.17, Delphi XE2 and SQL Server 2008

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Tue 11 Feb 2014 11:15

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

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Tue 11 Feb 2014 11:45

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Wed 12 Feb 2014 14:36

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

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Wed 12 Feb 2014 15:16

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Thu 13 Feb 2014 12:49

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

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Thu 13 Feb 2014 12:53

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Thu 13 Feb 2014 13:05

Please specify the password used in the first case.

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Thu 13 Feb 2014 13:08

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Invalid Character in connection

Post by AlexP » Thu 13 Feb 2014 13:30

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
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Invalid Character in connection

Post by Valgardur » Thu 13 Feb 2014 13:49

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.

Post Reply