Hi I’m totally green when it comes to Navision. What I’m trying to determine is how to set up an ODBC connection to a navision server (remote). I’ve been told that installing the OBDC driver off the server is not enough… that you need some sort of licence. The server is in another town… I’ve seen examples of how to create a linked server in SQL Server but they seem to imply that the navision server must be on the same machine (local). Can anybody give me some sort of advice? Many thanks Rob
Click on “Search”, enter “ODBC connect server” you will find tonds of articles about this. Once you have it basically moving along, then post your SPECIFIC questions here. As to licence, go to Navision License info, and see if C/ODBC s there, if not then you are out of luck.
If you intend to connect to Navision db on SQL then you don’t use Navisions ODBC. That one is only for native dbms. And the linked server is defined on the same server as you have the Navision database and is pointing at another server. what you usually do is to create views in your Navision database which reads data that resides in a database on the linked server. In navision you set this up by creating a table that has columns corresponds to the view, set the property “linked server” to Yes and the property below (forgot the name of it) to no since SQL can’t keep the transactional integrity when working with a linked server. Was that an answer for your question? Anyway. I think you find what you need in the manuals. Read them first. Then search the forum. C/AL and C/SIDE isn’t that complicated and i think we covered most things over the years when it comes to basic functions and how to set up and install.
Basic C/ODBC connection with Any Navision database (FDB). 1. Make sure your workstation can access Navision remotely! 2. Make sure you have Office (Ex: Excel or Word). 3. Make sure you have installed the additional MsOffice add-on MSQUERY! (Usually found on the same office CD/ Install Extra stuff. 4. Make sure you use the correct C/ODBC version that the workstation/Server is using. Ex: Navison 4 or Navision 3.70 etc. Don’t mix match them! 5. Install the Navision C/ODBC drivers, Except all values. 6. First Do a test run and try to connect to a local C-drive database Locally. Once you accomplish all the correct settings and it works. Then Create a new Start-> Control Panel → Adminstrator → ODBC connection. Call It Ex: Navison 3.70 Server. 7. Configure the ODBC connection per the manual or the sample ODBC navision created for you. Just change the connection to Server. 8. Make sure the user ID has SUPER rights for now (Testing purposes only). Later you can restrict certain users from using the ODBC connection. 9. Make sure the Server /or Client have a Navision C/ODBC license. This will not work if the client is not licensed for it. 10. Make sure you have enought sessions. Any odbc connection will use up an additonal session. Yes, that means the workstation connections to Navison using the Fin.EXE (1 session), Then open’s Excel or Word etc (1 additonal session). That’s the total of two session. (I know, don’t agrue). 11. Perform a simple MSQUERY (Word Merge document) or (Excel connection link). If you don’t know how to do this. Use the sample Navision documentation. Its simple to use. Good luck.