If you are on a Mac of Linux machine (including matrix and vector), you may have to set up a Kerberos ticket. Do this with If you are using tensor<\/a>, then this process has been abstracted away into a module<\/em>:<\/p>\n\n\n\n Note that when you have been granted a new access, you need to log out and log in again, to use the new access.<\/p>\n\n\n\n Questions? Mail them to dba-support@meb.ki.se<\/a>. If at all possible, include code and relevant log messages!<\/p>\n\n\n\n Using CRIME3 as an example dataset, the libname statement looks like this:<\/p>\n\n\n\n Note that this example also works unchanged on the compute server (matrix<\/em>), and with rsubmit<\/em>.<\/p>\n\n\n\n Using CRIME3, and the view V_LMED2015 as an example, the load statement looks like this:<\/p>\n\n\n\n i.e. you specify the three-level path … The noquote<\/em> keyword is mandatory<\/strong>.<\/p>\n\n\n\n To access the list of tables and view, use<\/p>\n\n\n\n Note that these examples works also on the compute server (matrix<\/em>), unchanged.<\/p>\n\n\n\n Using CRIME3 and the V_LMED2015 view as an example, a simple version of R code, using only basic packages, looks like this:<\/p>\n\n\n\n i.e. you specify the three-level path … but see below for another way of doing this.<\/p>\n\n\n\n To access the list of tables and view, use<\/p>\n\n\n\nkinit<\/code><\/em>, and use the same password you use when logging into the MEB computers (your “Windows password”):<\/p>\n\n\n\n[joelus@matrix ~]$ kinit\nPassword for joelus@MEB.KI.SE:\n[joelus@matrix ~]$<\/code><\/pre>\n\n\n\n[joelus@tensor ~]$ ml mebauth<\/code><\/pre>\n\n\n\nSAS<\/h2>\n\n\n\n
libname CRIME3 odbc \n noprompt=\"dsn=kosmos;database=MGRCRIME3\" \n schema=\"MGRCRIME3\";<\/code><\/pre>\n\n\n\nSTATA<\/h2>\n\n\n\n
odbc load, \n table(\"MGRCRIME3.MGRCRIME3.V_LMED2015\") \n noquote dsn(\"kosmos\");<\/code><\/pre>\n\n\n\nodbc load, \n table(\"MGRCRIME3.INFORMATION_SCHEMA.TABLES\") \n noquote dsn(\"kosmos\");<\/code><\/pre>\n\n\n\nR<\/h2>\n\n\n\n
# install the DBI and odbc packages (this is a one-time install)\ninstall.packages(c(\"DBI\", \"odbc\"))\n\n# load the DBI package (once per session) \nlibrary(\"DBI\")\n# and possibly also the odbc package ...\n# library(\"odbc\") \n\n# connect to the database\ndbhandle <- dbConnect(odbc::odbc(), \"kosmos\")\n# make a query\nquery <- dbSendQuery(dbhandle, 'select ATC, LAKMED from MGRCRIME3.MGRCRIME3.V_LMED2015 where TKOST > 500000')\n\n# get data\nresult <- dbFetch(query)<\/code><\/pre>\n\n\n\n# setup as above\ncolumn_query <- dbSendQuery(dbhandle, \n 'select * from MGRCRIME3.INFORMATION_SCHEMA.TABLES')\nprint(dbFetch(column_query))<\/code><\/pre>\n\n\n\n
![\"\"](\"https:\/\/www.meb.ki.se\/sites\/meb-it\/wp-content\/uploads\/sites\/12\/2020\/12\/sqlserver-icon-vscode.png\"){kind=icon}
). If you click that you will see your connections — with the option to add a connection. Or type F1<\/strong>, then select the MS SQL: Connect<\/strong> command to open the connection workflow. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.meb.ki.se\/sites\/meb-it\/wp-content\/uploads\/sites\/12\/2020\/12\/connection_dialog.png\")
<\/figure>\n\n\n\n