topic-14657

sajith

Posts: 110

Joined: Wed Feb 18, 2009 09:58 AM

How to connect FiveWin with Mysql
Posted: Fri Feb 20, 2009 01:50 PM

Plz send the code to connect my application with mysql

richard-service

Posts: 866

Joined: Tue Oct 16, 2007 08:57 AM

Re: How to connect FiveWin with Mysql
Posted: Fri Feb 20, 2009 03:19 PM

Hi

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

Regards,

Richard

Best Regards,

Richard

Harbour 3.2.0dev (r2503251254) => Borland C++ v7.7 32bit

MySQL v8.0

Harbour 3.2.0dev (r2503251254) => Borland C++ v7.7 64bit

ShumingWang

Posts: 474

Joined: Sun Oct 30, 2005 06:37 AM

Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 01: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

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 05: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

Daniel Garcia-Gil

Posts: 2365

Joined: Wed Nov 02, 2005 11:46 PM

Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 05:53 AM

hello anserkk...

The prg TMYsql have

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

our best documentation is the source code
Isla de Margarita Venezuela.
danielgarciagil@gmail.com
http://tdolphin.blogspot.com/
https://www.dropbox.com/referrals/NTI5Njk4MDc1OQ?src=global9

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: How to connect FiveWin with Mysql
Posted: Sat Feb 21, 2009 06:30 AM

Dear MR.Daniel,

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

Regards

Anser

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 01: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

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 01: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

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 02:08 PM

Thanks Rick,

I just downloaded ADORDD and will now test it.

Regards,
Marc

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: How to connect FiveWin with Mysql
Posted: Sun Feb 22, 2009 06:03 PM

Dear All,

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

Code (fw): Select all Collapse

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

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

ShumingWang

Posts: 474

Joined: Sun Oct 30, 2005 06:37 AM

Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 02: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

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 04:43 AM

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

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: How to connect FiveWin with Mysql
Posted: Mon Feb 23, 2009 07: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

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

FiveTech Support Forums