C/ODBC (for v3.70B) and SQL Server 2005

nwright
nwright Member Posts: 2
edited 2006-08-25 in NAV/Navision Classic Client
I am trying to import data from a Navision native database into a SQL Server 2005 database using the Navision C/ODBC driver. Unfortunately, once I enter the DSN name and Driver name (using the "DotNet Framework Provider for ODBC" data source option), I get a message in the SQL Server Import Wizard "Cannot get the supported data types from the specified connection"..."Specified cast is not valid (System.data)".

I see that there is some advice elsewhere on the forum about issues between Navision v3x and SQL Server 2005. Is this another one of the problems? If not, could you let me know how to overcome this problem?

Thank you.

Comments

  • bbrown
    bbrown Member Posts: 3,268
    You don't use C/ODBC with SQL. Use the ODBC driver that comes with SQL.
    There are no bugs - only undocumented features.
  • nunomaia
    nunomaia Member Posts: 1,153
    it's better to use dataports
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Savatage
    Savatage Member Posts: 7,142
    UPDATE:
    "NeilW" wrote:

    Thanks for the information. My original question was whether or not the
    C/ODBC driver (for Nav v3.x) can be used to import data from the Native
    Database into a SQL Server 2005 database. I can import from a Native (3.70) Database into a SQL Server 2000 database but I'm having problems doing the same into SS 2005.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories