FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour FW x SQL-Server?
Posts: 44
Joined: Tue Nov 21, 2006 04:07 PM
FW x SQL-Server?
Posted: Thu Feb 22, 2018 02:34 PM

¡Hola!

FW admite SQL-Server?

Si no, tiene previsto implementar el acceso?

Gracias!

Rodrigo Melo

Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: FW x SQL-Server?
Posted: Thu Feb 22, 2018 03:01 PM

Si, busca en el foro SQL SERVER connect o algo asi

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: FW x SQL-Server?
Posted: Thu Feb 22, 2018 04:11 PM

Rodrigo

xHarbour\Harbour support ADO .. the link below is a good starting place to familiarize yourself with Sql and Ado .. Rao has done a good job using FW wrappers to simplify the connections and recordsets .. look in \source\function\Adofuncs.prg

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs

Rick Lipkin

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FW x SQL-Server?
Posted: Thu Feb 22, 2018 04:21 PM
Connecting to MS-SQL server
Code (fw): Select all Collapse
oCn := FW_OpenADOConnection( { "MSSQL", cServerName, cCatalog, cUser, cPassword }, .t. )
if oCn == nil
    ? "Connect Fail"
else
    // use connection
   // example: view all table names
   XBROWSER FW_AdoTables( oCn ) 
   oCn:Close()
endif
Regards



G. N. Rao.

Hyderabad, India
Posts: 44
Joined: Tue Nov 21, 2006 04:07 PM
Re: FW x SQL-Server?
Posted: Thu Feb 22, 2018 09:14 PM

Gracias!

Vou verificar.

Continue the discussion