FiveTech Software tech support forums

... := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic // Init xCONNECT := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xDATABASE+';User Id='+xUSERID+';Password='+xPASSWORD aImages := Directory( cCft + "*.*" ...

... lDebug := IF(EMPTY(cDebug),.F.,.T.) cRoot := "" cTitle := "CDM Web Freight Data Integration" xPROVIDER := "SQLOLEDB" xSOURCE := "x" xDATABASE := "x" xUSERID := "x" xPASSWORD := "x" // Init... ...

... SQL string... cSqlLoad := "SELECT * FROM vessels WHERE Active=1 ORDER BY [DateCreated] DESC" TRY oSqlLoad:Open( cSqlLoad, 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xDATABASE+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oError MsgInfo("Failed to Connect ...

... SQL string... cSqlLoad := "SELECT * FROM vessels WHERE Active=1 ORDER BY [DateCreated] DESC" TRY oSqlLoad:Open( cSqlLoad, 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xDATABASE+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oError MsgInfo("Failed to Connect ...

... := 1 // opendkeyset oSqlSeek:CursorLocation := 3 // local cache oSqlSeek:LockType := 3 // lock opportunistic // Init... xSQL := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD // Message.. oSay:SetText( "Checking ...

... , ; cEol := CHR(13) + CHR(10) , ; cSource := "c:\xml\inbox\" , ; cHistory := "c:\xml\inbox\history\" , ; xPROVIDER := "SQLOLEDB" , ; xSOURCE := "9.9.9.9" , ; xDATABASE := "DB-NAME" , ; xUSERID := "USERID" , ; xPASSWORD ...

Hello, I am having a problem connecting to Microsoft Windows 2008 R2 server via Windows Authentication using the following string. xPROVIDER := "SQLOLEDB" xDATABASE := "MobileFrame" , ; xSOURCE := "192.168.1.11" xUSERID := "DOMAIN\UserName" xPASSWORD ...

... ( cLocation+"\Table.dbf" via "DBFCDX" Shared or if you use Ms Access .. assuming your .mdb or accDb is in the same folder ... xPROVIDER := "Microsoft.Jet.OLEDB.4.0" xSOURCE := cLocation+"\Groom.mdb" // legacy ms access xPASSWORD := "xxxxxxxxx" ...

... oSql:LockType := 3 // lock opportunistic // Set SQL string... cSql := "SELECT * FROM SalesOrderHeader" TRY oSql:Open( cSql, 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oError MsgWait("Failed to Connect ...

... // local cache oSql:LockType := 3 // lock opportunistic // Set SQL string... cSql := "SELECT * FROM mr" TRY oSql:Open( cSql, 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xDATABASE+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oError MsgWait("Failed to Connect ...

... := 1 // opendkeyset oRsProj:CursorLocation := 3 // local cache oRsProj:LockType := 3 // lockoportunistic TRY oRsProj:Open( cSQL,'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oErr MsgInfo( "Error in Opening PROJECT ...

... := 1 // opendkeyset oRsProj:CursorLocation := 3 // local cache oRsProj:LockType := 3 // lockoportunistic TRY oRsProj:Open( cSQL,'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oErr MsgInfo( "Error in Opening PROJECT ...

... := 3 // local cache oRsuser:LockType := 3 // lockoportunistic cSQL := "SELECT * FROM USERINFO order by USERID" TRY oRsuser:Open( cSQL,'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD ) CATCH oErr MsgInfo( "Error in Opening USERINFO ...

... the source .. I do have a tnsnames.ora file .. I think the tns name is 'efis.world' .. The schema is 'suntrack' .. so my guess will be to use : xPROVIDER := "MSDAORA" xSOURCE := "EFIS.world" xUSERID := "me" xPASSWORD := "mypassword" oRs := TOleAuto():New( "ADODB.Recordset" ) oRs:CursorType := ...

... being the server name .. in this example the EFIS is that actual name of the database that resides on the server name EQCAIX3 .. Rick Lipkin xPROVIDER := "MSDAORA" xSOURCE := "EFIS" xUSERID := "SUNTRACK" xPASSWORD := "goefis10" oRs := TOleAuto():New( "ADODB.Recordset" ) oRs:CursorType := ...