Intouch and MSAccess connection

Hi all

I have only Intouch 9.5 installed (no sql in start menu) on my PC XP SP2. is it possible to retrive data from msacess and dispaly as tagvalue in intouch.
How its works? any detail procedure?

Thanks

I hope this helps as I do not know Intouch, but I assume it has a script function(Be it JVS or VBS)

Using an OLE connection you could retrieve data EG:

'Create connection with access server
Set objConn = CreateObject("ADODB.Connection") 'Create object for sql connection
objConn.ConnectionTimeout = 25
objConn.Open "Provider=microsoft.jet.oledb.4.0;data source=C:\YourDB;"

'Create the command send to server
Set objCMD = CreateObject("ADODB.Recordset") 'Create cammand object for Acces querie
Set objCMD.ActiveConnection = objConn 'Pointer to show cammand which connection to use
objCMD.Open "Select* from [Your_table] where (ColumbName = '" + Value + "')"
' objCMD.CommandType = 1 'adCmdtext



Your_Internal_Tag = objCMD("Value")


objConn.Close
Set objConn = Nothing
Set objCMD = Nothing
Set objParams = Nothing



Remember This is only an example script

Thanks LestatZA

I have done it from Intouch only. Procedure is same as defined by you, but all inbuilt functions.

thanks

Can you do the same with a SQL server?

automation123 said:

Can you do the same with a SQL server?

Click to expand...

Yes you could use the same system.