connect=<dsn>

Create a Connection object.

You need to provide the name of the ODBC Driver.

If the connection is active by the time you create the Datastore than the Datastore will use this connection
declare=mydts=ue_datastorevalues

mydts=connect=beas portal

mydts=updatetable=ocrd

mydts=select=* from ocrd

mydts=setitem=cardname=myName

message=<mydts.cardname>

mydts=update

mydts=disconnect

destroy=mydts

Example Connect with a Access-Table

(ODBC-Driver: myodbc, Filename c:\temp\test.mdb)

mydts=connect=DSN=myodbc;dbq=c:\temp\test.mdb

mydts=sql=select count(*) from "itemtable" where "ItemCode"='<mydata>'

messagebox=Entry found: <value>

disconnect

Closes the SQL Connection

sql=select/update/delete/insert