MySQL procedure problem

[EDUYork]

I wrote a login_user routine that returns a variable, and I was the able to
select that variable and get it's value all through production using the CF
built-in web server on port 8500, but when I uploaded to the live W2003 server,
which runs MX7 under MSIIS I get

NativeErrorCode 1312
SQLState 0A000
Detail PROCEDURE login_user can't return a result set in the given context

I'm calling it onRequestStart in Application.cfc

<cftry>
<cfquery name="try_login" datasource="#this.dsn#">
call
login_user('#j_username#','#j_password#','#CGI.REM OTE_ADDR#','#CGI.HTTP_USER_AGE
NT#',@total_logins);
</cfquery>
<cfswitch expression="#try_login.recordcount#">
etc.....
It returned a result set and recordcount many other times, but no longer. I
verified I'm using the latest Connector/J 3.12 with MySQL 5.0.18 on both
machines.

Any ideas out there?

[EDUYork]

Figured it out... I still had an older version of Connector/J in another lib
directory.

So now I have another question... what's the best location for .jar files?
I've been told CFMX7\wwwroot\WEB-INF\lib (my current choice) CFMX7\lib and
CFMX7\runtime\lib and I suppose they all work, so is there a best practice?