* * *

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

deser1

  • New member
  • *
  • 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: 750
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 - fpc trunk 32bit - Windows 10 Pro x64 (1803)

deser1

  • New member
  • *
  • 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: 6918
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 »
Ada's daddy wrote this:"Fools are my theme, let satire be my song."

deser1

  • New member
  • *
  • 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

  • New member
  • *
  • Posts: 45
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

  • New member
  • *
  • 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

  • New member
  • *
  • 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

  • New member
  • *
  • Posts: 45
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: 3461
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

  • New member
  • *
  • 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: 3461
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)

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus