RStudio connectivity to DashDB getting failed using ssl

Posit Professional & Hosted Products
1

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

2

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)

4

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.

5

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