Rao, ado functions are great for accessing SQL, thank you! Import from dbf, export and browse are ok and it run very fast. Now I need two examples, if possible: 1) how can i add records to an existing table of a database SQL in "batch" mode (not interactively with browse and similar)? 2) h...
I'm testing ADO functions for accessing to a database of SQL SERVER. Ado1.prg and ado2.prg run ok! Now i need to export a table to a dbf, so i'm trying to use FW_ADOExportToDbf function. At Runtime, i receive msgbox error "DBFCDX needs to be linked" , but i already have DBFCDX.LIB linked i...
Connecting to Microsoft SQL server using FWH simplified ADO functions. FWH provides a single line function FW_OpenAdoConnection( <parame,,,> ) to connect to any server, MSSQL, ORACLE, MYSQL,MSACCESS, etc. In case of MSSQL, the server can be configured to login using Windows Authentication (al...
Jose, i'm using latest FWH release: 1805. And i need native support for SQL SERVER, not for "MySQL". I access to my database SQL via ODBC regularly, but today the best way is to access via ADO. But how? I need just an example of native connection to SQL SERVER database, avoiding to configu...
The example inside mariainv.prg seems to work only with "MySQL Server", isn't it? Instead, i need to connect to an SQL SERVER database. I try compiling the form of mariainv "own server" with cHost,cuser,cpassword,cdb variables but alwais receive an error like this: "2003 Ca...
The example inside mariainv.prg seems to work only with "MySQL Server", isn't it? Instead, i need to connect to an SQL SERVER database. I try compiling the form of mariainv "own server" with cHost,cuser,cpassword,cdb variables but alwais receive an error like this: "2003 Can...
Antonio, two questions: 1) i'm using FWH version 15.06. I have to upgrade my version for ADO support in FWH ? 2) Superflous i think, but just to be sure: is it ok and recommended with databases "SQL Server" too?