Cannot open Database-SQL Server option

sudoku
sudoku Member Posts: 50
edited 2006-11-06 in Navision Attain
Hello Everybody
When trying to open a SQL Server option Database using 3.60 client it shows an error message saying some problem with the Data type of "Wait Time" field in Session Table. I am using SQL Server 2005.

The message is as follows:
*******
The Session table contains a Microsoft Navision Attain field data type that is not compatible with the SQL Server data type:
Field:Wait Time (ms)
Type: Integer
SQL Type: BIGINT

*******
please help me out.
Thx in advance and appreciate your time.

Comments

  • sudoku
    sudoku Member Posts: 50
    BlackTiger wrote:
    SQL2005 is not supported by Navision 3.x

    Does that mean Installing SQL Server 2000 will solve the problem?

    Thanx in advance.
  • sudoku
    sudoku Member Posts: 50
    BlackTiger wrote:
    SQL2005 is not supported by Navision 3.x

    Does that mean Installing SQL Server 2000 will solve the problem?

    Thanx in advance.
  • Phenno
    Phenno Member Posts: 630
    sudoku wrote:
    BlackTiger wrote:
    SQL2005 is not supported by Navision 3.x

    Does that mean Installing SQL Server 2000 will solve the problem?

    Thanx in advance.


    Probably yes, though, it always can be another problem.
    2005 is not supported by 3.x client as BlackTiger stated so you have options to downgrade sql server or upgrade navision client.

    if you have a licences for those versions, ofcourse...

Categories