This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Solution
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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:
I'm using SQL Server 2008 Express, I also have the SQL Server 2008 Native Client installed.
Any help will be appreciated.
Regards.
Rolando
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
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
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}
Row: MSSQLServer
Cols:
AdoDriverName = sqlncli10
DsnODBCName = {SQL Server Native Client 10.0}