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

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
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: How to transfer breaks from a textarea ?
    ... // replace common special characters ... // cleanup lines and paragraphs ... the swmart quotes but this is easier to read and edit. ...
    (comp.lang.javascript)
  • Re: [PATTERN MATCHING]
    ... > when playing with substr() and index. ... inconsistent) use of double quotes as well as failing to quote the regex- ... special characters, but this is just a suspicion since the OP did not show ... real code and real data. ...
    (comp.lang.perl.misc)
  • Re: Allowing special characters in a MySql Database
    ... ASP.NET MVP ... > (top down approach with VB and a MySQL database) sigh..... ... > quotes and special characters. ...
    (microsoft.public.dotnet.general)
  • Re: Special Table and Column Names
    ... Using SQL, ... This is fine, but when using SQLTables to get a list of tables, ODBC ... gives you NO indication that the table is "special", and needs quotes ... SQLTables contains all the special characters, ...
    (microsoft.public.data.odbc)
  • Re: Two Text Issues...
    ... Many applications use quotes, including FileMaker, ... around exported data to cope with special characters that would ... basic functions turn up in spreadsheet applications like Excel and most ...
    (comp.databases.filemaker)