Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^5: DBI Prematurely Disconnecting

by perldc (Initiate)
on Oct 14, 2013 at 15:28 UTC ( #1058193=note: print w/ replies, xml ) Need Help??


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

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.


Comment on Re^5: DBI Prematurely Disconnecting
Replies are listed 'Best First'.
Re^6: DBI Prematurely Disconnecting
by mje (Curate) on Oct 14, 2013 at 17:20 UTC

    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://1058193]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2015-07-28 03:09 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 (251 votes), past polls