FiveTech Software tech support forums

... is NOT, is there a way to reestablish connection? Here is my sample code establishing connection. oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABASE2+","+xUSERID+","+XPASSWORD, .T. ) if oCn == nil ? "Failed to connect to Server" return ...

... 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 + "*.*" ) FOR nX1=1 TO LEN(aImages) ...

... lDebug := IF(EMPTY(cDebug),.F.,.T.) cRoot := "" cTitle := "CDM Web Freight Data Integration" xPROVIDER := "SQLOLEDB" xSOURCE := "x" xDATABASE := "x" xUSERID := "x" xPASSWORD := "x" // Init... SET DATE FORMAT TO 'mm/dd/yyyy' SET ...

... := "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 to the Database" ...

... := "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 to the Database" ...

... 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 for CBP ACE AES Response Messages ...

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

... SQL 2012. Function did import 105 records (rows) before error was received. Here is my connection string: cSqlCon = 'PROVIDER=SQLNCLI11;Server='+xSOURCE+';Database='+xDATABASE+';Trusted_Connection=yes;' How do I resolve this? Application =========== Path and name: C:\cdm\winsql\cdmsql.exe (32 ...

... 2008 R2 server via Windows Authentication using the following string. xPROVIDER := "SQLOLEDB" xDATABASE := "MobileFrame" , ; xSOURCE := "192.168.1.11" xUSERID := "DOMAIN\UserName" xPASSWORD := "Password" xSQL := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial ...

... 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" xSTRING := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Jet ...

if I used function
oCon := FW_OpenAdoConnection( xSOURCE + "," + xPASSWORD)

the database opened good, but the function FW_OpenRecordSet can't open the table

cSQL:="select idklienta, nazwa, adres, nip from Klienci"
oRes := FW_OpenRecordSet( oCon, cSQL )

best regards
kajot

Please use:
oCon := FW_OpenAdoConnection( { xSOURCE, xPASSWORD } )

or

oCon := FW_OpenAdoConnection( xSOURCE + "," + xPASSWORD)

thanks for answer but if I use cPath := cFilePath( ExeName() ) xSOURCE := cPATH+"waga.mdb" xPASSWORD := "123456" oCon := FW_OpenAdoConnection( xSOURCE,xPASSWORD) cSQL:="select idklienta, nazwa, adres, nip from Klienci" oRes ...

... 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 to the Database") ...

... := 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 to the Database") ...