C/ODBC problem

tnt26

Hi Dear Experts !

I have an interesting problem with c/odbc driver for Navision 3.7 At a friend of mine's company Navision 3.70 runs (with its native database - no sql) and they can't get the original distrbutions's package, so they bought the 3.70B Navision dist from this site.
I installed both the client version of nav and its C/ODBC driver on my own machine at home just 4 try, and everthing just worked fine !! I can access the NAV database's tables and data as well.

But when I installed this stuff on my friend's company's server, it does not work well.

I had to upload the client drivers from this 3.70B package (with the original client drivers I had the 'no permissons' message) and set the ODBC drivers' path to this uploaded folder.
[I am talking about the folder which normally under c:\program files\navision foos\client]

After this process I could choose the required company in the ODBC settings, after I set the database passwords.

When I tried to run a small DELPHI program to retrieve data from any tables from the database, the server replied: " no such table" !

Please anyone who has got some experencies about this theme, help me!!

Thank u all in advanced !!!

kine

Check language settings in the ODBC driver. May be, you used english for table naming, but the ODBC expect local names (captions)...

tnt26

Thank you for the answer !

This small delphi code I wrote just try to retrieve the table names from the database ... That's all ...

I can choose only the 'auto settings' from the ODBC's options menu ... There is no other option...

thank's again ! Do u have any other idea? :roll:

kine

When I tried to run a small DELPHI program to retrieve data from any tables from the database, the server replied: " no such table" !

Based on this text I assumed that you want to read some table. Can you post some code you are using and which call the error?

tnt26

Hey Dear Kine !

You are great !! I was just simply stupid -> after the first "Auto language" option was followed by several empty lines that's why I thought, there is no other 'language' options.

I had to choose "English" language despite of the client version is Deutch !
:shock:
ok, the table names are in English ...

Now everything just works fine !!

Thank you, very very much for the advice !!!

kine

I am happy that it helps you... O:)