search

mithrandyr / SimplySql

PowerShell module for querying various SQL databases
MIT License
197 stars 31 forks source link

Issue with MariaDB 10.11 #120

Closed Ruizu22 closed 7 months ago

Ruizu22 commented 1 year ago

Hi,

It appears that SimplySQL cannot work with MariaDB 10.11. I encounter this error when attempting to open a connection:

Exception occurred when calling 'Open' with '0' argument(s): 'Unable to cast an object of DBNull to other types.'

I have come across the following information:

The issue is caused by a modification in MariaDB, and the MySQL connector will not be updated to work with MariaDB.

Regards

ITSNOTSTUPIDIFITWORKS commented 1 year ago

The only solution for SimplySql, that I see, would be the change from MySql.Data to MySqlConnector´.

@mithrandyr Maybe you have something planned for v2?

mithrandyr commented 1 year ago

@Ruizu22 @ITSNOTSTUPIDIFITWORKS -- Yes, V2 is changing connectors for MySql. And yes, V2 is delayed (work + school + family...) -- Most of the migration to V2 is complete (Its at like 85%) -- most of what remains is polishing and testing.

zensbert commented 9 months ago

Hi, any news on this topic? Synology updated their MariaDB Package so now i´m having trouble getting SimplySQL to work.. If you are 85% ready a pre-release / non polished version would really help.. Thanks!

mithrandyr commented 8 months ago

@zensbert -- I'm very close to releasing 2.0 -- just been doing testing and validating what I can for all the changes. I hope to put up a release on powershell gallery soon.

mameier1234 commented 7 months ago

@mithrandyr some news about 2.0 ?

mithrandyr commented 7 months ago

@mameier1234 -- finishing up the last set of tests and double-checking I've made all the changes.. had to take a break for some graduate work, but so far my test suite is passing on ubuntu, ps7 and ps5.1 !.

mithrandyr commented 7 months ago

@mameier1234 -- V2 is released, please try it out and let me know of any issues you find.