SDAC Connection With SQL-Azure

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
People Inc.
Posts: 1
Joined: Mon 10 Sep 2012 14:44

SDAC Connection With SQL-Azure

Post by People Inc. » 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;"

AndreyZ

Re: SDAC Connection With SQL-Azure

Post by AndreyZ » Tue 11 Sep 2012 15:02

Hello,

Thank you for the information. We have reproduced and fixed this problem. This fix will be included in the next SDAC build.

Post Reply