Can Add table Database in server explorer but not in data source
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 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
add a comment |
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 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
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 '18 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 '18 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 at 9:53
add a comment |
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 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
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 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
asked Nov 14 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
edited Nov 14 '18 at 8:11
Mohammad Khaled
asked Nov 14 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
asked Nov 14 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
asked Nov 14 '18 at 6:55
Mohammad KhaledMohammad Khaled
58
58
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 '18 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 '18 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 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 '18 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 '18 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 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 '18 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 '18 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 '18 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 '18 at 7:46
1
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 at 9:53
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 at 9:53
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
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
0
active
oldest
votes
0
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.
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 '18 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 '18 at 7:46
1
the solution is in this link stackoverflow.com/questions/53224812/…
– Mohammad Khaled
Nov 14 '18 at 9:53