FiveTech Software tech support forums

... tabla INDEX table), sino que uso las sentencias sql, puro y duro sql. nError:=oSql:Execute( "select * from clientes",.t.,.t.,,"MYUSER" ) funciona en forma similar que ado pero en lugar de cursores en memoria que es la forma de ado de retornar las consulta, tengo los ...

... 2 #define HTTPREQUEST_SETCREDENTIALS_FOR_SERVER 0 #define HTTPREQUEST_SETCREDENTIALS_FOR_PROXY 1 cProxi:= "172.15.5.1" cUserName := myuser cPassword:= mypassw nProxyPort:= 8080 cProxyNo := "*.yimg.com" oHttp := CreateObject("winhttp.winhttprequest.5.1") Try if ...

... := "Provider=PostgreSQL OLE DB Provider;"+; "Location=mydatabase;"+; "Data Source=www.xxxxxx.co;"+; "User ID=myuser;"+; "PORT=5432;"+; "Password=mypassword;" if oCon == nil oCon := TOleAuto():new("ADODB.Connection") oCon:ConnectionString ...

... Rick Lipkin Rick, Thanks for your example, but with Provider=MySQLProv;Data Source=pla;User Id=myuser;Password=mypassword; I get also an error but {MySQL ODBC 5.1 Driver};Server=127.0.0.1;Port=3306;Database=pla;User=myuser;Password=mypassword;Option=3; ...

... REQUEST ADORDD function Main() USE test00 VIA "ADORDD" TABLE "ACCOUNTS" MYSQL ; FROM "www.freesql.org" USER "myuser" PASSWORD "mypass" Browse() USE return nil cuando compilo me da este error: Error: Unresolved external '_HB_FUN_HB_ADOSETTABLE' ...

Try this, ConnectionString := "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Port=3306;Database=mydb;User=myuser;Password=mypassw;Option=3;" The below given code to update a recordset is working fine for me TRY   oRecSet:= CreateObject("ADODB.RecordSet")CATCH ...

... ODBC 5.1 Driver" and connection string is : cConnectionString := "Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=mydb; User=myuser;Password=mypassw" If I use this connection string in your file , and modify the Select statement to work in my DB, I get the usual error: ...

Dear Anser

Here they are :

mysql: 5.0.67
odbc: mysql ODBC 5.1 driver : 5.01.06.00
cConnectString := "Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=mydb; User=myuser;Password=mypassw;Option=3"


best regards

Wzaf

Hi all ! I use ADORDD with Harbour as : USE "Mydb" VIA "ADORDD" TABLE "" MYSQL FROM "localhost" USER "myuser" PASSWORD "mypassw" QUERY ("SELECT * from MyTABLE WHERE .... ") ALIAS "" READONLY NEW and then I do a report ...

... code by Enrico but I cant get hConnect to return a value hConnect = INTERNETCONNECT( hInternet, "myIP",INTERNET_DEFAULT_FTP_PORT, "myUser", "myPass", INTERNET_SERVICE_FTP,0, 0 ) In a desktop app - I use the tip library to connect back to the same server and have no ...

... Error description: Error ADODB.Connection/0 S_OK: OPEN Args: [1] = C DRIVER={ MySQL ODBC 3.51 Driver };server=www.freesql.org;database=test00;uid=myuser;pwd=mypass. I have not tried ADORDD but used ADO If you have the option to specify the connections string then I think you should use Driver={MySQL ...

... Error description: Error ADODB.Connection/0 S_OK: OPEN Args: [ 1] = C DRIVER={MySQL ODBC 3.51 Driver} ;server=www.freesql.org;database=test00;uid=myuser;pwd=mypass Stack Calls =========== Called from: win32ole.prg => TOLEAUTO:OPEN(0) Called from: adordd.PRG => ADO_OPEN(0) Called from: => ...

... Error description: Error ADODB.Connection/0 S_OK: OPEN Args: [ 1] = C DRIVER={MySQL ODBC 3.51 Driver};server=www.freesql.org;database=test00;uid=myuser;pwd=mypass Stack Calls =========== Called from: win32ole.prg => TOLEAUTO:OPEN(0) Called from: adordd.PRG => ADO_OPEN(0) Called from: => ...

... Trate de dar la IP de la http://www.freesql.org Eg. DRIVER={MySQL ODBC 3.51 Driver};server=24.63.165.245;database=test00;uid=myuser;pwd=mypass Por favor, inténtelo de http://www.freesql.org Ping para obtener la propiedad intelectual y asegurarse de que usted no está recibiendo ...

... Error description: Error ADODB.Connection/0 S_OK: OPEN Args: [ 1] = C DRIVER={MySQL ODBC 3.51 Driver};server=www.freesql.org;database=test00;uid=myuser;pwd=mypass Stack Calls =========== Called from: win32ole.prg => TOLEAUTO:OPEN(0) Called from: adordd.PRG => ADO_OPEN(0) Called from: => ...