Recent

Author Topic: MySQL3 how connect in Lazarus?  (Read 4590 times)

deser1

  • Newbie
  • Posts: 6
MySQL3 how connect in Lazarus?
« on: December 19, 2017, 05:33:43 pm »
MySQL 3.23.57 how connect in Lazarus this version for mysql?

Pascal

  • Hero Member
  • *****
  • Posts: 932
Re: MySQL3 how connect in Lazarus?
« Reply #1 on: December 19, 2017, 06:47:17 pm »
Hello deser1, welcome to the forum!

You can use 5.7 if you use a 5.7 client library.
The used unit has to match the version of the library.
laz trunk x64 - fpc trunk i386 (cross x64) - Windows 10 Pro x64 (21H2)

deser1

  • Newbie
  • Posts: 6
Re: MySQL3 how connect in Lazarus?
« Reply #2 on: December 19, 2017, 09:12:05 pm »
Hello deser1, welcome to the forum!

You can use 5.7 if you use a 5.7 client library.
The used unit has to match the version of the library.

My Lazarus have to 4.0 for 5.6 MySQL components but i dont have component 5.7 MySQL. How search and install version 5.7 MySQL? Im looking for Packages list but not found this version MySQL Connected in list. Please paste me web link to download preferred components for main version Lazarus 1.6.4.
Thank you for every help.
Ps. Im speaking Polish but smaller english language.

Thaddy

  • Hero Member
  • *****
  • Posts: 14201
  • Probably until I exterminate Putin.
Re: MySQL3 how connect in Lazarus?
« Reply #3 on: December 19, 2017, 09:42:36 pm »
I think? deser1  means Sqlite... And .... Mysql 3.x is not supported. (not even by MySql) ... Sqlite 3.2 is supported and simply works.
Can you show some code? Doesn't have to work yet..
« Last Edit: December 19, 2017, 09:45:10 pm by Thaddy »
Specialize a type, not a var.

deser1

  • Newbie
  • Posts: 6
Re: MySQL3 how connect in Lazarus?
« Reply #4 on: December 19, 2017, 10:54:53 pm »
I think? deser1  means Sqlite... And .... Mysql 3.x is not supported. (not even by MySql) ... Sqlite 3.2 is supported and simply works.
Can you show some code? Doesn't have to work yet..

I have server for my website did run mysql version is 3.x and i not need to connect my database. How to connect mysql.cba.pl and get query data? Default port is 3306 . I need to connect this database for create application in Lazarus. How can I do this?
Ps. My code application is default because i have added components in form and write properities security data to connect database in component. That's all.

Lutz Mändle

  • Jr. Member
  • **
  • Posts: 65
Re: MySQL3 how connect in Lazarus?
« Reply #5 on: December 20, 2017, 12:25:07 am »
Use TSQLConnector instead of a specialised TMySQLxxConnection and set the property ConnectorType matching the installed mysql client library. On recent Linux systems this is probably a mariadb client library (libmariadb.so). In this case ConnectorType=MySQL 5.6 should work. You can set this property in the object inspector and there you can see which choices you have.

deser1

  • Newbie
  • Posts: 6
Re: MySQL3 how connect in Lazarus?
« Reply #6 on: December 20, 2017, 02:01:12 am »
Use TSQLConnector instead of a specialised TMySQLxxConnection and set the property ConnectorType matching the installed mysql client library. On recent Linux systems this is probably a mariadb client library (libmariadb.so). In this case ConnectorType=MySQL 5.6 should work. You can set this property in the object inspector and there you can see which choices you have.
I will check it and write to you whether it works

deser1

  • Newbie
  • Posts: 6
Re: MySQL3 how connect in Lazarus?
« Reply #7 on: December 26, 2017, 05:34:35 pm »
Use TSQLConnector instead of a specialised TMySQLxxConnection and set the property ConnectorType matching the installed mysql client library. On recent Linux systems this is probably a mariadb client library (libmariadb.so). In this case ConnectorType=MySQL 5.6 should work. You can set this property in the object inspector and there you can see which choices you have.
I will check it and write to you whether it works

Not works for this tips. Please help me.

Lutz Mändle

  • Jr. Member
  • **
  • Posts: 65
Re: MySQL3 how connect in Lazarus?
« Reply #8 on: December 27, 2017, 05:03:29 am »
Read the following thread to have a quick overview what is needed for connecting to MySQL in general:

http://forum.lazarus.freepascal.org/index.php/topic,38967.0.html

For connecting to such an old version of MySQL an older connector is needed. I've tested it, the following libmysql.dll versions are working: 4.1, 5.0, 5.1 and 5.5, all on 32-bit-Windows.

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: MySQL3 how connect in Lazarus?
« Reply #9 on: December 27, 2017, 02:22:53 pm »
I have server for my website did run mysql version is 3.x and i not need to connect my database.
Are you really saying you are using MySQL server version 3.x ???
What does the x (in 3.x) stand for?
How did you check this?

There hasn't been a version 3 since 2001.
Are you really saying you are working with a version of MySQL from 2001 or before ???

https://en.wikipedia.org/wiki/MySQL#Release_history

deser1

  • Newbie
  • Posts: 6
Re: MySQL3 how connect in Lazarus?
« Reply #10 on: January 08, 2018, 08:23:15 pm »
Please help me  :'(

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: MySQL3 how connect in Lazarus?
« Reply #11 on: January 08, 2018, 09:52:28 pm »
Could you first answer above questions?

Just repeating "help me" isn't going to work.

What version of MySQL do you use, exactly?
(3.x of MySQL isn't an exact version and besides... version 3 is from 2001)

 

TinyPortal © 2005-2018