Re: DMO SQLServer->Connect failed for user name with special characters



/ is an escape character in cpp, you have to replace / with // in your
string for it to work properly.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Ajey" <ajey5@xxxxxxxxxxx> wrote in message
news:OqwRXccjFHA.3316@xxxxxxxxxxxxxxxxxxxxxxx
> Actual user name was a`~!@#$%^&*()_+|-=[];',./{}:"<>?
>
> "Ajey" <ajey5@xxxxxxxxxxx> wrote in message
> news:ujnaqXcjFHA.1428@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>> If I give a user name or password having special character (mainly
>> semi-colon) then I cannot connect to the SQL Server. Following is the
>> error:
>>
>> Login failed for user 'a`~!@#$%^&*()_+|-=[]'.
>> TCP Provider: An existing connection was forcibly closed by the
>> remote host.
>>
>> Communication link failure
>> Invalid connection string attribute
>>
>> However, this error was coming in my Cpp code. I tried with VB, I
>> works. Also, I got same error from Enterprise Manager.
>> Is this a defect or known behavior in DMO?
>>
>>
>> TIA,
>> Ajey
>>
>
>


.



Relevant Pages


Loading