This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RolandoV
Level 3
‎Nov 04, 2011 11:06 AM

Problems with new Collations in SQL Server 2008

Hi,

I have a problem during the execution of a sql server script. The script uses Dari_100_CI_AS collation, when it is executed from management studio, it is executed without problems, when executed from the installer, I get this error message:

Error 27506.Error executing SQL script MyScript.sql. Line 16. The USE database statement failed because the database collation Dari_100_CI_AS is not recognized by older client drivers. Try upgrading the client operating system or applying a service update to the database client software, or use a different collation. See SQL Server Books Online for more information on changing collations. (4075)


I'm using SQL Server 2008 Express, I also have the SQL Server 2008 Native Client installed.

Any help will be appreciated.

Regards.

Rolando
Labels (1)
Labels
0 Kudos
(1) Reply
RolandoV
Level 3
‎Nov 04, 2011 04:30 PM

I solved the problem by updating ISSQLDBMetaData table.

Row: MSSQLServer
Cols:
AdoDriverName = sqlncli10
DsnODBCName = {SQL Server Native Client 10.0}
0 Kudos