Page 1 of 1

char '@' no accepted in TMSConnection connection string

Posted: Fri 25 Aug 2006 02:54
by siatc1
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

Posted: Mon 28 Aug 2006 10:49
by Jackson
Try to quote your password like following:
'Provider=SQLOLEDB.1;User ID=user_pwd;Password="my@password";Data Source=server'

Posted: Tue 29 Aug 2006 06:07
by siatc1
The string was created by TMSConnection when I click the "..." button on ConnectString property

Posted: Tue 29 Aug 2006 13:03
by Jackson
Thank you for information.
We reproduced the problem and fixed it. This fix will be included in the next SDAC build.