Forum Discussion

guro2525's avatar
guro2525
Helper I
3 years ago

MySQL Connector NET doesn't working

Hello Dear friends,   I have a next problem:  I didn't manage to get data from a database. This happened after changing the database server and a database version. Before changing everything work f...
Need Help
Show and Tell
guro2525's avatar
guro2525
Helper I
3 years ago

Hello v-yanjiang-msft!,

Thank you so much for your response!
Your solution solve this problem, but  using previous version I had another error:

--We encountered an error while trying to connect. Details: “An error happened while reading data from the provider: ‘Object cannot be cast from DBNull to other types.’”--

May be you have any experience how to solve this problem?


Best Refards,
Guram

lbendlin's avatar
lbendlin
Super User
3 years ago

Rewrite your custom query to avoid the casting.

  • guro2525's avatar
    guro2525
    Helper I
    3 years ago

    Dear lbendlin,

    Unfortunately, his error happenes when I try to connect database, I can't move on the enxt step and change comthing in query editor.


    Best regards,
    Guram