Remoting odbc data source
Author: roger.wallin@abilita.fi (rogerw)
Hi! This is probably an easy/strange question for those using urouter/userver every day. In Uniface, having a typical client installation and all database accesses directly in the form, using retrieve and store going through the read and write trigger of the form. Furthermore a local client asn-file, using a local odbc data source "MyDataSource", installed on every client pc to connect directly to the database. CLIENT.ASN $MSS MSS:MyDataSource:mydatabase|myuser|mypassword $DEF $MSS I've understood that you should be able to move the client odbc data sources to a server without doing any changes to the forms (not having a typical three-tier Uniface application), ie. having the odbc data source on just one server machine. Does anyone have experience from this kind of installation, slow or fast? What do you need on the server, just urouter that redirects to the database or "urouter + userver" or how is it achieved in a simple way? Sorry, Im not an Uniface server expert! Any comments appreciated. Regards RogerW.