It is currently Tue Mar 09, 2021 10:00 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Can't connect to MySQL anymore
PostPosted: Thu Jan 14, 2021 4:10 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Wed Jul 15, 2020 7:10 am
Posts: 106
The following code worked fine on 5.72, but not on 5.73:
Code:
UseMySQLDatabase("Mydtive:\Myfolder\libmariadb.dll")
database=OpenDatabase(#PB_Any,"host=myhost port=3306 dbname=mydb","user","password",#PB_Database_MySQL)



Now it produces a "UseODBCDatabase(), UseSQLiteDatabase() bzw. UsePostgreDatabase() muss vor dem Verwenden von Datenbank-Befehlen aufgerufen werden."

Not a single word about MySQL...

It works with 5.73 Beta 3.


Top
 Profile  
Reply with quote  
 Post subject: Re: Can't connect to MySQL anymore
PostPosted: Sat Jan 16, 2021 3:11 pm 
Online
Addict
Addict
User avatar

Joined: Fri May 12, 2006 6:51 pm
Posts: 2891
Location: Germany
No problem here ... PB v5.72 LTS Win 7

_________________
My Projects ThreadToGUI / OOP-BaseClass / OOP-BaseClassDispatch / EventDesigner V3
PB v3.30 / v5.70 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace


Top
 Profile  
Reply with quote  
 Post subject: Re: Can't connect to MySQL anymore
PostPosted: Sat Jan 16, 2021 3:44 pm 
Offline
Addict
Addict

Joined: Sat Feb 08, 2014 3:26 pm
Posts: 992
This message is displayed when the path is incomplete or the DLL is not a compatible version.
First of all: if external resources are used, always test their presence before use so as not to leave the end user with no way to identify an error.

Code:
DB_DLL$ = "C:\Program Files\PureBasic\Compilers\libmariadb.dll"

If FileSize(DB_DLL$) <= 0
    MessageRequester("Error", "DLL not present")
    End
EndIf

UseMySQLDatabase(DB_DLL$)

; ...

Then, is your DLL the version provided with PB 573 (not beta) ? libmariadb.dll 3.1.9


Top
 Profile  
Reply with quote  
 Post subject: Re: Can't connect to MySQL anymore
PostPosted: Wed Feb 03, 2021 12:49 pm 
Offline
New User
New User
User avatar

Joined: Wed Feb 03, 2021 12:46 pm
Posts: 9
Location: Riesa
Hello,
sorry for the late reply. I had problems with my account, for the hundredth time, because Google keeps deleting and moving the emails from here (and some others too). So I had to create a new account, which hopefully works now.

Yes, that helped. I always made sure the file is accessible, but obviously the version had changed and the older one was not usable. Updating the DLL worked.

Thanks!


Top
 Profile  
Reply with quote  
 Post subject: Re: Can't connect to MySQL anymore
PostPosted: Thu Feb 04, 2021 7:47 am 
Offline
Enthusiast
Enthusiast

Joined: Fri Oct 16, 2009 10:12 am
Posts: 732
Location: BE
jacdelad wrote:
... because Google keeps deleting and moving the emails from here (and some others too).
Seems like thre are more things that become deleted : jacdelad 106 posts now down to 1 post.

_________________
Yeah I know, but keep in mind ... Leonardo da Vinci was also an autodidact.


Top
 Profile  
Reply with quote  
 Post subject: Re: Can't connect to MySQL anymore
PostPosted: Thu Feb 04, 2021 8:49 am 
Offline
New User
New User
User avatar

Joined: Wed Feb 03, 2021 12:46 pm
Posts: 9
Location: Riesa
Well, not a big loss though.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye