RE: [dbi] Re: Attempt to initiate a new SQL Server operation with results pending.


On 27-Jun-2005 Daniel Kasak wrote:
> Jeff Urlwin wrote:
>
>>Please read DBD::ODBC pod. Specifically the section on the odbc_cursortype.
>>
>>Jeff
>>
>>
> I just added odbc_cursortype => DBI::SQL_CURSOR_DYNAMIC to our
> connection string, and that didn't help things at all.
> Martin J. Evans ( see other post on topic ) says that this won't work if
> I'm using FreeTDS.

I didn't quite say that. I said "Didn't you say something about using FreeTDS?
If so that hack might not work for FreeTDS. Against MS SQL Server ODBC driver it
works - I tried it with your example.". I've not got FreeTDS to try it.

> Not to worry. $sth->finish everywhere is what's gotten us this far, and
> SQL Server is only used for legacy stuff anyway. To be honest I'm
> surprised that it ( connecting to SQL Server from Linux ) works at all.
>
> Thanks for the help everyone.

What I know for definite works direct to the MS SQL Server ODBC Driver and
through our ODBC-ODBC Bridge from UNIX to MS SQL Server ODBC Driver is both the
change for the cursor type and the change to use odbc_SQL_ROWSET_SIZE. However,
you must be very careful to make sure the cursor is closed properly when using
these methods or the MS SQL Server driver can hang on a later statement.

For portability, I never use multiple active statements. I always reorganise my
SQL or if that can't be done open another connection.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development

.

Relevant Pages

  • Re: what questions to ask my isp ?
    ... connection string change and an upload as long as they support .Net and SQL. ... Martin ... It access an Microsoft SQL Server ... >> database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)