Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- From: "Arif" <Arif@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 23:10:02 -0700
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:
- Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- From: Ilya Tumanov [MS]
- Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- From: Darren Shaffer
- Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- References:
- Prev by Date: Re: RDA or Replication
- Next by Date: Error 28035 - "Header information is either corrupted or missing."
- Previous by thread: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I wonde
- Next by thread: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- Index(es):
Relevant Pages
|
