Mysql fatal error

Закрыть ... [X]

mysql fatal error
radstudio logo

Sometimes the simple things are harder than you expected and dbexpress probably comes under that category, it was less express than I had expected but once you figure things out it does work. Some of the problems were my fault while others took time due to the obscur nature of the errors returned by XE and XE2.

If you start by adding the TSQLConnect component, select the MySQL driver and configure your HostName, Database, UserName and Password you can try and connect, you will most likely strike the following error :-

Show Plain Text

Text code

  1. DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, of the wrong version, or the driver maybe be missing from the system path...

So once you figure out that your missing the libmysql.dll you might try and grab the latest MYSQL C Connector from dev.mysql.com, they are up to version 6.0.2 at the time of writing this, you'll get the same error above. I was getting a more obscure crash before XE2 Update 1 which I didn't note down at the time, that abstract error message took me a while to figure out and was related to the libmysql.dll version.

It would be nice if embarcadero provided a location where you could download the compatible libmysql.dll files that work with dbexpress, it is worth noting that the XE2 read me does come with the following note :-

Show Plain Text

Text code

  1. Supported Servers

  2. dbExpress

  3. ...

  4. MySQL 5.1, 5.0.27, 4.1 (Pro/Ent/Ult/Arch) (Driver dbxMYS.dll, Client libmysql.dll)

  5.  

  6. The following combinations have been tested:

  7. LibMySQL.dll (5.1.XX)  DBXMys.dll  MySQL 4.0.XX Server  

  8. LibMySQL.dll (5.1.XX)  DBXMys.dll  MySQL 4.0.XX Server  

  9. LibMySQL.dll (5.1.XX)  DBXMys.dll  MySQL 5.0.XX Server  

  10. LibMySQL.dll (5.1.XX)  DBXMys.dll  MySQL 5.1.XX Server

To get a 5.1.XX compatible DLL you will need to download an achieved mysql complete installation zip and extract the DLL as no compatible versioned MYSQL C Connector package could be downloaded when I looked.

To save you some time I added zip download containing the win32 x86 libmysql.dll for those who wish to download.

This is libmysql.dll version 5.1.59 win32 x86 DLL which I have tested and works with both XE and XE2.

Filed under: Code Snip  Tags: Embarcadero, Borland, C, Cpp, Xe, Xe2, Delphi, Mysql

 

1. Che
Oct 27, 2011

2. Almir
Nov 05, 2011

3. Rex
Nov 23, 2011

4. Enrique
Nov 27, 2011

5. Brett Wilton
Nov 28, 2011

6. Enrique
Nov 28, 2011

7. DanG
Nov 29, 2011

8. Enrique
Nov 29, 2011

9. Giovanni
Dec 10, 2011

10. Douglas
Dec 21, 2011

11. Minoru
Jan 16, 2012

12. TiGeR
Jan 18, 2012

13. Uve (Denmark)
Jan 24, 2012

14. pj
Feb 02, 2012

15. Philip Rodrigues
Feb 02, 2012

16. Elditch
Mar 19, 2012

17. kipar
Mar 22, 2012

18. Selim Ozkan
Mar 29, 2012

19. Teun van Sambeek
Apr 16, 2012

20. KIN
Apr 18, 2012

21. kim mi sook
Apr 23, 2012

22. Alexandr
Apr 30, 2012

23. Peter
May 15, 2012

24. khsoft
May 18, 2012

25. Frank
May 30, 2012

26. richar
Jun 09, 2012

27. Edgar
Jun 20, 2012

28. Julio Cesar SF
Jun 25, 2012

29. Julio Cesar SF
Jun 25, 2012

30. Julio Cesar SF
Jun 27, 2012

31. Ravil
Jul 17, 2012

32. Peter
Jul 19, 2012

33. Valdecir
Jul 22, 2012

34. Jose
Jul 29, 2012

35. Jose
Jul 29, 2012

36. Stoyab
Aug 04, 2012

37. jason
Aug 12, 2012

38. jason
Aug 12, 2012

39. Nirav
Aug 14, 2012

40. davae93
Aug 15, 2012

41. yosvany
Aug 15, 2012

42. yosvany
Sep 03, 2012

43. Steph
Sep 15, 2012

44. w. swelam
Sep 28, 2012

45. jiahua zhong
Nov 21, 2012

46. André
Nov 29, 2012

47. Dave
Nov 30, 2012

48. Mario
Dec 11, 2012

49. shayan
Dec 18, 2012

50. Ailane
Jan 19, 2013

 

Sorry, comments have been closed for this post.


Поделись с друзьями



Рекомендуем посмотреть ещё:



Сборник - От Зайцев Нет. На Новогодний Корпоратив Лунный посевной календарь садовода-огородника на октябрь 2018 года


Mysql fatal error Mysql fatal error Mysql fatal error Mysql fatal error Mysql fatal error Mysql fatal error Mysql fatal error


ШОКИРУЮЩИЕ НОВОСТИ