Navision and SQL 2005

HalMdy
HalMdy Member Posts: 429
edited 2005-12-12 in NAV/Navision Classic Client
Has someone already tested to install Navision on a SQL 2005 server ?
How does it look like ? Do you have access to the "Partial recovery" part of SQL ? Wich version of Navision do you use ?

Comments

  • fcassoli
    fcassoli Member Posts: 16
    I tried biefly with Navision 4.0, and it seems to work (I posted a sales order and a purchase order and had no errors).
    I tried no "advanced" operations.

    Federico
  • kine
    kine Member Posts: 12,562
    SQL 2005 is supported since 4.00SP1 (4.01). I did not tryed it without the SP1 yet...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Frodio
    Frodio Member Posts: 10
    I got some problems regarding data types.

    The session is of integer in navision, but BigInt in sql database.
    Not sure if this is fixed in SP.1 or if there are any ways to work around this on issue in 4.0?

    Anybody got any suggestions so please let "us" know?
  • kine
    kine Member Posts: 12,562
    I have this problem too...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Frodio
    Frodio Member Posts: 10
    Works on 4.0 SP1 \:D/
  • kine
    kine Member Posts: 12,562
    And it is why SQL 2005 is supported only for SP1... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories