| Darren Shaffer 2005-08-25, 11:24 am |
| try a colon after the server IP before the port number. example:
Server=192.x.x.x : 1256
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Arif" <Arif@discussions.microsoft.com> wrote in message
news:0346B22D-E9DC-4FBF-9039- 176B241B9A38@microso
ft.com...[color=darkred]
> Hi Darren,
>
> No. The same code is working fine for
>
> con_string = "Server=192.x.x. x;Database=mydatabas
e;Integrated
> Security=false;User ID=sa;Pwd=";
>
> But if i only change server parameter to connect to another instance of
> SQL
> Server like "Server=192.x.x.x\c1256;..." i get the error
> " PlatformNotSupported
Exception".
>
> I checked that the Collation of 192.x.x.x is
> default(SQL_Latin1_G
eneral_CP1_Cl_AS) but that of 192.x.x.x\c1256 is
> " SQL_Latin1_General_C
P1256_Cl_AS". Also the exeception indicates that
> this
> is not due to cross wiring b/w SqlServerCe and SqlClient.
>
> Searching on net confirmed me that this is due to collation problem and
> perhaps devices support only English/Default Collation for SQL Server.
> But
> unfortunately I can't get any help/solution for this problem on net.
>
> Help is still required.
>
> arif.
>
> "Darren Shaffer" wrote:
>
|