Simba Athena ODBC 驱动程序：无法在 Mac 上连接

发布于 2025-01-16 21:44:36 字数 1222 浏览 3 评论 0 原文

我正在尝试使用 r 中的 Simba Athena ODBC 连接到 AWS Athena。

DBI::dbConnect(
odbc::odbc(),
driver = "Simba Athena ODBC Driver",
S3OutputLocation   = <>,
AwsRegion          = "us-east-2",
AuthenticationType = "IAM Credentials",
Schema             = <>,
AWS_ACCESS_KEY_ID = <>,
AWS_SECRET_ACCESS_KEY = <>)

错误：nanodbc/nanodbc.cpp:1021: 00000: [Simba][ODBC] (11560) 无法找到 SQLGetPrivateProfileString 函数：[Simba][DSI] 尝试检索键“LibsLoadErr”的错误消息时出错' 带有消息参数 ['""'] 和组件 ID 3：在文件中找不到消息"/Library/simba/athenaodbc/ErrorMessages/en-US/ODBCMessages.xml"

我已更新我的 ODBC 驱动程序，以根据此问题路由到正确的文件 - Simba Athena ODBC：无法使用 SQLGetPrivateProfileString函数

我还得到了 odbc:odbcListDrivers() 函数的响应：

name                      attribute                    value   
ODBC Drivers              Simba Athena ODBC Driver     Installed
Simba Athena ODBC Driver  Description.                 Simba Athena ODBC Driver
Simba Athena ODBC Driver  Driver.                      /Library/simba/athenaodbc/lib/libathenaodbc_sb64.dylib

原文

I'm trying to connect to AWS Athena using Simba Athena ODBC in r.

DBI::dbConnect(
odbc::odbc(),
driver = "Simba Athena ODBC Driver",
S3OutputLocation   = <>,
AwsRegion          = "us-east-2",
AuthenticationType = "IAM Credentials",
Schema             = <>,
AWS_ACCESS_KEY_ID = <>,
AWS_SECRET_ACCESS_KEY = <>)

Error: nanodbc/nanodbc.cpp:1021: 00000: [Simba][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Simba][DSI] An error occurred while attempting to retrieve the error message for key 'LibsLoadErr' with message parameters ['""'] and component ID 3: Message not found in file "/Library/simba/athenaodbc/ErrorMessages/en-US/ODBCMessages.xml"

I've updated my ODBC driver to route to the correct file per this question - Simba Athena ODBC: unable to use SQLGetPrivateProfileString functions

I am also getting a response from the odbc:odbcListDrivers() function:

name                      attribute                    value   
ODBC Drivers              Simba Athena ODBC Driver     Installed
Simba Athena ODBC Driver  Description.                 Simba Athena ODBC Driver
Simba Athena ODBC Driver  Driver.                      /Library/simba/athenaodbc/lib/libathenaodbc_sb64.dylib

分享到QQ

分享到微博