can't connect to database using strange characters as part of password

Brian Donahue

Hi,

Thanks for writing. We did have this problem, as I recall, in Data
Compare 3.1, where if you had a password with a double-quote ("), Data
Compare would produce an invalid connection string and the connection would
fail. This is probably true for singlr quotes.

Does this still happen in version 3.3 of Data Compare?

Regards,

Brian Donahue
Red Gate Technical Support

"Johnny Newsgroupsurfer" <no-spam@sonic.net> wrote in message
news:H%23CReuXAEHA.1468@server53...
> took awhile to figure this out, after much head bashing, that SQL Data
> Compare was not functioning properly on a database we have, whose
> password contains an apostrophe ('). the password also contains a caret
> (^) and i think this may also be confusing it. the error message was a
> bit cryptic:
>
> This object cannot be viewed as an error occurred during the compare
> process:
> Error comparin [dbo].[myTableName]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near 'egg'
>
> and our password was something along the lines of
> secret'egg^password+something
>
> Of course not the real password, but the format is the same.
>
> Just thought i'd pass this along...
>