Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GetSchema not Working #884

Closed
nemosmart opened this issue Sep 5, 2020 · 1 comment
Closed

GetSchema not Working #884

nemosmart opened this issue Sep 5, 2020 · 1 comment
Labels
waiting for answer Needs more information from the bug reporter

Comments

@nemosmart
Copy link

nemosmart commented Sep 5, 2020

Hi, why GetSchema is not working? Im using VS2019 + .NET 4.8 + MySQL 5.6, it return with this error:

Exception thrown: 'MySqlConnector.MySqlException' in mscorlib.dll
The Command Timeout expired before the operation completed.

Here is my code:
Using connection = New MySqlConnection(conStr.ConnectionString) connection.Open() Dim o As DataTable = connection.GetSchema("Tables", {"uom"}) End Using


Regards

@bgrainger
Copy link
Member

Restrictions aren't currently supported in GetSchema (#374) so maybe this is requesting more data than can be retrieved before a timeout occurs?

You could try increasing DefaultCommandTimeout in your connection string.

@bgrainger bgrainger added the waiting for answer Needs more information from the bug reporter label Aug 19, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
waiting for answer Needs more information from the bug reporter
Development

No branches or pull requests

2 participants