Navision 4.0 on SQL SERVER 2005 / ODBC Driver

Iwan_Jauch

Hi there

How can I select a company from navision when I read the data via ODBC SQL Server - Driver from the SQL Server 2005 ?

Is there no possibility to do this?

Thanks a lot for your help!

Greetings Iwan

kine

No, this is not possible. MS SQL doesn't know anything about Navision company. For SQL the company is another set of tables marked with another prefix.

Iwan_Jauch

Hi kine

Ohh I thought that this could be a problem. Do you know any solutions for that problem!

Or is there an other ODBC-Driver available with more functionality?

Or have I just no change to get the right data for every company out of the sql server?

Thanks for your help!

Greetings Iwan

kine

There is just one ODBC for SQL - MS SQL ODBC driver....

You can solve it in your application to construct the table names for the query from Prefix and table name - the prefix than can be changed according company you want to read...

Iwan_Jauch

Hi kine

Thanks a lot for your help. Ouh thats not good, that we have to change our application. There is really now other way?

Greetings Iwan

DenSter

There is a table called 'Company' that stores the company names. You could read and maybe do some concatenation in other queries. You'd just have to know how Navision uses special characters. For instance, it changes periods (.) in table names to underscores (_).