MySQL3 how connect in Lazarus? lazarus / 16-Databases ---------------------------------------------------------------------- deser1 · 2017-12-19 16:33 MySQL 3.23.57 how connect in Lazarus this version for mysql? ---------------------------------------------------------------------- Pascal · 2017-12-19 17:47 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. ---------------------------------------------------------------------- deser1 · 2017-12-19 20:12 Quote from: Pascal on December 19, 2017, 06:47:17 pmHello 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 · 2017-12-19 20:42 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.. ---------------------------------------------------------------------- deser1 · 2017-12-19 21:54 Quote from: Thaddy on December 19, 2017, 09:42:36 pmI 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 · 2017-12-19 23:25 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 · 2017-12-20 01:01 Quote from: Lutz Mändle on December 20, 2017, 12:25:07 amUse 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 · 2017-12-26 16:34 Quote from: deser1 on December 20, 2017, 02:01:12 amQuote from: Lutz Mändle on December 20, 2017, 12:25:07 amUse 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 · 2017-12-27 04:03 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 · 2017-12-27 13:22 Quote from: deser1 on December 19, 2017, 10:54:53 pmI 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 · 2018-01-08 19:23 Please help me ---------------------------------------------------------------------- rvk · 2018-01-08 20:52 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)