Prev: Navision 5.0 SP1 on Windows 2008 TS
Next: Outlook Synch. Entity Setup
From: Quim on 12 Nov 2008 04:23
Hi,

I was facing the same problem and I solved this way.
Go to the Nav ODBC driver configuration window and choose the following
settings:

· Identifiers=All Characters
· Language=Neutral (use Fieldname instead of FieldCaption)
· Option Field Type=Integer

Of course, you must redesign your SQL queries to use FieldNames

Hope this help.
Best regards.


"AndreasT" wrote:

> I have tried connect using delphi, and im getting same error
> Key violation.
> [Simba][SimbaEngine ODBC Driver][DRM File Library]Too many columns. Some
> columns are omitted.
> General SQL error. BDE Error 9729 [$26][$ 1]
> Key violation
> [Simba][SimbaEngine ODBC Driver]Non unique column reference: Uppl_ggningstid.
>
> The column Uppl_ggningstid is the last one in the table, number 257 exactly.
>
> It must have something to do with Microsoft Dynamics NAV Driver.
>
From: M Docter M on 14 Nov 2008 05:14
I found this:


http://blogs.msdn.com/german_nav_developer/archive/2008/06/26/fehlermeldung-bei-der-benutzung-von-nodbc-mit-tabellen-die-mehr-als-255-felder-beinhalten.aspx

Offtopic: Maybe you can help me as well, i added navision as a linked server
in sql, but keep getting disconnected when selecting from large tables ?
Then navision says i am connected and sql says not authorized.....

Any tips on that ?
From: AndreasT on 17 Nov 2008 04:22
Hi Quim

Ty for the tip.
But i did solved it another way, I deleted 15 columns and know it works. So
there are a limit in the ODBC driver.

"Quim" wrote:

> Hi,
>
> I was facing the same problem and I solved this way.
> Go to the Nav ODBC driver configuration window and choose the following
> settings:
>
> · Identifiers=All Characters
> · Language=Neutral (use Fieldname instead of FieldCaption)
> · Option Field Type=Integer
>
> Of course, you must redesign your SQL queries to use FieldNames
>
> Hope this help.
> Best regards.
>
>
> "AndreasT" wrote:
>
> > I have tried connect using delphi, and im getting same error
> > Key violation.
> > [Simba][SimbaEngine ODBC Driver][DRM File Library]Too many columns. Some
> > columns are omitted.
> > General SQL error. BDE Error 9729 [$26][$ 1]
> > Key violation
> > [Simba][SimbaEngine ODBC Driver]Non unique column reference: Uppl_ggningstid.
> >
> > The column Uppl_ggningstid is the last one in the table, number 257 exactly.
> >
> > It must have something to do with Microsoft Dynamics NAV Driver.
> >
 | 
Pages: 1
Prev: Navision 5.0 SP1 on Windows 2008 TS
Next: Outlook Synch. Entity Setup