FiveTech Software tech support forums

... oCone:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ; "server=" + cServer + ; ";database=" + cDatabase + ; ";uid=" + cUser + ; ";port=" + cPort + ; ";pwd=" + cPass ) oRecordSet := TOleAuto():New("adodb.recordset") oComando ...

... how it work while all is Windows API --- have read in German Xbase++ Forum Header-Eintrag "Message-ID:". Den setzen wir auf eine UID mit angehängtem Domain-Namen, also so: Message-ID: <821f7e56-8871-4657-ac3b-1504fbbd0456@mmorthosoft.de> but i don´t know "where" ...

... + ':\\' + CURDIR()+";" LOCAL lConnect := .f. LOCAL cDriSql := "" cDriSql := "DRIVER={MySQL ODBC 8.0 Unicode Driver};UID=root;PASSWORD=xxxx;PORT=3306;SERVER=localhost;DATABASE=restaurate; OPTION=3" *"DRIVER={MySQL ODBC 3.51 Driver}; SERVER="+cDirSer+"; ...

... uid=1322528210&pub=5&eid=zK2km5ubmtjUd6jWps6j1KNemJ%2Bj&bs=1445&bsc=1032&gtw=2&price=39.00&duration=32d&tprice=0.00&tduration=5d&lp_id=1917&e_gaid=&e_clickid=7037571894271794937&site=199&pw_uid=1322528210 ...

... oCone:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ; "server=" + cServer + ; ";database=" + cDatabase + ; ";uid=" + cUser + ; ";port=" + cPort + ; ";pwd=" + cPass ) xRfc:="XAXX010101XXX" If Empty(oCone) MsgAlert(" No ...

... uso mysqldump, ex: cComando := oApp:cDir_001+"mysqldump --host="+oApp:IpSQL+" --port="+oApp:SQLPort+" -u "+oApp:UID+" -p"+oApp:PWD+" --all-databases > "+oApp:BackupPath+"\backupD"+strtran(dtos(Date()), "/","")+"T"+Strtran(time(), ...

... oCone:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ; "server=" + cServer + ; ";database=" + cDatabase + ; ";uid=" + cUser + ; ";pwd=" + cPass ) If Empty(oCone) MsgAlert(" No se Pudo Establecer la Conexion Con La Base De Datos..","Atencion") ...

... make sure there is an "Oracle in InstantClient_12_2" and Voila ! cCon:="Driver=Oracle in Instantclient_12_2;dbq=localhost:1521/XE; Uid=hr;Pwd=hr" // Adodb using ODBC HB_SETCODEPAGE("ESMWIN") to void Ñs and specail char issues. Thank You again and regards

... a su valiosa ayuda ya logre conectarme a la base de datos firebird mediante oCat:ActiveConnection = "Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;DbName=d:\firebird\Sae50empre01.FDB;" mediante oCat:Tables:Count() //conozco el numero de tablas oCat:Tables( i ):Name ...

otro ejemplo

oApp:ConnectionString := "Driver={SQL Server};Server=192.168.1.100;" + ;
"Trusted_Connection=no;Database=polizas" + ;
";Uid=contab;Pwd=Polizas123;"

... ODBC 1.0 Driver} Server: name or IP of the MariaDB database server. Aliases: Servername User: user name for database authentication. Aliases: UID, Password: password for database authentication. Aliases: PWD Database: default database. Aliases: DB Port: TCP/IP Port of the database server Option: ...

... to be tha same that MySQL. Thank you and sorry, I,m very clumsy with SQL, until now, I hope. Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; MySQL Specifying TCP port Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername; Pwd=myPassword; The port ...

... No funciona aWAData[ WA_CONNECTION ]:Open( "Driver=Firebird/InterBase(r) driver;" + ; "Persist Security Info=False" + ; ";Uid=" + aWAData[ WA_USERNAME ] + ; ";Pwd=" + aWAData[ WA_PASSWORD ] + ; ";DbName=" + t_cDataSource )

... *remote cConn ="DRIVER=SQL Server;SERVER=82.10.10.2,1433;UID=sa;PWD=sa2008;DATABASE=statistiche" nHnd = SQLSTRINGCONNECT(cConn,.f.) cSQL = "select * from dbo.VenditeFasceOrarie where DataFasciaOraria=?PData" ...

... oCone:Open( "DRIVER={MySQL ODBC 3.51 Driver};" + ; "server=" + cServer + ; ";database=" + cDatabase + ; ";uid=" + cUser + ; ";pwd=" + cPass ) If Empty(oCone) MsgAlert(" No se Pudo Establecer la Conexion Con La Base De Datos..","Atencion") ...