PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
ERROR CONNECTING WITH MYSQL
ERROR CONNECTING WITH MYSQL
Started by LUIS ALBERTO BERNAL, Apr., 22 2020 3:19 PM - 3 replies
Connect yourself…
LUIS ALBERTO BERNAL
#1
Registered member
7 messages
Posted on April, 22 2020 - 3:19 PM
Good morning,
I am new to windev, I am testing by connecting to Mysql, and an error is generated. The version used is 23.
This is the code that i user.
////////
ConnectionNum is int
ConnectionNum = SQLConnect("127.0.0.1", "root", "root", "enlacevisual", "MySQL")
IF ConnectionNum <> 0 THEN
ToastDisplay("Connection Successfully")
ELSE
SQLInfo()
Error("Connection has failed !" + CR + ...
"Error code: " + SQL.Error + CR + SQL.MesError)
END
SQLDisconnect()
///////////////
Thanks,
Luis Alberto Bernal B.
Valledupar - Colombia
Report
0
0
Passenger
#2
Posted on April, 29 2020 - 6:57 AM
Hi,
Two things to do :
1- Install Native Access of MySQL (From PCSoft Website)
2- Put libmysql.dll (from your MYSQL) beside your Application folder
Report
0
0
marin
#3
Registered member
27 messages
Posted on October, 29 2020 - 1:42 PM
Hi,
I am using WebDev 19 and facing similar issue, can not connect to MySql database. I get error 27, which states that the client layer may not installed properly.
Already put libmysqld.dll files to webdev installation folder and into Programs, and Framework folder. Even into c://windows and c://windows/system32. Still does not work. Any possible solutions?
Thanks in advance
How to do this step bellow?
2- Put libmysql.dll (from your MYSQL) beside your Application folder
Where can I find Application folder?
I am using MySql 5.7.12 server, but also tried the newest version and have installed Native Access of MySQL.
Report
0
0
marin
#4
Registered member
27 messages
Posted on October, 30 2020 - 8:32 AM
In the case if anyone enters the similar or same error I found the solution. Installed Webdev was 32bit version, and app would not recognize .dll files. Just installed 64 bit version and the native connection works.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text