Creating Table Adapter using Configuration Wizard with ODBC connection

Question

0.00/5 (No votes)

See more:

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.

Posted 20-Jul-15 6:41am

Member 11762295

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-20T06:55:00

Solution 1

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

(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.

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.

Posted 20-Jul-15 6:55am

Wendelius

Comments

Member 11762295 20-Jul-15 14:30pm

Actually my code has several classes that are dependent on a Webservice call to connect to the DB and that webservice is using ODBC connection. So I am more inclined on using ODBC connection.

Wendelius 20-Jul-15 14:33pm

In that case you need to go thoroughly through the code. This error may happen because the code is doing things in wrong order or a wrong handle is used. For example if you commit a transaction which is started in another connection this may occur.

So try to minimize the code path were the error occurs and check that everything is done in correct order.

Member 11762295 20-Jul-15 18:29pm

The same query works absolutely fine when used with Oracle client ocnnection, only with ODBC connection , the query is throwing this error.

Wendelius 21-Jul-15 0:52am

Most likely the problem is not in the query but how the ODBC functions are used. Because of this you should investigate that all the ODBC statements (not SQL) are executed correctly and in correct order.

Member 11762295 21-Jul-15 9:38am

I am really new to this, how do I check the ODBC statements?If they are executed correctly

Wendelius 22-Jul-15 1:25am

If the tracing didn't work make sure that it writes to a folder where the program is allowed to write, for example temp.

However, this is awfully starting to sound some sort of bug with the driver. Can you try with another version of the ODBC driver?

Member 11762295 22-Jul-15 15:06pm

When I tried to to the fill and get method programatically its working perfectly fine with ODBC connector. So I guess ODBC is fine. But tableadapter is not working. But I do not know how to regenerate the functionality of tableadapter programatically or even if thats possible.

Wendelius 23-Jul-15 4:37am

Probably it could be possible to write or copy paste the code from elsewhere but then again this is generated code so there's always a chance that your manual modification may be overwritten by the designer.

The programmatic alternative would be to use https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter(v=vs.110).aspx[^]