Logging in from an NT Web server

[Terry Kummell]

We have a K570 that runs an informix database. A new web based application (running on a Winnt server) is in the works that needs to be able to authenticate users and then access the database. Is there some way of doing this?

Thanks for the help!

Terry Kummell
CCI-Triad

[John Bolene]

Since the app is web based, Apache web server has ways of authenticating users and other web servers should also.
One book I am currently using is the O'Reilly book Apache, the definative guide.

[David Mabo_1]

I have an app running on Cold Fusion to a Unify DB. We use ODBC, and login from a custom Cold Fusion app to our db.

That was easier than other choices, such as via the ODBC or native drivers.

If you use an app that uses native drivers, you could login to the db using system authorization. We use that method with our Unify Vision apps.

[Terry Kummell]

Hmmmm, I didn't understand the ODBC part of your response. I think what we are trying to do is this:
1. Remote user accesses a web page that resides on the NT server.
2. The remote user must be authenicated for access to the Informix database that resides on the K570.

So the question resolves (at least in my mind) to "How do you authenicate a remote user who wants Informix access when that user is not directly attached to the K570 (eg via Winnt)?

[Joseph C. Denman]

I dont know about informix, but in oracle, you would need to have a userid and password to access the database through sql.

Kind of unsure of what you are asking?

[Terry Kummell]

Hi Joseph,

Okay, we have some users that currently have access to data that are stored in an informix database. The current interface is a character based terminal session (non GUI).

We have a GUI based application that runs on an NT server that these same users also use. They connect to this application and are presented with a 'form' based GUI interface.

The management has said "Gee, wouldn't it be nice if we could access the informix data the same (or similar) way?"

Hence the question.... If I have a user who is logging on to an NT server who wants to review some data that happens to reside on an HP-UX based system, how do I authenicate (or log this user on)?

Is there some application that will allow the NT system to send the login name and password to validate that the user has permission to use the HP-UX resources?

I appreciate all of the answers I've recieved so far and I am sorry that it is taking so much bandwidth to elaborate on the basic question.

[Wodisch]

Hello,

if it is about db access from a web based application,
is perl a possible choice to be used as "CGI" language?
If yes, then get yourself the "ActiveState" perl package
for Windows (free), get the "DBI::" package from CPAN
(try www.perl.com) and use just some HTML "form" to
ask the user for his/her name and password.
Read "http://www.perl.com/pub/2001/02/dbix.html"
for details...
HTH,
Wodisch