C/ODBC , Date Problem in SQL Server

ouredp
ouredp Member Posts: 56
edited 2004-05-18 in Navision Attain
Using Navision 3.7, CODBC 3.60 connecting to SQLServer,

we have problems in trying to export tabledata containing date format fields from Navision to SQL Server.

It seems that records containing 0D cause the error.

Insert Error, Column 120 "Order Date" , "DB_TYPE DBTIMESTAMP" Status6 Overflow

Does anybod know how to solve the problem ?

Comments

  • GoMaD
    GoMaD Member Posts: 313
    Maybe the date you want to import is not correct (according the rules set in SQL).

    Navision can handle dates from the year 0 up to 9999
    SQL Server can handle dates from the year 1750 (standard) to an date which is set in the server properties.

    Can you check your data?

    Greetings,
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • ouredp
    ouredp Member Posts: 56
    The problem was handling with Navision empty date fields.
    Finally we discovered that odbc creates the tables with smalldatetime formats.

    After changing smalldatetime into datetime it works fine. Empty date fields are imported with 1753-01-01

Categories