使用带有ODBC连接的配置向导创建表适配器 [英] Creating Table Adapter using Configuration Wizard with ODBC connection

问题描述

我正在尝试使用Visual Studio 2010中的表适配器配置向导在DataSet中创建TableAdapter。我通过ODBC连接[DSN连接]连接，SQL查询运行正常，但填充方法显示错误 HY010 [ODBC] [ORACLE]函数序列错误。



但是当我使用Oracle客户端连接做同样的事情时它工作正常但是因为它被弃用了，我想要使用ODBC。



非常感谢任何帮助。

I am trying to create a TableAdapter in a DataSet using the "table Adapter Configuration Wizard" in Visual Studio 2010. I am connecting though ODBC connection[DSN connection], the SQL query runs fine but the fill method is showing error "HY010[ODBC][ORACLE] Function Sequence Error".

But When I am doing same thing using Oracle client connection then it works fine but since its deprecated, i want to use ODBC.

Any help is much appreciated.

推荐答案

错误有几种可能性。例如，来自 SQLDisconnect功能 [ ^ ]

There are several possibilities for the error. For example from SQLDisconnect Function[^]

（DM）为与ConnectionHandle关联的StatementHandle调用异步执行函数，并且在调用SQLDisconnect时仍在执行。

（DM）异步执行函数（不是这一个）调用ConnectionHandle并且在调用此函数时仍在执行。

（DM）SQLExecute，SQLExecDirect，SQLBulkOperations或SQLSetPos被调用用于与ConnectionHandle关联的StatementHandle并返回SQL_NEED_DATA 。在为所有执行数据参数或列发送数据之前调用此函数。

(DM) An asynchronously executing function was called for a StatementHandle associated with the ConnectionHandle and was still executing when SQLDisconnect was called.
(DM) An asynchronously executing function (not this one) was called for the ConnectionHandle and was still executing when this function was called.
(DM) SQLExecute, SQLExecDirect, SQLBulkOperations, or SQLSetPos was called for a StatementHandle associated with the ConnectionHandle and returned SQL_NEED_DATA. This function was called before data was sent for all data-at-execution parameters or columns.

但是，我强烈建议使用用于.NET的Oracle数据提供程序 [ ^ ]支持并不断更新，以了解Oracle数据库的新功能。

However, I would strongly suggest using Oracle Data Provider for .NET[^] which is supported and constantly updated to understand the new features of Oracle databases.

这篇关于使用带有ODBC连接的配置向导创建表适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！