<anonymous@discussions.microsoft.com> wrote in message
news:1531501c3c41c$ac765370$a601280a@phx.gbl...
> I know why I'm getting the error, I cannot get it to go
> away. I am using a System DSN connection. This is my only
> option, I am a developer stuck in the middle. Lotus LEI
> tells me it's an MS problem. I do not have control over
> the statements being executed. The only control I have is
> with the ODBC Data Source. That option I am refering, if I
> uncheck the box then it will use SQLExecDirect and my
> problem will go away from what I am told.
> I suppose I found a bug with ODBC Data Sources.
>
>
> Thanks any way
>
>
>
> >-----Original Message-----
> >If you use SQLExecDirect() then the driver will not
> prepare the statement,
> >the driver will send the query directly to the server.
> >
> >That option only applies when you are calling SQLPrepare
> () and SQLExecute().
> >
> >As for the error, you are getting the error because you
> are not consuming
> >all of the results from an execution, before trying to
> perform another
> >execution. The easiest way to ensure you have consumed
> all of the results
> >is to call SQLMoreResults() until it returns
> SQL_NO_DATA. You can create as
> >many statements per connection as you want, but you need
> to make sure you
> >are completely done with a statement, before using
> another statement that
> >shares the same connection. If you need to use multiple
> statements on a
> >connection at the same time, then you need to use server-
> side cursors.
> >
> >--
> >Brannon Jones
> >Developer - MDAC
> >This posting is provided "as is" with no warranties and
> confers no rights.
> >
> >
> ><anonymous@discussions.microsoft.com> wrote in message
> >news:066801c3bf2e$7d1e6290$a001280a@phx.gbl...
> >> This is the option I am speaking of, if this option is
> >> unchecked then it will execute directly and not use
> >> prepare and execute. I am getting the error when I use
> the
> >> dsn connection.
> >>
> >> >-----Original Message-----
> >> >Exactly what option are you referring to? There is an
> >> option with the text:
> >> >"Create temporary stored procedures for prepared SQL
> >> statements and drop the
> >> >stored procedures: ...". Why do you want to uncheck
> this
> >> option?
> >> >
> >> >If you are not programming a SQL statement, then how
> are
> >> you getting that
> >> >error you reported? ("S1000: [Microsoft][ODBC SQL
> Server
> >> Driver]Connection
> >> >is busy with results for another hstmt.")
> >> >
> >> >--
> >> >Brannon Jones
> >> >Developer - MDAC
> >> >This posting is provided "as is" with no warranties and
> >> confers no rights.
> >> >
> >> >
> >> ><anonymous@discussions.microsoft.com> wrote in message
> >> >news:080a01c3be5f$e8847030$a001280a@phx.gbl...
> >> >> This does not answer the question. I am not
> programming
> >> a
> >> >> sql statement. I am setting up a DNS and I am unable
> to
> >> >> uncheck the Prepare box when setting up the data
> source.
> >> >>
> >> >> But thanks, anyway
> >> >> >-----Original Message-----
> >> >> >This has nothing to do with SQLPrepare. By default
> MS
> >> SQL
> >> >> Server and
> >> >> >Sybase allow only one statement per connection at a
> >> time.
> >> >> It requires
> >> >> >that you close one statement before you open another
> >> one.
> >> >> If you try to
> >> >> >open another statement, you get this error. You can
> >> >> change this default
> >> >> >behavior by using Server Side Cursors. Here is some
> >> >> sample code.
> >> >> >
> >> >> >
> >> >> >
> >> >> > nResult = SQLSetStmtAttr(hstmt,
> >> >> SQL_ATTR_CURSOR_TYPE,
> >> >> >(SQLPOINTER)SQL_CURSOR_DYNAMIC, 0);
> >> >> > if(nResult != SQL_SUCCESS && nResult !=
> >> >> SQL_SUCCESS_WITH_INFO){
> >> >> > // Handle error
> >> >> > }
> >> >> >
> >> >> > nResult = SQLSetStmtAttr(hstmt,
> >> >> SQL_ATTR_ROW_ARRAY_SIZE,
> >> >> >(SQLPOINTER)10, 0);
> >> >> > if(nResult != SQL_SUCCESS && nResult !=
> >> >> SQL_SUCCESS_WITH_INFO){
> >> >> > //Handle error
> >> >> > }
> >> >> >
> >> >> >Hope this helps.
> >> >> >
> >> >> >Pete.
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >anonymous@discussions.microsoft.com wrote:
> >> >> >
> >> >> >>I could really use some help, I have a system dsn
> and
> >> am
> >> >> >>using the Sql Server 2000 odbc driver. I am
> getting an
> >> >> >>error S1000: [Microsoft][ODBC SQL Server Driver]
> >> >> >>Connection is busy with results for another hstmt.
> >> >> >>
> >> >> >>When I look at the dsn settings, there is a check
> box
> >> to
> >> >> >>turn off SQLPrepare. The problem is it is checked
> and
> >> >> the
> >> >> >>box is greyed out and will not let me turn this
> off.
> >> >> Does
> >> >> >>anyone know why this is like this, and how can I
> turn
> >> it
> >> >> >>off?
> >> >> >>Will I have to write my own driver?
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >--
> >> >> >
> >> >> >You don't pay to get spam, why pay to clean it?
> >> >> >Visit http://www.spammarshall.com to create an
> account
> >> >> for free
> >> >> ><http://www.spammarshall.com>
> >> >> >
> >> >> >
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >