FiveTech Software tech support forums

1. Create a SQL dump file from your phpBB forums: mysqldump --user=username --password=YourPassword database_phpbb > dumpfile.sql 2. We "clean" the dump file using this code: #include "FiveWin.ch"function Main()    local cSQL := hb_memoRead( ...

It works. You just forgot to set the password:

LOCAL cPassword := "yourpassword"

And you didn't link the correct libs:

Code: Select all  Expand view

tipssl.lib
libssl.lib
libcrypto.lib

And last, where are the dlls?

EMG

... // user authentication should use your // email address as the user name. oServer.User = "myid@mydomain"; oServer.Password = "yourpassword"; // Set 587 port oServer.Port = 587; // detect SSL/TLS connection automatically oServer.ConnectType = SmtpConnectType.ConnectSSLAuto; ...

... the following string: Driver={MySQL ODBC 5.3 Unicode Driver};Server=YourServersIP;Port=3306;Database=YourDatabseName;User=YourUserName;Password=YourPassword;Option=3;) Kind regards, Pieter

... := "Driver={MySQL ODBC 5.3 Unicode Driver};Server= YourServersIP ;Port=3306;Database= YourDatabseName ;User= YourUserName ;Password= YourPassword ;Option=3;" Should we install an ODBC driver for MySql , witch one , 32 or 64 bits ? Yes, You should install ODBC Driver for MySQL

Hello Stefan,
LOCAL cPW := "YourPassword"

Look at the pw() function in:
viewtopic.php?f=3&t=25390&p=138255#p138300

Best regards,
Otto

... another . Both I know and want to accurate - you are talking about something that : cConnectionString := "DSN= odbc name ;UID=YOURUSERID;PWD=YOURPASSWORD;" ? With best regards ! Simplier than that... Install the ODBC SQLITE CLIENT.. and that's all, no need to configure DSN or anything. ...

... another . Both I know and want to accurate - you are talking about something that : cConnectionString := "DSN= odbc name ;UID=YOURUSERID;PWD=YOURPASSWORD;" ? With best regards !

... the connection string to "Driver={MySQL ODBC 5.1 Driver};Server=YourServerIP;Port=3306;Database=YourDataBaseName;User=YourUserName;Password=YourPassword;Option=3;" The Error Mysql .prg Application =========== Path and name: C:\ADO2241\samples\mysql.exe (32 bits) Size: 1,517,056 bytes ...

... "Excel.Application" ) LOCAL oWorkbook := oExcel:Workbooks LOCAL oSheet := oExcel:ActiveSheet ... savefile := oWorkbook.SaveAs( fileXL, ,"YourPassWord" ) ... RETURN NIL

... the code taken from your example. ****************** Function LS_odbc() ****************** Local oODBC := TOdbc():New "DsnEntry", "YourName", "YourPassword") If !oOdbc:lSuccess oOdbc:ShowErrorList("ODBC session not successfully initialized, aborting...") oOdbc:End() return nil Endif *oDbf := ...