Is it possible to save / extract data from a MS SQL database 2008 using lookout 6.2?

[SQL2008 and Lookout 6.2]

Is it possible to save / extract data from a MS SQL database 2008 using lookout 6.2?

 

Now a days we are saving / extracting data in a excel spreadsheet, but we would like to do that using a database because it is better.

[Ryan.S]

You can use ODBC connection to work with SQL Server database.

Use SQLExec object to execute the SQL statement. Here is a KB about the SQL statement.

http://digital.ni.com/public.nsf/allkb/4ADEEA04CD24AE0B862565E20002A16F?OpenDocument

To write data to spreadsheet is more straightforward because Lookout has built-in spreadsheet object. But you need to write SQL statement by yourself to interact with other database.

To read the data back is the same way. Just use "select" SQL statement to query. You can use Datatable object to query.

The "Data Source" can be "DSN = data source name;". The data source name is configured in Control Panel->Administrative Tools->Data Sources(ODBC).