Is it possible to connect a non Baan SQL-server in a programscript/reportscript ??

In Baan only the tables defined in Baan's data dictionary and existing in same SQL db instance , can be accessed.

you can of course create scripts containing sql-statements within a Baan application (seq.open / puts / close) and start these scripts with the shell() function on OS level (still in the same program). If these scripts redirect their output to files, you can read these files (still in the same program) to use the data. Admittedly not smooth ... but if you can't live without it, you can do it.

regards

Norbert

yeah. I agree with norbert. It depends on your necessity to access the non baan sql server. If you just need some data, you can export to flat file from the database and use baan script to fetch the data from this file, like many other's do. You might have to consider other options to get things done the way you want it to.

-regards,
suresh

Refer to the thread -

Accessing External Tables (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6965&highlight=sql)

Please use search option to refer to the already discussed topics.