ODBC for Navision Attain 3.70

• Muhammed Sajid Hussain

  SSC Veteran

  Points: 290

  More actions

  July 9, 2005 at 7:49 am

  #167452

  Hi all,

  How can I access Navision Attain 3.70 database from SQL Server 2000 Query Analyzer.

  I can access only SYS objects but I cannot access Navision Tables..

  Please give me the detailed procedure.

  Thanks in advance

  Best Regards

   

• Mohammad Sufian

  Ten Centuries

  Points: 1292

  More actions

  July 10, 2005 at 9:07 pm

  #572778

  Hi Sajid,

  If i understand ur question then hope this may help u.

  If u had syncronised the tables from navison and configured the configuration utility with user bmssa then all the table will be created with user bmssa.u can execute the select statement in query analyser as:

  select * from user.tablename

  from

  mohd sufian