RStudio connectivity to DashDB getting failed using ssl

Warning messages:
1: In RODBC::odbcDriverConnect("DSN=BLUDB;DRIVER=BLUDB;Database=BLUDB;Hostname=dashdb-enterprise4-yp-softbank-01.services.au-syd.bluemix.net;Port=50001;security=SSL;AUTHENTICATION=SERVER;SSLClientKeystoredb=/usr/local/ibm/gsk8_64/lib64/mydbclient.kdb;SSLClientKeystash=/usr/local/ibm/gsk8_64/lib64/mydbclient.sth;PROTOCOL=TCPIP;UID=sbtestuser01;PWD=XxXxXxXxXxX", :
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2: In RODBC::odbcDriverConnect("DSN=BLUDB;DRIVER=BLUDB;Database=BLUDB;Hostname=dashdb-enterprise4-yp-softbank-01.services.au-syd.bluemix.net;Port=50001;security=SSL;AUTHENTICATION=SERVER;SSLClientKeystoredb=/usr/local/ibm/gsk8_64/lib64/mydbclient.kdb;SSLClientKeystash=/usr/local/ibm/gsk8_64/lib64/mydbclient.sth;PROTOCOL=TCPIP;UID=sbtestuser01;PWD=XxXxXxXxXxX, :
ODBC connection failed

can any one help please. Following is the code we are using to access the database

install.packages("RODBC")
install.packages("ibmdbR")
library(RODBC)
library(ibmdbR)
Sys.setenv(LD_LIBRARY_PATH="/home/db2inst1/sqllib/lib64:/usr/local/ibm/gsk8_64/lib64:/home/db2inst1/sqllib/lib32")
Sys.setenv(LIBPATH="/home/db2inst1/sqllib/lib64:/usr/local/ibm/gsk8_64/lib64:/home/db2inst1/sqllib/lib32")
Sys.setenv(ODBCSYSINI="/etc/odbc.ini")
host.name <- "dashdb-enterprise4-yp-softbank-01.services.au-syd.bluemix.net"
port <- "50001"
user.name <-"sbtestuser01"
pwd <- "XxXxXxXxX"
security <- "SSL"
AUTHENTICATION <- "SERVER"
SSLClientKeystoredb <- "/usr/local/ibm/gsk8_64/lib64/mydbclient.kdb"
SSLClientKeystash <- "/usr/local/ibm/gsk8_64/lib64/mydbclient.sth"
driver.name <- "{IBM DB2 ODBC DRIVER}"
con.text <- paste("BLUDB;DRIVER=BLUDB",
";Database=BLUDB",
";Hostname=",host.name,
";Port=",port,
";security=",security,
";AUTHENTICATION=",AUTHENTICATION,
";SSLClientKeystoredb=",SSLClientKeystoredb,
";SSLClientKeystash=",SSLClientKeystash,
";PROTOCOL=TCPIP",
";UID=", user.name,
";PWD=",pwd,sep="")

con <- idaConnect(con.text)

I think the pertinent error is

Warning messages:
1: In odbcDriverConnect("DSN=NZSQL;UID=cejacobson;PWD=password") :
  [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2: In odbcDriverConnect("DSN=NZSQL;UID=cejacobson;PWD=password") :
  ODBC connection failed

As usual, stack overflow has some good discussion on this,


This is an RODBC, not really an R error.

One person solved the issue by ensuring they used the correct format of db connection.

Another suggested double checking that your instance is allowed to connect to your DB.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.