我使用sqlsugar连接Cache的数据库视图,但是我是用的方式是通过ODBC的方式连接(由于对方只能支持我这么连接),
但是在执行过程中,会偶发错误:这个错误不频繁,可能一个星期两个星期一次这样子:
连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,错误信息:
连接数据库过程中发生错误,检查服务器是否正常连接字符串是否正确,错误信息:ERROR [S1T00] [Cache ODBC][State : S1T00][Native Code 450]
[D:\Verify\test\Data2Db\Data2DB.exe]
Request timed out due to user timeout
ERROR [01000] [Cache ODBC][State : S1T00][Native Code 450]
[D:\Verify\test\Data2Db\Data2DB.exe]
Request timed out due to user timeout[Microsoft][ODBC 驱动程序管理器] 驱动程序不支持这个应用程序请求的 ODBC 行为的版本 (参见 SQLSetEnvAttr)。DbType="Odbc";ConfigId="".
English Message : Connection open error . ERROR [S1T00] [Cache ODBC][State : S1T00][Native Code 450]
[D:\Verify\test\Data2Db\Data2DB.exe]
Request timed out due to user timeout
ERROR [01000] [Cache ODBC][State : S1T00][Native Code 450]
[D:\Verify\test\Data2Db\Data2DB.exe]
Request timed out due to user timeout[Microsoft][ODBC 驱动程序管理器] 驱动程序不支持这个应用程序请求的 ODBC 行为的版本 (参见 SQLSetEnvAttr)。DbType="Odbc";ConfigId=""
2025-12-11 15:51:22.9017 | Error | 0.0.0.0 | Data2DB.Modules.DataSync.ViewModels.TaskViewModel.OnExcuteTaskCommand | 执行异常: at SqlSugar.Check.Exception(Boolean isException, String message, String[] args)
at SqlSugar.AdoProvider.CheckConnection()
at SqlSugar.Odbc.OdbcProvider.GetCommand(String sql, SugarParameter[] parameters)
at SqlSugar.AdoProvider.GetDataSetAll(String sql, SugarParameter[] parameters)
at SqlSugar.AdoProvider.<>c__DisplayClass159_0.<GetDataSetAllAsync>b__0()
at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at SqlSugar.AdoProvider.GetDataTableAsync(String sql, SugarParameter[] parameters)
at VMData2DbService.Services.VMData2DbPublishService.ImportSampleAndResultlAsync(TaskInfo taskInfo, CancellationToken token)