Setting collation property in the connection string to SQL Server 2005

Posted by user369745 on Stack Overflow See other posts from Stack Overflow or by user369745
Published on 2010-06-17T20:15:00Z Indexed on 2010/06/17 20:23 UTC
Read the original article Hit count: 708

I have a ASP.Net web application with connection string for SQL Server 2005 in the web.config.

    Data Source=ABCSERVER;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
User ID=myUsername;Password=myPassword;

I want to specify the collation property in the web.config for different languages like French like

    Data Source=ABCSERVER;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
User ID=myUsername;Password=myPassword;Collation=French_CS_AS

But the Collation word is not valid in the connection string.

What is the correct keyword that we need to use to specify the collation in SQL Server 2005 connection string?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about ADO.NET