About Identifiers

andy76andy76 Member Posts: 616
edited 2008-09-08 in SQL General

I ask you if there is some relationship between the field Identifiers in DB SQL Server under File->Database->Alter , Integration Tab Convert Identifiers / Remove Character and the Field Identifiers under ODBC Setup - Options that is an option between All Except Dot, All Characters, All Except Space, "a-z,A-Z,0-9,-".

Thank you


  • kinekine Member Posts: 12,562
    Because C/ODBC is used for Nativeand Integration tab in Alter Database is only for MS SQL server, there is no direct connection. The only connection is, that ODBC specification is not allowing some characters as part of the object name (or some clients cannotwork with these characters). Thus both tools have some way how to "remove" these characters...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • krikikriki Member, Moderator Posts: 9,079
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.