NODBC parameter problem

guenther
guenther Member Posts: 8
edited 2007-02-14 in NAV/Navision Classic Client
Hi,

We just upgraded from 3.60 to 4.03 and installed the new NODBC-driver. Now we cannot access the native db from the SQL-Server.
In the odbc-driver we can connect to our db and we also see our companys, so the connection is established.

When we try to import data into the SQL server 2000 the source-tables are alwys schown like this. :(

I don't know how to change that. Any ideas?

Greetings,
Michael
MSDynamicsNAV 2009 Build 32012 Classic Client
MS SQL Server 2008

Comments

  • kine
    kine Member Posts: 12,562
    It seems like some mismatch between Servername and DatabaseName. Check the parameters, if you are connecting to server, enter just server name, not DB name.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • guenther
    guenther Member Posts: 8
    Here are the parameters I'm using:

    NODBC parameters

    I am using version 4.00.03.23305 of "Microsoft Navision Driver".
    MSDynamicsNAV 2009 Build 32012 Classic Client
    MS SQL Server 2008
  • kine
    kine Member Posts: 12,562
    Hmmm, for me it looks like correct parameters.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • julio
    julio Member Posts: 1
    Hi
    I'm having the same problems.
    The connection is toooooo slow.
    The NODBC cannot find the table name.
    It looks like that the NODBC is trying to use the local cache to retrieve the data.

    Anybody have any idea?
    B.Regards
    Júlio
    JC

Categories