Re: DMO SQLServer->Connect failed for user name with special characters
- From: "Ajey" <ajey5@xxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 17:29:34 +0530
strSQLLoginName = L"abc;xyz"
strSQLLoginPassword = L"abc"
HRESULT hrConnect = spServer->Connect( rkstrCurrentServerName.c_str(),
strSQLLoginName.c_str(), strSQLLoginPassword.c_str() );
This code also gives the same error. Also, if i paste user name as abc;xyz
in Enterprise Manager or Query Analyzer I get the same error.
The same thing works with ADO. I had to just escape the special characters
in the connection string. While can pass the username & password directly to
the ADOConnection->Connect() method. But same is not working on DMO.
Thanks.
- Ajey
"Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
news:OrYsYoujFHA.3316@xxxxxxxxxxxxxxxxxxxxxxx
> Also try to put quotes around the user name (try both single quotes and
> double quotes, one of them should be able to handle special characters)
>
> hth
>
> --
> Vikram Vamshi
> Database Engineer
> Eclipsys Corporation
> "Ajey" <ajey5@xxxxxxxxxxx> wrote in message
> news:uZXxuFojFHA.2644@xxxxxxxxxxxxxxxxxxxxxxx
>>I think it's mainly due to semi-colon. The error message displays the user
>>names till the character before the semi-colon. Also, same username &
>>password does not work while registering the sql server using Enterprise
>>Manager or connecting through Query Analyser.
>>
>> - Ajey
>>
>> "Vikram Vamshi" <vikram.vamshi@xxxxxxxxxxxxxxxxxxx> wrote in message
>> news:uMKZSCkjFHA.3900@xxxxxxxxxxxxxxxxxxxxxxx
>>>/ 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
.
- References:
- DMO SQLServer->Connect failed for user name with special characters
- From: Ajey
- Re: DMO SQLServer->Connect failed for user name with special characters
- From: Ajey
- Re: DMO SQLServer->Connect failed for user name with special characters
- From: Vikram Vamshi
- Re: DMO SQLServer->Connect failed for user name with special characters
- From: Ajey
- Re: DMO SQLServer->Connect failed for user name with special characters
- From: Vikram Vamshi
- DMO SQLServer->Connect failed for user name with special characters
- Prev by Date: Viewing Reports - in the SQL Server Reporting Services
- Next by Date: Re: Access denied after OS Disk upgrade!?
- Previous by thread: Re: DMO SQLServer->Connect failed for user name with special characters
- Next by thread: Too many connections
- Index(es):
Relevant Pages
|
