navision and sql server 2000

Business Central/NAV Developers Forum
1

is it possible to send info from navision 3.6 directly to sql server 2000? if it is, where can i find out how? thanks, trint

2

It in the online help. Basically just create a table in Navision that is a duplicate of the SQL table, and set “LinkedObject” to Yes.

3

Whats is that the “LinkedObject” property do exactly. Prince.

4

Again. It’s in the online help: LinkedObject Use this property to link to SQL Server objects. Applies to Tables in the Microsoft SQL Server Option for Navision Attain. Comments When you set the LinkedObject property to Yes, the LinkedInTransaction property becomes available. --------------------------------------------- LinkedInTransaction Use this property to read and modify data from linked server data sources, such as Excel, Access or another SQL Server. Applies to The Microsoft SQL Server Option for Navision Attain. Comments This property is available when you have set the LinkedObject property to Yes. You must set the LinkedInTransaction property to No when the Navision Attain table description refers to an object outside the current database or on a linked server. The access to linked server data sources is not under Navision Attain transaction control. This means that if a Navision Attain transaction is aborted, any changes that were made during this transaction to a linked object that is outside the current database or on a linked server will remain in effect. More information: The manual Application Designer’s Guide.

5

My understanding is that you have to be running the SQL (not native) version for this to work. Is that correct?

6

Correct