Add datasource to Report Builder using ODBC
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am trying to create a datasource in Report Builder using an ODBC connection (Progress OpenEdge 10.2B Driver)
I've set up the connection and created a User DSN. Tested the connection and got a connection established success message so pretty sure it's set up correctly in ODBC Data Source Administrator.
When I try to add the data source in Report Builder, I'm selecting the option to "Use a connection embedded in my report" and select connection type of ODBC from the Connection Type lookup.
For the connection string, I can select the data source name that I set up, add in my user name and password, but when I test the connection, I get the following error:
ERROR [HY000] [DataDirect] [ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.
ERROR [HY000] [DataDirect] ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.
I must be doing something wrong but can't see anything obvious. Any advice would be greatfully received.
Thank you
reporting-services odbc ssrs-2008 openedge reportbuilder3.0
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
add a comment |
I am trying to create a datasource in Report Builder using an ODBC connection (Progress OpenEdge 10.2B Driver)
I've set up the connection and created a User DSN. Tested the connection and got a connection established success message so pretty sure it's set up correctly in ODBC Data Source Administrator.
When I try to add the data source in Report Builder, I'm selecting the option to "Use a connection embedded in my report" and select connection type of ODBC from the Connection Type lookup.
For the connection string, I can select the data source name that I set up, add in my user name and password, but when I test the connection, I get the following error:
ERROR [HY000] [DataDirect] [ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.
ERROR [HY000] [DataDirect] ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.
I must be doing something wrong but can't see anything obvious. Any advice would be greatfully received.
Thank you
reporting-services odbc ssrs-2008 openedge reportbuilder3.0
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
add a comment |
I am trying to create a datasource in Report Builder using an ODBC connection (Progress OpenEdge 10.2B Driver)
I've set up the connection and created a User DSN. Tested the connection and got a connection established success message so pretty sure it's set up correctly in ODBC Data Source Administrator.
When I try to add the data source in Report Builder, I'm selecting the option to "Use a connection embedded in my report" and select connection type of ODBC from the Connection Type lookup.
For the connection string, I can select the data source name that I set up, add in my user name and password, but when I test the connection, I get the following error:
ERROR [HY000] [DataDirect] [ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.
ERROR [HY000] [DataDirect] ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.
I must be doing something wrong but can't see anything obvious. Any advice would be greatfully received.
Thank you
reporting-services odbc ssrs-2008 openedge reportbuilder3.0
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
I am trying to create a datasource in Report Builder using an ODBC connection (Progress OpenEdge 10.2B Driver)
I've set up the connection and created a User DSN. Tested the connection and got a connection established success message so pretty sure it's set up correctly in ODBC Data Source Administrator.
When I try to add the data source in Report Builder, I'm selecting the option to "Use a connection embedded in my report" and select connection type of ODBC from the Connection Type lookup.
For the connection string, I can select the data source name that I set up, add in my user name and password, but when I test the connection, I get the following error:
ERROR [HY000] [DataDirect] [ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.
ERROR [HY000] [DataDirect] ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.
I must be doing something wrong but can't see anything obvious. Any advice would be greatfully received.
Thank you
reporting-services odbc ssrs-2008 openedge reportbuilder3.0
reporting-services odbc ssrs-2008 openedge reportbuilder3.0
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
asked Nov 23 '18 at 13:42
FreddieFreddie
2619
2619
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Here's a few KB articles that might help you:
https://knowledgebase.progress.com/articles/Article/5796
https://knowledgebase.progress.com/articles/Article/7460
https://knowledgebase.progress.com/articles/Article/9314
Another option is that the user you are using to connect to the database with doesn't have SELECT privileges. This KB gives you details on how to do that: https://knowledgebase.progress.com/articles/Article/P101721
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
add a comment |
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%2f53447820%2fadd-datasource-to-report-builder-using-odbc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Here's a few KB articles that might help you:
https://knowledgebase.progress.com/articles/Article/5796
https://knowledgebase.progress.com/articles/Article/7460
https://knowledgebase.progress.com/articles/Article/9314
Another option is that the user you are using to connect to the database with doesn't have SELECT privileges. This KB gives you details on how to do that: https://knowledgebase.progress.com/articles/Article/P101721
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
add a comment |
Here's a few KB articles that might help you:
https://knowledgebase.progress.com/articles/Article/5796
https://knowledgebase.progress.com/articles/Article/7460
https://knowledgebase.progress.com/articles/Article/9314
Another option is that the user you are using to connect to the database with doesn't have SELECT privileges. This KB gives you details on how to do that: https://knowledgebase.progress.com/articles/Article/P101721
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
add a comment |
Here's a few KB articles that might help you:
https://knowledgebase.progress.com/articles/Article/5796
https://knowledgebase.progress.com/articles/Article/7460
https://knowledgebase.progress.com/articles/Article/9314
Another option is that the user you are using to connect to the database with doesn't have SELECT privileges. This KB gives you details on how to do that: https://knowledgebase.progress.com/articles/Article/P101721
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
Here's a few KB articles that might help you:
https://knowledgebase.progress.com/articles/Article/5796
https://knowledgebase.progress.com/articles/Article/7460
https://knowledgebase.progress.com/articles/Article/9314
Another option is that the user you are using to connect to the database with doesn't have SELECT privileges. This KB gives you details on how to do that: https://knowledgebase.progress.com/articles/Article/P101721
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
answered Nov 23 '18 at 17:13
jdpjamespjdpjamesp
389212
389212
add a comment |
add a comment |
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%2f53447820%2fadd-datasource-to-report-builder-using-odbc%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
