OCX for Navision Fincacials 2.50 (no SQL) for access to Micr

kszymanski

Hello,

i'm looking for a ocx that enables me to read data
from Microsoft SQL-Server within a C/AL Report/Codeunit.

Exists there one (or more <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> ?

I know that i can use the command-line executable to
create a textfile ( SHELL() ) and read the created
result-textfile. But in think this is a 'not so clean'
solution.

Thanks for your help.

Best regards,
Kai Szymanski.

John_Tegelaar

Create a variable of the type Automation and assign the Microsoft AxtiveX Data Objects Library to it. This allows you to set up a connection to an ODBC driver for access to a plethora of databases. The driver for SQL access is provided as standard ODBC by MS.

Although the OCX Data Control might look attractive, don't try to use it. Others have done that already and gave up.

John