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

datastore.connect=myDsn;Uid=myUsername;Pwd=myPWd;

More about the DNS String you can find in the documentation of used ODBC driver.

 
instance datastore mydts
mydts=connect=myODBCDriver
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

All SQL commands, if supported from the database