(RDA = OK) + (SqlClient = PlatformNotSupportedException) + I wonde

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.
.

Relevant Pages