Connect a different database schema(different machine) from livelink oscript

mriganka_majumdar_(geairc01user10_-_(deleted))

How can I create a connection to a different database than that of Livelink from oscript module.I want to retrieve or store some data in custom tables in different database

Martin_Gäckler

Here is a function, that we are using:/* Liefert eine Connection zur MRAccessDB Problems: Author: Martin G?ckler param CAPILogin dbLogin G?ltige login session return Boolean Assoc.OK Error flag String Assoc.Error Error text CAPIConnect Assoc.mrAccessDBConn Connection Handle String Assoc.mrAccessSchema MrAccess Schema*/ function Assoc GetMRAccessConnFromLogin( CAPILogin dbLogin ) CAPIConnect mrAccessDbCon assoc result String MrAccessDb String MrAccessUser String MrAccessSchema String MrAccessPw // Get Connection to MRAccessDB MrAccessDb = CAPI.iniGet( dbLogin, "SmartDir", "MrAccessDb" ); if !IsDefined( MrAccessDb ) || IsError( MrAccessDb ) MrAccessDb = "" end MrAccessUser = CAPI.iniGet( dbLogin, "SmartDir", "MrAccessUser" ); if !IsDefined( MrAccessUser ) || IsError( MrAccessUser ) MrAccessUser = "" end MrAccessSchema = CAPI.iniGet( dbLogin, "SmartDir", "MrAccessSchema" ); if !IsDefined( MrAccessSchema ) || IsError( MrAccessSchema ) MrAccessSchema = "" end if( MrAccessSchema > '' ) MrAccessSchema = MrAccessSchema + '.' end MrAccessPw = CAPI.iniGet( dbLogin, "SmartDir", "MrAccessPw" ); if !IsDefined( MrAccessPw ) || IsError( MrAccessPw ) MrAccessPw = "" end if MrAccessPw > '' MrAccessPw = Str.Decode( MrAccessPw ); end if( MrAccessDb > '' && MrAccessUser > '' ) mrAccessDbCon = Capi.AllocConnect( CAPI.CT_ORACLE, MrAccessDb, "", MrAccessUser, MrAccessPw ); if !IsDefined( mrAccessDbCon ) || IsError( mrAccessDbCon ) result.ErrMsg = "Cannot login to MR Access"; result.ApiError = mrAccessDbCon; result.OK = false else result.mrAccessDBConn = mrAccessDbCon result.mrAccessSchema = MrAccessSchema result.OK = true end else result.ErrMsg = "Mr Access not configured."; end return resultendHope this helps