ssis 错误Note 39022:MySQL client ran out of memory

通过ODBC查询Mysql数据库时候,可能会遇到和下面相似的问题。

  [MySQL][ODBC Driver]MSQL client ran out of memory

要修正这个错误,可以按如下方法设置你的ODBC连接:

  1. Navigate to your ODBC administrator (Start ► Settings ► Control Panel ► Administrative Tools ► Data Sources (ODBC)).
  2. Highlight the ODBC data source and choose Configure.
  3. Click the Advanced tab; then select the Flags 2 tab. Place a check mark beside Don’t Cache Result.
  4. Click OK.

posted @ 2018-08-09 09:54  moonunit  阅读(1453)  评论(0编辑  收藏  举报