RE: Changing column names?

I've found Hit's driver to be faster and lighter[1] than IBM's OLE/DB
driver. But's it's personal preference.

-Walden

[1] I HATE installing ~30 Meg of crap just for a database access driver like
I have to in CAE.

------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com



-----Original Message-----
From: thomas@inorbit.com [mailto:thomas@inorbit.com]
Sent: Wednesday, November 21, 2001 9:14 PM
To: midrange-l@midrange.com
Subject: RE: Changing column names?


Walden:

Then what is the Hit Software middleware itself used for? Why have it? Why
not direct connects? (Yes, the library list of the connecting user can be
used both for ODBC and DRDA/DDM.)

Tom Liotta

On Wed, 21 November 2001, "Walden H. Leverich" wrote:

>
> Tom,
>
> I can confirm that there is no server-side code, and actually the
> client side it incredibly light. But I don't think (in fact I'm rather
> sure) the library list feature isn't unique to their driver. When you
> connect to the AS/400 the server-job you get is authenticated using
> the user/password you provide and the library list is set to the
> library list of the user. There is no need to track the jobs since
> each connection to the AS/400 has it's own server job. This should be
> the same on the Client Access drivers too, no?
>
> -Walden
>
> ------------
> Walden H Leverich III
> President
> Tech Software
> (516)627-3800 x11
> WaldenL@TechSoftInc.com
> http://www.TechSoftInc.com
>
>
>
> -----Original Message-----
> From: thomas@inorbit.com [mailto:thomas@inorbit.com]
> Sent: Tuesday, November 20, 2001 10:41 PM
> To: midrange-l@midrange.com
> Subject: RE: Changing column names?
>
>
> Walden:
>
> I can't dispute what you say since I haven't used that driver and I
> can think of a couple possible techniques for accomplishing it. But it
> seems it would have to add overhead that would be unacceptable to
> many.
>
> The provider's website claims that standard server connections are
> used and that _no_ software needs to be installed on the server. This
> means that the middleware piece must be either parsing all requests to
> locate object names and resolving all necessary object references for
> the connecting user (maybe by some kind of remote program calls to
> APIs to retrieve the job description for the user, then extracting the
> library list and then retrieving the object library) and modifying the
> requests on the fly or somehow setting the library list for the server
> jobs that service each request (and of course keeping track so it
> knows when a given request for a given user might be serviced by a
> different server instance which would require setting the library list
> again; possibly also tracking when a *USRPRF or *JOBD is changed so
> that a different library list is needed).
>
> This is an impressive piece of middleware. Now I have to try this out
> just to see what happens.
>
> Tom Liotta
>
> On Tue, 20 November 2001, "Walden H. Leverich" wrote:
>
> > Library lists (at least when using the HitSoftware OLE/DB drvier)
> > are driven from the job description of the user profile you use to
> > login. We use multiple user profiles with multiple library lists all
> > the time.
> >
> > -----Original Message-----
> > From: rob@dekko.com [mailto:rob@dekko.com]
> >
> > First of all there is no concept of a library list in C/S
> > programming. You have to bury that in your connector
>
> --
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788
> Fax  253-872-7904
> http://www.400Security.com
>
>
> ___________________________________________________
> The ALL NEW CS2000 from CompuServe
>  Better!  Faster! More Powerful!
>  250 FREE hours! Sign-on Now!
> http://www.compuserve.com/trycsrv/cs2000/webmail/
>
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@midrange.com To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/midrange-l.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@midrange.com To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/midrange-l.

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788
Fax  253-872-7904
http://www.400Security.com


___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
http://www.compuserve.com/trycsrv/cs2000/webmail/




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.