Simba ODBC驱动连接BigQuery多工具异常问题求助

问题背景 #

• 使用Simba ODBC Windows驱动（版本3.0.7.1016）对接Google BigQuery
• ODBC数据源管理器中连接测试正常，但Excel、MS Access、SQL Server链接服务器均出现功能异常

Excel连接错误信息 #

Unexpected error: Container exited unexpectedly with code 0xC0000409. PID: 23508.
Used features: Odbc.DataSource/Simba ODBC Driver for Google BigQuery/3.0.7.1016/BigQuery/2.
Details:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Container exited unexpectedly with code 0xC0000409. PID: 23508.
Used features: Odbc.DataSource/Simba ODBC Driver for Google BigQuery/3.0.7.1016/BigQuery/2. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: >Container exited unexpectedly with code 0xC0000409. PID: 23508.
   at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   --- End of inner exception stack trace ---
   at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
   at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
   at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_Value()
   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value()
   at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__DisplayClass22_0.<StartEvaluation>b__0(EvaluationResult2`1 result)

MS Access ODBC日志错误 #

Oct 22 15:10:00.275 ERROR 11776 Simba::ODBC::Connection::SQLGetConnectAttr: [Simba][ODBC] (10210) Attribute identifier invalid or not supported: 30002
Oct 22 15:10:00.276 ERROR 11776 Simba::ODBC::Connection::SQLSetConnectAttr: [Simba][ODBC] (10210) Attribute identifier invalid or not supported: 30002
Oct 22 15:10:01.203 ERROR 11776 Simba::BigQuery::GBQApiError::LogError: HTTP error: Not found: Table io-dashboard-380919:sql_server_dbo.MSysConf was not found in location US [code: 404][reason: notFound]
Oct 22 15:10:01.217 ERROR 11776 Simba::ODBC::ClassicQueryExecutor::DoCompleteExecution: [Simba][BigQuery] (31770) Table is not found. Not found: Table io-dashboard-380919:sql_server_dbo.MSysConf was not found in location US
Oct 22 15:10:01.219 ERROR 11776 Simba::ODBC::StatementState::DoExecDirect: [Simba][BigQuery] (31770) Table is not found. Not found: Table io-dashboard-380919:sql_server_dbo.MSysConf was not found in location US
Oct 22 15:10:01.220 ERROR 11776 Simba::ODBC::StatementStateAllocated::SQLExecDirectW: [Simba][BigQuery] (31770) Table is not found. Not found: Table io-dashboard-380919:sql_server_dbo.MSysConf was not found in location US
Oct 22 15:10:01.221 ERROR 11776 Simba::ODBC::Statement::SQLExecDirectW: [Simba][BigQuery] (31770) Table is not found. Not found: Table io-dashboard-380919:sql_server_dbo.MSysConf was not found in location US

SQL Server链接服务器异常 #

• 无法返回任何表，无明确错误提示

解决建议 #

针对Excel的0xC0000409错误 #

• 强制位数匹配：确保Simba驱动（32/64位）与Excel版本完全一致，64位Excel必须用64位驱动，32位同理
• 禁用驱动参数化：在ODBC数据源配置的「Advanced Options」中，关闭「Force Parameterization」选项
• 清理Power Query缓存：打开Excel→数据→获取数据→查询选项→清除缓存，重启Excel后重试
• 修复Office组件：通过控制面板→程序和功能→找到「Microsoft Office」→更改→快速修复/联机修复

针对MS Access的MSysConf表错误 #

• 屏蔽系统表扫描：打开Access→外部数据→ODBC数据库→选择「链接到数据源」，点击「选项」后取消勾选「系统表」，仅选择需要的用户表
• 手动指定查询：若链接表仍报错，直接编写SQL查询，格式为SELECT * FROM [数据集名.表名]，避免Access自动读取系统表

针对SQL Server链接服务器无表的问题 #

• 指定默认数据集：在链接服务器属性中，将「默认目录」设置为BigQuery的目标数据集名称（如io-dashboard-380919）
• 启用进程内模式：在链接服务器属性→服务器选项→勾选「Allow inprocess」
• 使用OPENQUERY查询：通过SELECT * FROM OPENQUERY(你的链接服务器名, 'SELECT * FROM 数据集名.表名')直接执行查询，绕过元数据自动发现
• 检查服务账户权限：确保运行SQL Server的账户拥有BigQuery数据集的读取权限

内容的提问来源于stack exchange，提问作者user10327557