Navision 3.70 SQL and DSN setup

jae3240
jae3240 Member Posts: 13
edited 2004-05-04 in Navision Attain
We have just converted to Navision SQL 3.70. With our previous Navision ODBC connections we were able to specify the Company we wanted to use for a DSN. We are trying to setup an SQL dsn for an application but we don't see any way to specify the Company in that setup - is there a way to do this in the DSN?

Thanks,
John

Comments

  • DenSter
    DenSter Member Posts: 8,307
    I'm lost... what is your tip? 8)
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • RobertMo
    RobertMo Member Posts: 484
    The company is represented differently in SQL. Try to open the tables in Enterprise Manager and you will se that for all tables that have property DataPerCompany=Yes (usually almost all) the table name is actually formed like <Company Name>$<Table Name>. Like Cronus_International$Customer

    Also all special characters (dots,commas, etc) are replaced with underscore.

    You shoul rethink how to connect to db and use data out of tabels...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • DenSter
    DenSter Member Posts: 8,307
    My point being that this was neither a tip nor a trick, but a question, for which there is a more suitable forum. I thought that john may have had a tip on how to do this. :?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,506
    Topic moved from "Navision Tips & Tricks" to "Navision Attain" forum.

Categories