PHP & Navision

axno

Hi everybody
begining to build a php + NAS application
just wanna know if some help with classical c/odbc driver usage is available.
new to navision and just want to extract information in a php application on windows !

if you've got some usefull php script or installation how-to, it may help just te prevent me to crash the production system

is there a demo navaision database installed by default which i can link to test my connection and sql request ???

thx per advance

mickuk

Hi Axno,

I've looked into using PHP with the Navision native database and hit a few problems. One thing to research is the MSMQ. I believe this was one of the answers that I was given a while back. Check out http://www.mibuso.com/forum/viewtopic.php?t=5968

DenSter

I hope you are planning to build your application on a COPY of the production system, not the actual production system itself.

rbm

But you also asked about whether Navision comes with Demo database. The answer is Yes. If you have a version with the SQL server option, it has an SQL Database as well (the data files basically).
I havent tried to connect through PHP, but if you have a fact (I don't) that php is compatible with SQL sever DB, then you are there.
A painful workaround would be to creat a MySQL database, duplicate there all navision tables you with to get data from and then create dataports in Navision. Prepare a data load script for MySQL, and probably plan to regularly run dataports in Navision, and data loads in MySQL (that's from text files)

Kind regards,

Robert