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

kszymanskikszymanski Member Posts: 42
edited 2000-12-09 in Navision Financials
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.
--
Kai Szymanski
Abt. eBusiness
D. Schuricht GmbH & Co. KG

Comments

  • John_TegelaarJohn_Tegelaar Member Posts: 159
    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
Sign In or Register to comment.