How to connect FiveWin with Mysql

[sajith]

Plz send the code to connect my application with mysql

[richard-service]

Hi

You can use TMySQL to connect MySQL and free.
Please search it in this Forum.

Regards,

Richard

[ShumingWang]

Hi,
www.xtech.com.cn/tmysql.prg
www.xtech.com.cn/sample1.prg
www.xtech.com.cn/sample2.prg
www.xtech.com.cn/setmysql.prg
Regards!
Shuming Wang

[anserkk]

Dear Mr.Shuming Wang

Thanks for the samples and class.

Can you paste here a copy of the CLASS TMySqlServer

The Prg TMySql which you have posted above contains only the CLASS TMySQLRow

Regards

Anser

[Daniel Garcia-Gil]

hello anserkk...

The prg TMYsql have

TMySqlRow ( 64 )
TmySqlQuery ( 290 )
TMySQLTable ( 1159 )
TMySQLServer ( 1590 )

[anserkk]

Dear MR.Daniel,

You are right, it is there. I am so sorry

Regards

Anser

[Marc Vanzegbroeck]

Hi,

In's maybe a stuppid question, but is it possible to use MySQL and still use the same commands as for DBF-file (APPE, REPL , INDEX,...) or do we need to use SQL commands?

Thanks,
Marc

[Rick Lipkin]

Marc

ADORdd has a lot of promise and was really my first stepping stone into working with the Enterprise databases .. you can download it from these forums ..

ADORdd works like any other rdd and you can use all your .dbf commands, .. take a look, read the code and kick the tires some.

Rick Lipkin

[Marc Vanzegbroeck]

Thanks Rick,

I just downloaded ADORDD and will now test it.

Regards,
Marc

[dutch]

Dear All,

I donwload ADORDD.ZIP and try MYSQL1.PRG and It show the error as following;

Code: Select all  Expand view

Application
===========
   Path and name: D:\FWH\samples\mysql1.exe (32 bits)
   Size: 1,442,816 bytes
   Time from start: 0 hours 0 mins 0 secs
   Error occurred at: 02/23/09, 01:01:13
   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:  => TOLEAUTO:OPEN(0)
   Called from: adordd.prg => ADO_OPEN(241)
   Called from:  => DBUSEAREA(0)
   Called from: mysql1.prg => MAIN(9)
 

I have installed ODBC MySql 5.1 and then what do I config it?



Regards,
Dutch

[ShumingWang]

Hi,
Tmysql without any setting , directly use.
Only link libmysql.lib (import from libmysql.dll ) and app.exe running time with libmysql.dll .
Shuming Wang

[anserkk]

Dear Mr.Dutch,

I have installed ODBC MySql 5.1 and then what do I config it?

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 ODBC 5.1 Driver} instead of {MySQL ODBC 3.51 Driver}

Or other alternative is uninstall MySQL ODBC ver 5.1 and Install 3.51

Regards

Anser

[Marc Vanzegbroeck]

Hi,

I'm still trying to install MySQL. 5.1 Is it possible to installed it on a VMWARE XP-Pro? I allway's get 'Error 0' at the end of configuring the database when it wants to start the service.

Regards,
Marc

[Antonio Linares]

Mark,

You could install Linux on vmware, as it may be much easier to set mysql, apache, etc. on Linux

[Antonio Linares]

Dutch,

Please try it with these connections values:

server=SQL06.FREEMYSQL.NET;database=fwppc;uid=fivetech;pwd=fivewin

the older one seems to be no longer available