ODBC Question

jeremyd

Does anyone know what the connections string is for connecting to the Microsoft Navision Driver?

IE: for the Excel driver, it is this:
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\path\northwind excel sample.xls

Savatage

Native or SQL?

What program are you trying to use to get the Navision Data?

jeremyd

To the Native DB..

jeremyd

I'm using Microsoft Business Scorecard 2005. It won't let you simply look up the data source, It requires a string. You can use a multidimensional data source, but only if you are using the SQL DB.

kine

Try to create file DSN in ODBC manager and look into it. May be that you will see what you need and you will be able to create the connection string.

Example of the file:

[ODBC]
DRIVER=C/ODBC 32 bit
UID=fugas
SERVER=N
CN=CRONUS Ltd.
RD=No
ML=2048
CD=No
BE=Yes
CC=Yes
RO=Yes
QTYesNo=Yes
IT=All Except DOT
OPT=Integer
PPath=C:\Program Files\Microsoft Business Solutions-Navision\Client
NType=tcp
SName=ServerName
CSF=Yes

jeremyd

I've thought about that too, unfortunately, you need to know the parameters for that driver before you can create a file DSN too. If you create a file DSN without any parameters, the only line that shows up in the file is:

[ODBC]
DRIVER=Microsoft Navision Driver

There has to be an easy way to figure this out!

Savatage

Have you installed the c/odbc and tried to connect to access or another program?

I don't know what scorecard is but do they provide any help?