Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^4: DBI Prematurely Disconnecting

by mje (Curate)
on Oct 09, 2013 at 17:57 UTC ( #1057600=note: print w/ replies, xml ) Need Help??


in reply to Re^3: DBI Prematurely Disconnecting
in thread DBI Prematurely Disconnecting

I answered your later post where it sounds like you are working now. I did not take your reponse as meaning you were blaming anything, I was just simply pointing out there were more parameters than you had considered.

I'm interested in 2 things in particular (both of which could help me).

  1. Why are you using so old a DBI and DBD::ODBC?
  2. Why do you think you got to the point where you were calling a procedure with the do method and never got to odbc_more_results? Did you read any of DBD::ODBC and if so, how could I make it clearer so the next person who hits this doesn't have to go through your pain.


Comment on Re^4: DBI Prematurely Disconnecting
Replies are listed 'Best First'.
Re^5: DBI Prematurely Disconnecting
by perldc (Initiate) on Oct 14, 2013 at 15:28 UTC
    1. I'm relying on the install of an existing server to which I am not an admin. However we will be upgrading. 2. The do method was only an attempt at trying something new at the time that I posted my code. I was actually using prepare/execute because I knew I was expecting a resultset. I usually work with .net and if I run any SQL using any of the methods, it executes 100% fully before continuing.

    I've come across odbc_more_results in previous research but DBD::ODBC only says "SQL Server supports this feature" so I assumed I didnt have to use this unless I was expecting to see multiple results from using sql such as select * from table1; select * from table2;

    You've been a great help. Thank you.

      Thank you for taking the time to explain how you got where you got. I've updated the pod in DBD::ODBC to try and make odbc_more_results clearer.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1057600]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (14)
As of 2015-07-30 23:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (273 votes), past polls