func Init()
	sys.add_use('System.Data.Odbc')
	blk_vars.println('private ', ((sys.get_project() == "Console") ? 'static ' : ''), 'OdbcConnection ', this.codename, ';')
	this.setfield('ex', 'ex' + this.id)
end

func doOpen(_data)
	blk.println('try {').inc()
		.println(this.codename + ' = new OdbcConnection(' + d("ConnStr") + ');')
		.println(this.codename + '.Open();')
		if(linked('onResult'))
			event('onResult', this.codename)
		end
	blk.dec().println('} catch (Exception ', this.ex, ') {').inc()
		if(linked('onError'))
			event('onError', this.ex +'.Message')
		end
	blk.dec().println('}')
end

func doClose()
	blk.println(this.codename + '.Close();')
end

func dbHandle()
  return(this.codename)
end