Hi everybody, I want to import quite a lot of data from the Navision Database (*.fdb) into a mysql database. Unfortunaly I cannot establish any connection via ODBC from mysql to Navision [:(] Does somebody has got a few ideas for me ??? Thank you in advance for any help… Michael
Do it the other way around: connect to MySQL ODBC from Navision. You can do this with the use of Microsoft ActiveX Data Objects in Navision’s C/SIDE.
Or dump the data in textfiles and call the import in mysql with SHELL()
Or contact www.databackbone.dk. They have a prof replicator also to be used when replicating between Navision and Mysql.
Hi, I have a codeunit here showing how to connect to SQL, read and write with queries, and close the connection. You just have to send me an email if you want a copy…