SDAC Connection With SQL-Azure
Posted: Mon 10 Sep 2012 14:56
I'am trying to connect to a SQL-Azure server using SDAC.
When I connect to a server with a name like uq39mxxxxx.database.windows.net everything is working fine.
When connect to a server with a name like |1erhxxxxx.database.windows.net (the first character is a pipeline), I get an error messge: "Invalid character in non-quoted parameter value (Exception: TDAEMSConnectiol)".
Is there a limitation in the characters to use in the server name, or do I need to setup the connection string in a different way.
The used connection string is: "SDAC?Server=|1erhxxxxx.database.windows.net;Database=dbnamne;UserID=username@|1erhxxxxx.database.windows.net;Password=password;"
When I connect to a server with a name like uq39mxxxxx.database.windows.net everything is working fine.
When connect to a server with a name like |1erhxxxxx.database.windows.net (the first character is a pipeline), I get an error messge: "Invalid character in non-quoted parameter value (Exception: TDAEMSConnectiol)".
Is there a limitation in the characters to use in the server name, or do I need to setup the connection string in a different way.
The used connection string is: "SDAC?Server=|1erhxxxxx.database.windows.net;Database=dbnamne;UserID=username@|1erhxxxxx.database.windows.net;Password=password;"