HI All, Can any one tell me how collation can be added in the existing database.?? And what settings need to be done for connecting database with the Windows Authetication a part from that Extended stored procedure.??
Can you be more specific about the actual problems you have?
HI, When i am connecting to a SQL database…its says that the collation is not supported by Microsoft Business Solutions-Navision… I am using 3.70… So i was thinking to change the collation of the database…Any way when i see the properties of the database to see the collation it is using …it shows blank… That means no collation.
If you’re unable to open the database because of an unsupported collation, how are you able to see the database properties in Navision?
That is through Enterprise Manager…
Create the DB via Navision Client.
quote:
Originally posted by Michael_patrick_11
That is through Enterprise Manager…
If you right-click on a database and select properties, there is a collation property on one of the tabs. You can do a similar thing on the server level to change the default collation. I don’t know if this will make your database accessible to Navision, but what you’re looking for can be done.
normally, navision will suggest you to create the database by using code 1252(54). For the client, the stx file will check the code page of client (there is one setting in the stx file called DBCS (double byte character set), 0 for single byte and 1 for double byte. From 3.70, there is an option when creating the database called “validate code page”,try to uncheck it.
Yeah changing the collation would solve my problem. But i dont know how to change the collation property from enterprise manager. As it is not opening the database so i cant change from Navision. Is collation is related to Users.??
hey, You can actually change the STX file in the navision Client Folder in your server, Delete the ZUP file and restart the navision, this will no longer validate… If you dont get your hands on this STX then let me know what Version you are using i may be able you help you find the same. regards venu
All databases have a collation - it is odd that EM is showing blank for it; to me it indicates something wrong with your database. Use Query Analyzer to try to find the collation of the database, substituting ‘your db name’ with the actual name: SELECT DATABASEPROPERTYEX(‘your db name’, ‘Collation’) What do you get? You can change the collation of a database also from Query Analyzer by issuing: ALTER DATABASE COLLATE e.g. ALTER DATABASE COLLATION Danish_Norwegian_CS_AS The effect of this is to set the collation for all future columns created or altered in tables. It does not affect your existing data (because all indexes in the entire database would have to be rebuilt). This is what Navision does when you alter the collation. Collations are not user related, no. By the way, you should set the collation to one that satisfies your language needs, not to a particular hard coded value, when you create your database. I think you should recreate your database.