Hi, has anybody expiriences with using ADO as Automation Server in Navision 3.70? I would like to connect a SQL Server with ADO from Navision 3.70 native database to exchange data. Or has anybody another idea? Thanks a lot! Nick
Hi Andreas, I have used the ADO automation control before. The data source was not MS SQL Server but that’s beyond the point. Have you already started? What kind of help do you need?
we did ADO for 2.6 a while ago and it worked very well. If the data you are looking to exchange is one of the 16 Available Commerce Gateway XML Schemes, you can use that with BizTalk, although that may be much more expensive.
Hi, we use ADO to copy data from Navision (3.70) native database to a MSSQL database. This works pretty good. It takes about 5 minutes to copy 40000 records. There are some minor things to keep track of (for instace, when copying customer data there cannot be any apostrophes (’). But other than that it was pretty easy. Regards Daniel
quote:
Originally posted by nelson
Hi Andreas, I have used the ADO automation control before. The data source was not MS SQL Server but that’s beyond the point. Have you already started? What kind of help do you need?
Hi Nelson, no, the project starts in may this year. It’ll be great if you could send me a code sample or a nearer description about the parameters of ADO. Thank you very much! Andreas
The parameters/methods/properties, etc. and the complete reference for ADO can be found at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoapireference.asp I can post some code samples at the end of today.
Hi Andreas, Well, I was just about to post some sample code here but I meanwhile stumbled across this sample that Christian Buehl posted today: http://www.mibuso.com/forum/viewtopic.php?t=2407 How appropriate [:)]