Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 08:56:31 -0600
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0346B22D-E9DC-4FBF-9039-176B241B9A38@xxxxxxxxxxxxxxxx
> Hi Darren,
>
> No. The same code is working fine for
>
> con_string = "Server=192.x.x.x;Database=mydatabase;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
> "PlatformNotSupportedException".
>
> I checked that the Collation of 192.x.x.x is
> default(SQL_Latin1_General_CP1_Cl_AS) but that of 192.x.x.x\c1256 is
> "SQL_Latin1_General_CP1256_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:
>
>> Arif,
>>
>> Are you accidentally using the SqlCeConnection to talk to SQL Server
>> or the SqlConnection to talk to SqlCe? That would cause this error.
>> When you're using both the System.Data.SqlCe and System.Data.SqlClient
>> namespaces in the same code, it is easy to get wires crossed.
>>
>> --
>> Darren Shaffer
>> ..NET Compact Framework MVP
>> Principal Architect
>> Connected Innovation
>> www.connectedinnovation.com
>>
>>
>> "Arif" <Arif@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A86134A9-5E4C-4AD6-B8DE-EC3C3B8ECA5E@xxxxxxxxxxxxxxxx
>> > Hi all,
>> >
>> > For the same database=192.x.x.x\c1256 I use both RDA and SqlClient for
>> > data
>> > access.
>> >
>> > Using RDA i can pull two tables successfully. But when i use SqlClient
>> > to
>> > connect to the same database i get error=>
>> > PlatformNotSupportedException.
>> >
>> > I wonder that for RDA and SqlClient i m using the same paramerets, then
>> > why
>> > RDA is working and SqlClient not.
>> >
>> > I searched for this error and found that some peoples already got this
>> > is
>> > error and the reason is the SQL Server Collation. The collation for my
>> > SQL
>> > Server is "SQL_Latin1_General_CP1256_Cl_AS".
>> >
>> > If i try to connect to SQL Server with default collation (i.e.
>> > SQL_Latin1_General_CP1_Cl_AS) then SqlClient is working fine and
>> > everything
>> > is fine.
>> >
>> > Please help how to connect my SQL Server having collation
>> > "SQL_Latin1_General_CP1256_Cl_AS".
>> >
>> > arif.
>>
>>
>>
.
- Follow-Ups:
- References:
- Prev by Date: Re: Error 28035 - "Header information is either corrupted or missing."
- Next by Date: Re: Error 28035 - "Header information is either corrupted or missi
- Previous by thread: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- Next by thread: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- Index(es):
Relevant Pages
|
