zrawi Member Join Date Mar 2004 Location Riga Posts 41 Apr 25, 2005 #1 Hi, everyone! I want to collect data in database from InTouch 9.0. Can I use only MSSQL server to do it, without using the IndustrialSQL(which is expensive)? Best regards, zrawi
Hi, everyone! I want to collect data in database from InTouch 9.0. Can I use only MSSQL server to do it, without using the IndustrialSQL(which is expensive)? Best regards, zrawi
Unregistered Guest U Apr 25, 2005 #2 Yes, you will need to set up an ODBC connection to the database and use Intouch scripts to insert data into the MSSQL tables.
Yes, you will need to set up an ODBC connection to the database and use Intouch scripts to insert data into the MSSQL tables.
Mtn_Bkng_Dave Member Join Date Feb 2004 Location South Carolina Posts 130 Apr 25, 2005 #3 Are you going to have to buy MSSQL for this project?
zrawi Member OP Join Date Mar 2004 Location Riga Posts 41 Apr 27, 2005 #5 Mtn_Bkng_Dave said: Are you going to have to buy MSSQL for this project? Click to expand... I think, I wont have to by MSSQL, because a licence for one PC comes with InTouch.. Aquadevel said: Get MySQL.... Click to expand... As far as I know InTouch doesnt support MySQL.. Anyways, thank you all for your answers!
Mtn_Bkng_Dave said: Are you going to have to buy MSSQL for this project? Click to expand... I think, I wont have to by MSSQL, because a licence for one PC comes with InTouch.. Aquadevel said: Get MySQL.... Click to expand... As far as I know InTouch doesnt support MySQL.. Anyways, thank you all for your answers!
Aquadevel Member A Join Date Apr 2005 Posts 23 Apr 27, 2005 #6 Zrwci... you might be right,.. , I've been into MySQL and MS ACCESS data txfr lately. I really never 'tried' Intouch with MySQL. Was the 'cost' issue.
Zrwci... you might be right,.. , I've been into MySQL and MS ACCESS data txfr lately. I really never 'tried' Intouch with MySQL. Was the 'cost' issue.
12brich Member 1 Join Date Sep 2003 Location CA Posts 61 May 7, 2005 #7 Just use SQLAccess template/binder and scripting.
Mtn_Bkng_Dave Member Join Date Feb 2004 Location South Carolina Posts 130 May 8, 2005 #8 zrawi said: I think, I wont have to by MSSQL, because a licence for one PC comes with InTouch.. Click to expand... If you bought the full FactorySuite A2 Development package it does come with a 500 tag IndustrialSQL package along with the licensing for MSSQL. You dont have to pay for InSQL unless you plan to collect date from more than 500 tags. Dave
zrawi said: I think, I wont have to by MSSQL, because a licence for one PC comes with InTouch.. Click to expand... If you bought the full FactorySuite A2 Development package it does come with a 500 tag IndustrialSQL package along with the licensing for MSSQL. You dont have to pay for InSQL unless you plan to collect date from more than 500 tags. Dave