Hello,
 
I've figured out how to connect IRobot to an MS SQL Server Database so long as I'm connecting to an existing database.  My question is this:  once I've gotten IRobot to make the connection and then get to the screen with the XML code, can I modify the XML with new data (such as a new name for the database and any other fields I wish to modify), causing IRobot to create new databases on the fly?
 
Or will IRobot only connect to pre-existing databases?
 
Best Regards,
 
Stephen

So if I understand your response, I have to first create the database I want to use in MS SQL Server, then tell IRobot to find it and use it.  Is this correct?
 
If it is, how do I tell IRobot to find the specific database I want it to use?  Is this what I'm supposed to put in the "DBQ" field?  I'm curious, what does "DBQ" stand for anyway?
 
Thank you for your help!
 
Best Regards,
 
Stephen

Okay.  So if I put the location of the database that I want IRobot to connect to into the DBQ field, is IRobot supposed to connect to that database?  I ask because no matter what I put into the DBQ field, IRobot connects to the first database it finds, which is a system database.
 
I have tried to get IRobot to connect to other databases by entering their locations, but it will only connect to the same system database.  Am I missing something?
 
Best Regards,
 
Stephen

Attached is a quick fix for this.  It allows you to use a Dataset variable to dynamically connect to a database or a table.  
 
You still need to define a data source from menu: Design -> Define Data Sources, then follow the pages to create a data source.  (You may need to create a sampe table in the data source if no table is there).  At the last step, when you see the data source in XML format, you copy the XML data and save it in a txt file, such as 'ds_sample.txt'.  
 
In your robot, you can load and change the 'ds_sample.txt' dynamically to connect to different databases or tables.  For example, the following script code change the table name in 'ds_sample.txt' to a new name 'newtest_table' and keeps it in ds_data variable.  
 
ds_path = 'ds_sample.txt';
ds_data = readFile(ds_path);
ds_data = htql(ds_data, '<Table>:Name &replace(''newtest_table'') ');
 
 
Note the newtest_table should have a same schema as the origial sample table.  Now we can use ds_data to load data from newtest_table like the following script:  
 
ds = Dataset();
n=ds.loadData(ds_data, 'select * from newtest_table ');
 
Note that in the above ds.loadData function, you can run a create table or insert to any other table.  
 
Note that the DBQ is very different for different database.  Please use the ODBC in Control Panel to create a file DSN and test connection to an existing table to make sure it is defined properly.  
 
 

Yes, with the new version, you can create as many tables as you like.  Note you still need to run a regular "create table ..." statement through the ds.loadData() function to create a new table.   Then you need to modify the schema on the fly to query the new table.  
 
You can put a script in an Event value, where you usually put expression, then choose the ValueType as Script.