char '@' no accepted in TMSConnection connection string

siatc1 · Post by **siatc1** » Fri 25 Aug 2006 02:54

Hi,

My SQL server password contains '@' character. However, when I set the connection string in TMSConnection, it gives me "Invalid character in non-quoted parameter value" error

Jackson · Post by **Jackson** » Mon 28 Aug 2006 10:49

Try to quote your password like following:
'Provider=SQLOLEDB.1;User ID=user_pwd;Password="my@password";Data Source=server'

siatc1 · Post by **siatc1** » Tue 29 Aug 2006 06:07

The string was created by TMSConnection when I click the "..." button on ConnectString property

Jackson · Post by **Jackson** » Tue 29 Aug 2006 13:03

Thank you for information.
We reproduced the problem and fixed it. This fix will be included in the next SDAC build.