Search found 71 matches: fiveodbc

Return to advanced search

Re: Where i can find "FiveODBC Documentation"

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...
by max
Wed Apr 24, 2019 1:48 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

Sorry, I solved by adding REQUEST DBFCDX that was missing.
by max
Fri Jan 11, 2019 6:02 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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...
by max
Wed Jan 09, 2019 9:10 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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...
by nageswaragunupudi
Sun Aug 26, 2018 10:18 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

A code sample (not working): // ADO definitions#define adOpenForwardOnly 0#define adOpenKeyset      1#define adOpenDynamic     2#define adOpenStatic      3#define adLockReadOnly        1#define adLockPessimistic     2#define adLoc...
by Enrico Maria Giordano
Sun Aug 26, 2018 11:03 am
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

You have to use a connection string like this:

Code: Select all  Expand view
Provider=sqloledb;Data Source=<ipaddress>;Initial Catalog=<databasename>;User Id=<userid>;Password=<password>


EMG
by Enrico Maria Giordano
Sun Aug 26, 2018 11:00 am
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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...
by max
Sun Aug 26, 2018 10:16 am
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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...
by admsoporte
Sat Aug 25, 2018 11:36 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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...
by max
Sat Aug 25, 2018 6:55 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

Max,

Many thanks

Please review fwh\samples\mariainv.prg

There you have an ADO full working example :-)
by Antonio Linares
Fri Aug 24, 2018 2:06 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

Ok Antonio: upgrade order done.

Bye
by max
Fri Aug 24, 2018 12:05 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

Max,

1) Yes

2) Yes
by Antonio Linares
Fri Aug 24, 2018 10:57 am
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

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?

Thank you
Max
by max
Fri Aug 24, 2018 10:35 am
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893

Re: Where i can find "FiveODBC Documentation"

Max,

FWH current ADO support is the way to go:

viewtopic.php?f=3&t=32657
by Antonio Linares
Thu Aug 23, 2018 2:39 pm
 
Forum: FiveWin for CA-Clipper
Topic: Where i can find "FiveODBC Documentation"
Replies: 15
Views: 12893
Next

Return to advanced search