you must repalce connect with string get from
http://www.connectionstrings.com/
SQLRDD IS a Simple SQL interface that implements accessing SQL query result
via RDD
interface. It is not intended to be replacement for "transparent" move
of DBFCDX application to SQL world. SDD is acronym for Sql Database Driver.
RDD is used to implement access
of different database formats like DBF, SDF, etc. SDD is used to implement
access of different SQL databases. Every SQL server (MySQL, PostgreSQL,
etc.)
has a corresponding SDD. SDD driver implements a specific part of data
exchange interface between SQLBASE and SQL server.
//libs=rddsql sddodbc
REQUEST SDDODBC, SQLMIX
#define RDDI_CONNECT 1001
PROC main()
RDDSETDEFAULT( "SQLMIX" )
SET( 4, "yyyy-mm-dd" )
? "Connect:", RDDINFO( RDDI_CONNECT, { "ODBC", "DBQ=" + hb_DirBase() +
"\..\..\..\hbodbc\tests\test.mdb;Driver={Microsoft Access Driver (*.mdb)}" }
)
? "Use:", DBUSEAREA( .T.,, "select * from test", "test" )
? "Alias:", ALIAS()
? "DB struct:", HB_VALTOEXP( DBSTRUCT() )
INKEY( 0 )
BROWSE()
INDEX ON FIELD->SALARY TO salary
DBGOTOP()
BROWSE()
DBCLOSEAREA()
RETURN
2009/6/4 Horodyski Marek (PZUZ) <[email protected]>
> >-----Original Message-----
> >From: Mindaugas Kavaliauskas [mailto:[email protected]]
> >Sent: Thursday, June 04, 2009 4:27 PM
> >To: Harbour Project Main Developer List.
> >Subject: Re: [Harbour] hash() in harbour
> >
> >> Now you can use LetoDB, SqlLite, Postgress, MySql, Firebird ...
> >> (
> >> but Oracle still not :(, in work I have only Oracle. With ADO I not
> >> can try because reported
> >
> >
> >Do you have possibility to try sddodbc and Oracle?
>
> Maby. What is sddodbc ?
> I use Oracle with xHarbour.095 via Mediator and/or ADO.Recordset, app
> linked with bcc.
>
> With Harbour and OW (I do not want to use BCC because for example of
> small numbers is the GPF)
> I don't can compile olecore.c. I'm try switch to use MingGW - work in
> progress :)
> Have you any small exeample how can I use 'select * from table' via
> sddodbc ?
>
> Regards,
> Marek Horodyski
> _______________________________________________
> Harbour mailing list
> [email protected]
> http://lists.harbour-project.org/mailman/listinfo/harbour
>
--
Massimo Belgrano
Analisi e sviluppo software per Lan e Web - Consulenza informatica -
Formazione
Delta Informatica S.r.l. http://www.deltain.it/ +39 0321 455962
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
