Accesing Nav from Linux

nyman

Hi !

First, I see this forum is Nav 3.x related to. Sorry for asking about 2.01.

I would like access to navision own DB ( Not SQL ) from Linux. I want to use PHP to access Nav DB via ODBC.

What must I do on NT Server ?
What must I do on Linux box ?

Is this possible ? Is there any one who success with this ?

I will thanx any help.

Please, reply yoo to cnovo@icasociados.com

Thanx.

---

There is no way to Linux. Linux is the way !

waverly

Connecting to the Navision database by way of PHP/Perl or whatever is definately possible. It is, however, a bit involved. You're going to need to do a little research on an ODBC to ODBC bridge that will allow you to make an ODBC connection to an NT server from Linux. http://www.easysoft.com is a good place to start. You'll also need the Navision ODBC driver. Like I said...this isn't a simple task. I spent about a month playing around with it, trying to get everything to work properly. And when I finally got the database connected, I realized that Navision's ODBC drivers lack a lot of functionality as far as SQL queries go.

kszymanski

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by waverly:
[...]
driver. Like I said...this isn't a simple task. I spent about a month playing around with it, trying to get everything to work properly. And when I finally got the database connected, I realized that Navision's ODBC drivers lack a lot of functionality as far as SQL queries go.<HR></BLOCKQUOTE>

Hi,

does anyone try to user the server with wine ?

Best regards,
Kai.

joe_walker

Recently I found a GPL answer to easy-soft. It is called ODBCSocketServer and there is a nice column on this at phpbuilder.com.

Have a look at http://odbc.sourceforge.net/ and http://www.phpbuilder.com/columns/timuckun20001207.php3

Tried, works...
However, as was said above. Navision ODBC "lacks SQL functionality".

[ 29-11-2001: Message edited by: Denis Belih ]

slatorre

Hey. I am looking for an old friend. His name is Denis Belih. He edited your email. Do you know him? could you please send me his email?
Thanks a lot

joe_walker wrote:

Recently I found a GPL answer to easy-soft. It is called ODBCSocketServer and there is a nice column on this at phpbuilder.com.

Have a look at http://odbc.sourceforge.net/ and http://www.phpbuilder.com/columns/timuckun20001207.php3

Tried, works...
However, as was said above. Navision ODBC "lacks SQL functionality".

[ 29-11-2001: Message edited by: Denis Belih ]