How to connect FiveWin with Mysql
Posted: Fri Feb 20, 2009 1:50 pm
Plz send the code to connect my application with mysql
Hi
You can use TMySQL to connect MySQL and free.
Please search it in this Forum.
Regards,
Richard
FiveTech Software tech support forums
www.FiveTechSoft.com
http://forums.fivetechsoft.com/
How to connect FiveWin with Mysql
Page 1 of 2
Re: How to connect FiveWin with Mysql
Posted: Fri Feb 20, 2009 3:19 pm
Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 1:49 am
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
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
Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 5:26 am
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
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
Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 5:53 am
hello anserkk...
The prg TMYsql have
TMySqlRow ( 64 )
TmySqlQuery ( 290 )
TMySQLTable ( 1159 )
TMySQLServer ( 1590 )
The prg TMYsql have
TMySqlRow ( 64 )
TmySqlQuery ( 290 )
TMySQLTable ( 1159 )
TMySQLServer ( 1590 )
Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 6:30 am
Dear MR.Daniel,
You are right, it is there. I am so sorry
Regards
Anser
You are right, it is there. I am so sorry
Regards
Anser
Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 1:42 pm
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
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
Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 1:47 pm
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
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
Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 2:08 pm
Thanks Rick,
I just downloaded ADORDD and will now test it.
Regards,
Marc
I just downloaded ADORDD and will now test it.
Regards,
Marc
Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 6:03 pm
Dear All,
I donwload ADORDD.ZIP and try MYSQL1.PRG and It show the error as following;
I have installed ODBC MySql 5.1 and then what do I config it?
Regards,
Dutch
I donwload ADORDD.ZIP and try MYSQL1.PRG and It show the error as following;
Code: Select all
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)
Regards,
Dutch
Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 2:03 am
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
Tmysql without any setting , directly use.
Only link libmysql.lib (import from libmysql.dll ) and app.exe running time with libmysql.dll .
Shuming Wang
Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 4:43 am
Dear Mr.Dutch,
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
Error description: Error ADODB.Connection/0 S_OK: OPENI have installed ODBC MySql 5.1 and then what do I config it?
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
Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 7:06 am
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
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
Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 11:52 am
Mark,
You could install Linux on vmware, as it may be much easier to set mysql, apache, etc. on Linux
You could install Linux on vmware, as it may be much easier to set mysql, apache, etc. on Linux
Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 11:54 am
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
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