Hi All,

We're on a Windoze machine and I've go the PFI (ProcessFlow Integrator) working pretty well not with one exception.
I can run sql queries from the designer from my local client but when I try to run it server side it says that it couldn't find the JDBC drivers ...

So basically it comes down to having the right drivers for SQLServer in the right place and adding it to the right bpm path. But I have tried everything and I can't seem to get it to work.

I was under the impression that it would take the same Microsoft Jar files that I was using on the client side and the adding them to the path. But it seems to be more complicated than that on the server side.

So anyway, can anyone tell me how they finally got this to work right? Which drivers did you use? Where did you get them? where did you place them? And how did you set your path? And what is the air-speed velocity of an unladen African swallow assuming that they are NOT migratory. :yammer:

Setup:
LSF 9.0.0.1
PFI
Windows 2003
MS SQL Server


Thanks a bunch

Okay so GSC came thru for me.
What I had to do was place the drivers in

%GENDIR%/bpm/jars

Add the path to the files to the %CLASSPATH% by editting pfserv.cfg (in %LAWDIR%/system)

and then what finally did it was

pfserv config all

this runs PERL script that you need to run and set all the params. I had to basically set all the JDBC params to what I had set them to on my Designer. If anyone needs the exact params I can post them ....

T