Below is the connect string I use from within my code.

CREATE connection COE ;
connstring 'DSN=MS Access 97 Database;DBQ=&gcDBLocat;DefaultDir=&gcDefaDir;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;UID=admin'


If this is not correct, what should I do to fix my problem?