Can Add table Database in server explorer but not in data source
up vote
2
down vote
favorite
I am using VS 2015 and MySQL 5.7 with connector 6.9.9 and I created a table database and can retrieve the data from Visual Studio in server explorer tabe but when i need to add it in data source for VB.NET window App form I got error
"Could not retrieve schema information for table or view "
I don't know where is the problem here...I reinstalled my OS and VS and MySQL but no hope! What is the best stable SDK because also I tried most of SDK but not working!
Also I granted the table in myswl workbench and checked from cli is granted!
mysql vb.net visual-studio mysql-workbench
asked Nov 14 at 6:55
Mohammad Khaled
388
add a comment |
up vote
2
down vote
favorite
I am using VS 2015 and MySQL 5.7 with connector 6.9.9 and I created a table database and can retrieve the data from Visual Studio in server explorer tabe but when i need to add it in data source for VB.NET window App form I got error
"Could not retrieve schema information for table or view "
I don't know where is the problem here...I reinstalled my OS and VS and MySQL but no hope! What is the best stable SDK because also I tried most of SDK but not working!
Also I granted the table in myswl workbench and checked from cli is granted!
mysql vb.net visual-studio mysql-workbench
asked Nov 14 at 6:55
Mohammad Khaled
388
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I am using VS 2015 and MySQL 5.7 with connector 6.9.9 and I created a table database and can retrieve the data from Visual Studio in server explorer tabe but when i need to add it in data source for VB.NET window App form I got error
"Could not retrieve schema information for table or view "
I don't know where is the problem here...I reinstalled my OS and VS and MySQL but no hope! What is the best stable SDK because also I tried most of SDK but not working!
Also I granted the table in myswl workbench and checked from cli is granted!
mysql vb.net visual-studio mysql-workbench
asked Nov 14 at 6:55
Mohammad Khaled
388
I am using VS 2015 and MySQL 5.7 with connector 6.9.9 and I created a table database and can retrieve the data from Visual Studio in server explorer tabe but when i need to add it in data source for VB.NET window App form I got error
"Could not retrieve schema information for table or view "
I don't know where is the problem here...I reinstalled my OS and VS and MySQL but no hope! What is the best stable SDK because also I tried most of SDK but not working!
Also I granted the table in myswl workbench and checked from cli is granted!
mysql vb.net visual-studio mysql-workbench
mysql vb.net visual-studio mysql-workbench
asked Nov 14 at 6:55
Mohammad Khaled
388
asked Nov 14 at 6:55
Mohammad Khaled
388
edited Nov 14 at 8:11
asked Nov 14 at 6:55
Mohammad Khaled
388
asked Nov 14 at 6:55
Mohammad Khaled
388
asked Nov 14 at 6:55
Mohammad Khaled
388
388
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53
add a comment |
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
1
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53294634%2fcan-add-table-database-in-server-explorer-but-not-in-data-source%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please explain EXACTLY what you did when that error was generated. You need to be VERY specific when posting questions in places like this because we only know what you tell us so you ned to tell us everything that is relevant. If it doesn't work then, most likely, you did something wrong so we need to know what you actually did. If we have to guess then we're likely to guess wrong.
– jmcilhinney
Nov 14 at 7:12
@jmcilhinney thanks for reply, I am still in the first step when I created a database table with column in mysql 5.7 and made granted for table in root user. then I went to visual studio (VB.NET windows app form) to add dataset but when I added the table database the column didn't retrieve it with table.
– Mohammad Khaled
Nov 14 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 at 9:53