在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:pingles/homebrew-psqlodbc开源软件地址:https://github.com/pingles/homebrew-psqlodbc开源编程语言:Ruby 100.0%开源软件介绍:Postgres' ODBC libraryInstall the libraries
Configure ODBCAlthough I've been able to connect to Redshift with unixodbc using the psqlodbc driver from R, I wasn't able to from Julia. I've been able to connect successfully with iODBC. iODBC doesn't seem to like using configured DSNs. I've had success connecting from R, Julia, and Python using ODBC. In all situations I've had to connect using ODBC's SQLDriverConnect routine. Pkg.add("ODBC")
using ODBC
ODBC.advancedconnect("Driver=/usr/local/lib/psqlodbcw.so;Database=data;Username=user;Password=pass;Server=foo.redshift.amazonaws.com;Port=5439;")
ODBC.query("SELECT * FROM information_schema.tables") install.packages("RODBC")
c <- odbcDriverConnect("Driver=/usr/local/lib/psqlodbcw.so;Database=data;Username=user;Password=pass;Server=foo.redshift.amazonaws.com;Port=5439;")
results <- sqlQuery(c, "SELECT * FROM information_schema.tables") |
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论