Re: Calling Stored Procedures from WonderWare InTouch

Eric -

That may be true, but it's okay with us, because we always set up the library list we want inside the program after it's called.

Plus, if that were the problem, then nothing would work. As I say, if I make an identical version of the procedure that doesn't accept parameters but instead has the values hard-coded in itself, it works fine....


Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

Mike,

I *think* that using SQL naming for an ODBC (JDBC) connection disables
the library list. Everything then implicitly qualifies to your default
schema.

Here's a forum thread that covers this...
http://www.code400.com/forum/showthread.php/8439-Changing-SQL-PATH-initi
ated-in-ODBC-settings?p=47875

-Eric

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please notify us immediately by replying to it and then delete it from your computer.