Hi,

I am getting an error when i try to retrieve data's to a Microsoft Excel sheet by executing more than one query at a time.if execute more than one query at one time i get this error below.

[Microsoft][ODBC Drive Manager] Drive's SQL Alloc Handle on SQL_HANDLE_ENV failed.

i am using ElevateDB & ODBC version 2.05 build 10

<< I am getting an error when i try to retrieve data's to a Microsoft Excel
sheet by executing more than one query at a time.if execute more than one
query at one time i get this error below. >>

What do you mean by "executing more than one query at a time" ?  Could you
please describe the steps that you're taking that causes the error ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

"What do you mean by "executing more than one query at a time" ?  Could you
please describe the steps that you're taking that causes the error ?"

i have two sheets, each sheet has a connection to edbserver through ODBC.each connection retrieves a specific data according to the sql statement.

when i execute all the connections, which means, all two queries are done at the same time, i am getting the error i have mentioned.

secondly i have tried with Power-pivot which is a new tech by Microsoft.A addin to Microsoft Excel.which is able to handle millions of data.earlier versions i was able to retrieve the data easily to powerpivot too, bt now for it also i am getting the error i have mentioned above.

this is the situation.

shahjaufar,

<< i have two sheets, each sheet has a connection to edbserver through
ODBC.each connection retrieves a specific data according to the sql
statement. >>

Okay, I'll check this out and see what the issue is.

--
Tim Young
Elevate Software
www.elevatesoft.com