Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ODBC connection question #25693

Open
chen9ian9 opened this issue May 9, 2024 · 1 comment
Open

ODBC connection question #25693

chen9ian9 opened this issue May 9, 2024 · 1 comment
Labels
help wanted Extra attention is needed question Further information is requested

Comments

@chen9ian9
Copy link

Td version:3.2.2.0
ODBC version:
image

I use the odbc64 connection to show that I can connect normally, but the OBDC connection using Excel does not work. What's the reason. And it can be connected by DBeaver's ODBC mode, but an error is reported when checking the data.

image

DBeaver ODBC Connect:
image

image

@chen9ian9 chen9ian9 added help wanted Extra attention is needed question Further information is requested labels May 9, 2024
@freemine
Copy link
Contributor

这是在taos_odbc驱动中预设的Not Supported Yet提醒。我们在PowerBI及其他ODBC工具中没有录得过这个错误,或者,这些工具/软件在遇到SQLSetStmtAttr(...,SQL_ATTR_MAX_ROWS,...)失败的时候,有它们自己的应对方法可以自行处理。因此,DBeaver的JDBC-ODBC桥所提示的错误场景,我们需要确认。
由于我手边没有DBeaver工具,所以可能需要您的帮助如下:

  1. 如果您是自行编译的taos_odbc驱动的话,那么您现在可以根据 implementing for SQL_ATTR_MAX_ROWS taos_odbc#20 所提示修改信息,在您的环境下修改编译后测试。
  2. 如果您是直接下载并安装taos_odbc驱动的话,那么您可能需要等待下一次taos_odbc驱动的发布https://github.com/taosdata/taos_odbc/tags
  3. 如果我们找到其他的临时workaround,我们会在此issue下继续comment。
    请保持关注,谢谢。

另对于Excel遇到的问题,请参照如下步骤进行:

  1. 设置windows环境变量:
    TAOS_ODBC_LOG_LEVEL=VERBOSE
    TAOS_ODBC_LOGGER=temp
  2. (可能需要重启你的windows)
  3. 重新启动Excel进行你的测试过程
  4. \Users\...\AppData\Local\Temp\taos_odbc.log是日志文件,里面会有详细的调试跟踪信息。
  5. 你也可以把上述文件贴上来,我们可以帮助一起排查问题

使用taos_odbc驱动的过程中,如果还有遇到问题,您也可以先查看一下 https://github.com/taosdata/taos_odbc/blob/main/README.cn.md

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants