FiveTech Software tech support forums

Some provider block .ru.

... (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: oRsWrk (0x80004005): Microsoft OLE DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet oRsWrk and oRsDet are RecordSets. You should not use recordsets. Use table ...

... (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: oRsWrk (0x80004005): Microsoft OLE DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet with this code          DO WHILE ! oRsDet:EOF()  ...

... we are made a change in the server and we have changed mysql by sql server and we have follow problem: [CODE] oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" TRY ...

... volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" TRY ...

... volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" TRY ...

... for 8 hours, FW built-in library automatically reconnects if the user attempts to communicate with the server. 1) Contract with a good service provider. 2) Use FW built-in library which provides automatic reconnection feature transparently. My advice is to connect at the beginning of the application ...

hi,

thx for Answer.

i do have already CursorLocation and FASTEDIT in Sample ...

what do you mean with "inline edit" , how

but "save" seems not work

Try inline edit.

Any valid ADO recordset is recognized as RecordSet.

To start with just use

Code: Select all  Expand view

XBROWSER oRs FASTEDIT

Try to add CursorLocation of connection object also as adUseClient.'

hi, as i have no "real" OLEDB Driver for PostgreSQL i try to use PMDAPGS.DLL i can XBOWSER / XBROWSE PostgreSQL Table but "save" seems not work have found out that PMDAPGS.dll was "identify" as "XBR" when try to "save" PostgreSQL Data but i need METH...

...  EDITVARS cServer, cDatabase, cUserName, cPassword TITLE "PMDAPGS" + " : Server login"   try      oCn:Open( "Provider='PMDAPGS';Server='"+cServer+"';Database='"+cDataBase+"';User='"+cUsername+"';Password='"+cPassword+"'") ...

Can I see your code for opening ado connection and recordset?

... this is right   EDITVARS cServer, cDatabase, cUserName, cPassword TITLE "PMDAPGS" + " : Server login"   oCn:Open( "Provider='PMDAPGS';Server='"+cServer+"';Database='"+cDataBase+"';User='"+cUsername+"';Password='"+cPassword+"'") ...

If you want to see all properties of any connection object:

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( <your-connectionstring>, .t. )
if oCn == nil
   ? "Fail"
else
   XBOWSER oCn  // this shows all properties
   // other works
   oCn:Close()
endif

It has no effect on Opening ADO connctions, Opening RecordSets and using the recordsets in any manner we need. hi, ok ... but why "is"   oCn:Properties( "DBMS Name" ):Value and/or   oCn:Properties( "Extended Properties" ):Value Empty() ... :?: it is &qu...