FiveTech Software tech support forums

... datos ) oCone :=tOleAuto():new("ADODB.connection") oCone:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ; "server=" + cServer + ; ";database=" + cDatabase + ; ";uid=" + cUser + ; ";port=" + cPort + ; ";pwd=" + cPass ) xRfc:="XAXX010101XXX" ...

Hi Enrico,

Please, post a example for fill string cServer and cUser

Thanks Enrico.

post an string example of cserver, cuser and cpass fill...

I do not know how to fill this variables.

Hi enrico,

Your function works with gmail?

What string for cServer?

cUser := "acessosoft@gmail.com"
cPassword := "acess123"
cServer := "gmail.com"

It this?

Using FWH Ado functions simplifies the work. oCn := FW_OpenAdoConnection( { "MYSQL", cServer, cDatabase, cUser, cPassword }, .t. ) if oCn == nil ? "Fail" return nil else ? "Connected" endif oRs := FW_OpenRecordSet( oCn, "select * from ...

... programas a SQL ya logré conectarme con esto: #include "FiveWin.Ch" #Include "Ado.ch" FUNCTION ConnServer() LOCAL oCone Local cServer := "localhost" //Ubicación del servidor Local cUser := "root" // usuario Local cPass := "" // password del usuario ...

... oCfg := CREATEOBJECT( "CDO.Configuration" ) oCfg:Item( "http://schemas.microsoft.com/cdo/configuration/smtpserver" ):Value := cServer ¿Qué me está ocurriendo? ¿Por que me da error al crear el objeto/usar el método? ¿Se necesita algo 'especial' para usar CDO? ¿Se debe 'activar' ...

... = TIPClientPOP():New( "pop://" + STRTRAN( cUser, "@", "&at;" ) + ":" + cPassword + "@" + cServer )         msginfo("STE1")         IF EMPTY( oCli ); BREAK; ENDIF         msginfo("STEP2")         oCli:oUrl:cUserid = STRTRAN( ...

... NetErr(<lNewError>)->lError NetName()->cWorkstationName NetPrinter()->lIsNetworkPrinter NetRedir(<cLocal>,<cServer>,[<cPassword>],[<lShowError>])->lSuccess NetRmtName(<cLocal>)->cRemote Network()->lIsNetwork NextKey()->nInkeyCode ...

Maurizio wrote:I Use

oDSN := TDSN():Create( cODBC, "mastroODBC",cDbName ,cServer, cUser,1, 'C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll', val(nPort), cPassword )

Maurizio
http://www.nipeservice.com

Thank you so much, Maurizio. It's the one that I need. Where is TDSN Class?

I Use

oDSN := TDSN():Create( cODBC, "mastroODBC",cDbName ,cServer, cUser,1, 'C:\Program Files (x86)\MySQL\Connector ODBC 3.51\myodbc3.dll', val(nPort), cPassword )

Maurizio
www.nipeservice.com

... codigo #include "FiveWin.ch" //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cDatabase := "SBODemoUS" local oCn, oRs, aTables, cTable oCn := FW_OpenAdoConnection( { ...

... manera: #include "FiveWin.ch" //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" ...

... asi #include "FiveWin.ch" //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" ...

... Y este es mi codigo #include "FiveWin.ch" //----------------------------------------------------------------// function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" ...