ODBC without local Navision installation?

SPIKY_FRE

I want to write some php pages which need to retrieve information from a navision database.

I already installed the odbc driver (of the navision 3.6 cd), but I'm not quite sure how to configure a new DSN.

- 'Data Source': is the name I want to give to the dsn, let's say 'test'
- 'Description': doens't really matter I guess...

- 'Program folder': problem 1: does navision have to be installed on the same PC on which I need to use odbc? I'm making some php-pages that will be tested locally, so installing navision locally shouldn't be a problem, but in the end they have to be put on the webserver on which my boss probably doens't want to install navision.
So what do I have to enter in this field?

- 'Connection', 'servername' and 'net type' should be correct.

- 'Database name': problem 2: can't use the 'Database...' button because navision isn't installed here yet. And again , when I need to configure odbc on the webserver, navision won't be installed there.
Do I have to input the name of the database, or the complete path etc?

- 'Company Name': problem 3: when I push the 'Company' button I get this error "S00000 [Navision a/s][Navision Attain ODBC Driver]The operating system cannot load the DLL module nc_tcp.DLL. Please check that the LL module exists, and that any other DLL modules that it will use also exist'
Do I get this error because navision isn't installed? How do I solve this?

- 'UserId' and 'pasord' for logging into the server.



I would really appreciate any help

kine

SPIKY_FRE wrote:

- 'Program folder': problem 1: does navision have to be installed on the same PC on which I need to use odbc? I'm making some php-pages that will be tested locally, so installing navision locally shouldn't be a problem, but in the end they have to be put on the webserver on which my boss probably doens't want to install navision.
So what do I have to enter in this field?

Yes, ODBC driver for navision is using libraries from the client folder. You need client to be installed on the machine... (or needed libraries copied to some folder - may be sufficient)

- 'Database name': problem 2: can't use the 'Database...' button because navision isn't installed here yet. And again , when I need to configure odbc on the webserver, navision won't be installed there.
Do I have to input the name of the database, or the complete path etc?

Only filled if you are not using database server and you want to open database file in single user mode...

- 'Company Name': problem 3: when I push the 'Company' button I get this error "S00000 [Navision a/s][Navision Attain ODBC Driver]The operating system cannot load the DLL module nc_tcp.DLL. Please check that the LL module exists, and that any other DLL modules that it will use also exist'
Do I get this error because navision isn't installed? How do I solve this?

Because you have no client installed and not set up program path...

WayneShi

Yes, you need to have a client installation for C/ODBC 3.6 but new version 4.0 doesn't require client files.

Netnix

This is my connection string , it works perfect with IIS and some ASP code:

DRIVER={C/ODBC 32 bit}; CSF=Yes; SName=NAVTHEO; NType=TCP;CS=8000; OPT=Text; IT=All Except DOT; QT=100;QTYesNo=Yes;
BE=NO; RO=Yes; CC=Yes; BE=No; CD=No; UID=GUEST; PWD=; CN=THEO BVBA; Database=database.fdb;

Can somebody tell me where I can find this new ODBC Driver 4.0 for Navision ?

kine

On the Navision 4.00 install CD... in folder NODBC... :whistle: