Unable to connect non-system databases in rstudio
I've been trying to connect DB(sql server management studio) to rstudio.
This is what i have tried
# Importing and listing the drivers usiang the ODBC
library(odbc)
odbcListDrivers()
sort(unique(odbcListDrivers()[[1]]))
# Database connection using DBI
library(DBI)
con <- dbConnect( odbc(),
Driver = "SQL Server",
Server="localhost\SQLEXPRESS",
Database="master",
Trusted_Connection="True"
)
The above code successfully connects to the db but i can see only the system databases under the connection tab. The non-system db the user defined ones are not show in the connection panel of the R studio. How to fix this.
Connections panel
Non-system dbs in the database
r odbc rstudio
asked Nov 16 '18 at 7:46
ShhivShhiv
63
add a comment |
I've been trying to connect DB(sql server management studio) to rstudio.
This is what i have tried
# Importing and listing the drivers usiang the ODBC
library(odbc)
odbcListDrivers()
sort(unique(odbcListDrivers()[[1]]))
# Database connection using DBI
library(DBI)
con <- dbConnect( odbc(),
Driver = "SQL Server",
Server="localhost\SQLEXPRESS",
Database="master",
Trusted_Connection="True"
)
The above code successfully connects to the db but i can see only the system databases under the connection tab. The non-system db the user defined ones are not show in the connection panel of the R studio. How to fix this.
Connections panel
Non-system dbs in the database
r odbc rstudio
asked Nov 16 '18 at 7:46
ShhivShhiv
63
Question has nothing to do withmachine-learning- kindly do not spam the tag (removed).
– desertnaut
Nov 17 '18 at 0:20
I wonder if the backslash should be escaped, doesServer="127.0.0.1\\SQLEXPRESS"work?
– r2evans
Dec 6 '18 at 23:59
add a comment |
I've been trying to connect DB(sql server management studio) to rstudio.
This is what i have tried
# Importing and listing the drivers usiang the ODBC
library(odbc)
odbcListDrivers()
sort(unique(odbcListDrivers()[[1]]))
# Database connection using DBI
library(DBI)
con <- dbConnect( odbc(),
Driver = "SQL Server",
Server="localhost\SQLEXPRESS",
Database="master",
Trusted_Connection="True"
)
The above code successfully connects to the db but i can see only the system databases under the connection tab. The non-system db the user defined ones are not show in the connection panel of the R studio. How to fix this.
Connections panel
Non-system dbs in the database
r odbc rstudio
asked Nov 16 '18 at 7:46
ShhivShhiv
63
I've been trying to connect DB(sql server management studio) to rstudio.
This is what i have tried
# Importing and listing the drivers usiang the ODBC
library(odbc)
odbcListDrivers()
sort(unique(odbcListDrivers()[[1]]))
# Database connection using DBI
library(DBI)
con <- dbConnect( odbc(),
Driver = "SQL Server",
Server="localhost\SQLEXPRESS",
Database="master",
Trusted_Connection="True"
)
The above code successfully connects to the db but i can see only the system databases under the connection tab. The non-system db the user defined ones are not show in the connection panel of the R studio. How to fix this.
Connections panel
Non-system dbs in the database
r odbc rstudio
r odbc rstudio
asked Nov 16 '18 at 7:46
ShhivShhiv
63
asked Nov 16 '18 at 7:46
ShhivShhiv
63
edited Nov 17 '18 at 4:20
Shhiv
asked Nov 16 '18 at 7:46
ShhivShhiv
63
asked Nov 16 '18 at 7:46
ShhivShhiv
63
asked Nov 16 '18 at 7:46
ShhivShhiv
63
63
Question has nothing to do withmachine-learning- kindly do not spam the tag (removed).
– desertnaut
Nov 17 '18 at 0:20
I wonder if the backslash should be escaped, doesServer="127.0.0.1\\SQLEXPRESS"work?
– r2evans
Dec 6 '18 at 23:59
add a comment |
Question has nothing to do withmachine-learning- kindly do not spam the tag (removed).
– desertnaut
Nov 17 '18 at 0:20
I wonder if the backslash should be escaped, doesServer="127.0.0.1\\SQLEXPRESS"work?
– r2evans
Dec 6 '18 at 23:59
Question has nothing to do with
machine-learning - kindly do not spam the tag (removed).– desertnaut
Nov 17 '18 at 0:20
Question has nothing to do with
machine-learning - kindly do not spam the tag (removed).– desertnaut
Nov 17 '18 at 0:20
I wonder if the backslash should be escaped, does
Server="127.0.0.1\\SQLEXPRESS" work?– r2evans
Dec 6 '18 at 23:59
I wonder if the backslash should be escaped, does
Server="127.0.0.1\\SQLEXPRESS" work?– r2evans
Dec 6 '18 at 23:59
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%2f53333478%2funable-to-connect-non-system-databases-in-rstudio%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%2f53333478%2funable-to-connect-non-system-databases-in-rstudio%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
Question has nothing to do with
machine-learning- kindly do not spam the tag (removed).– desertnaut
Nov 17 '18 at 0:20
I wonder if the backslash should be escaped, does
Server="127.0.0.1\\SQLEXPRESS"work?– r2evans
Dec 6 '18 at 23:59