HELP: Client app to access database on web server

HELP: Client app to access database on web server

Post by Holger Bec » Sat, 25 Apr 1998 04:00:00



I am involved in developing an application that uses a
central database on a web server to store its data. The
application should run on the client side and access the
database across an Intranet.

We have not decided the programming language to use but
it will probably be either Java or VisualC++. We will have
SQL server 6.5 running on an NT server with IIS.

The application must be able to query the database, process the
results and display appropriate information. So using HTML and
ASP does not seem to do the job. I would like to avoid using HTML
anyway if possible.
What other options are there to connect to the web database and
what programming language would be best suited?  

We are just in the specification phase of the project and
before I jump into the deep end I would like to know if anyone
has any experience for this type of application.
Any hints appreciated.

cheers
holger
--

 
 
 

HELP: Client app to access database on web server

Post by James V. Reaga » Sat, 25 Apr 1998 04:00:00



>I am involved in developing an application that uses a
>central database on a web server to store its data. The
>application should run on the client side and access the
>database across an Intranet.

>We have not decided the programming language to use but
>it will probably be either Java or VisualC++. We will have
>SQL server 6.5 running on an NT server with IIS.

>The application must be able to query the database, process the
>results and display appropriate information. So using HTML and
>ASP does not seem to do the job.

If I may ask, why wouldn't ASP work?  It's suited nicely for
this type of thing, especially in an IIS/MTS environment.

Quote:> I would like to avoid using HTML
>anyway if possible.
>What other options are there to connect to the web database and
>what programming language would be best suited?

If you're going to access the database via a web server, some
HTML is going to be involved, even if it's just the tags
to display an applet.

A lot depends on how you really want to architect your application
and what it needs to do.  If possible, I tend to have all
my processing done on the server(s) and rendering the presentation
layer in HTML.  This gives me maximum front end portability
and the freedom to not only use any language (Java, C++, VB,
even Perl) on the server.  I tend to use Java, since my code
can be used via CORBA, RMI, or DCOM, as well as implemented
as a JavaBean or ActiveX component.  The key is not "picking
a programming language," it's determining an application
architecture, and then picking languages to implement each
piece of the application - use the appropriate language wherever
you need it.

If your app is more than just data entry and retrieval, you
may consider writing a Java applet for your presentation layer.

 
 
 

HELP: Client app to access database on web server

Post by Tom Duff » Sat, 25 Apr 1998 04:00:00




>>I am involved in developing an application that uses a
>>central database on a web server to store its data. The
>>application should run on the client side and access the
>>database across an Intranet.

>>We have not decided the programming language to use but
>>it will probably be either Java or VisualC++. We will have
>>SQL server 6.5 running on an NT server with IIS.

>>The application must be able to query the database, process the
>>results and display appropriate information. So using HTML and
>>ASP does not seem to do the job.

>If I may ask, why wouldn't ASP work?  It's suited nicely for
>this type of thing, especially in an IIS/MTS environment.

>> I would like to avoid using HTML
>>anyway if possible.
>>What other options are there to connect to the web database and
>>what programming language would be best suited?

>If you're going to access the database via a web server, some
>HTML is going to be involved, even if it's just the tags
>to display an applet.

>A lot depends on how you really want to architect your application
>and what it needs to do.  If possible, I tend to have all
>my processing done on the server(s) and rendering the presentation
>layer in HTML.  This gives me maximum front end portability
>and the freedom to not only use any language (Java, C++, VB,
>even Perl) on the server.  I tend to use Java, since my code
>can be used via CORBA, RMI, or DCOM, as well as implemented
>as a JavaBean or ActiveX component.  The key is not "picking
>a programming language," it's determining an application
>architecture, and then picking languages to implement each
>piece of the application - use the appropriate language wherever
>you need it.

>If your app is more than just data entry and retrieval, you
>may consider writing a Java applet for your presentation layer.

I agree with James' response.  I would only add that I reccommend the
Apptivity IDE from Progress Software.  This java ide is the best one we have
seen for connecting to databases and building apps.

Tom Duffy
DBSoft

 
 
 

HELP: Client app to access database on web server

Post by Holger Bec » Tue, 28 Apr 1998 04:00:00





>>>I am involved in developing an application that uses a
>>>central database on a web server to store its data. The
>>>application should run on the client side and access the
>>>database across an Intranet.

>>If your app is more than just data entry and retrieval, you
>>may consider writing a Java applet for your presentation layer.

I don't think I made my intentions perfectly clear. What I want to
do is write a fat-client that does more than data entry and retrieval.
For this reason something like ASP does not do enough since for example
the application must be able to use, manipulate and process data
retrieved from the database. I really need the client app to do some
processing of the data.

Is RMIJdbc-JDBC-ODBC the best way to go? Are there other options?

What is the performance like with Java for serious applications?

I am new to Internet programming so forgive my ignorance.

Thanks!

cheers
holger
--

 
 
 

HELP: Client app to access database on web server

Post by Matthew Dow » Wed, 29 Apr 1998 04:00:00


Look at Web Objects from Apple.


> I am involved in developing an application that uses a
> central database on a web server to store its data. The
> application should run on the client side and access the
> database across an Intranet.

> We have not decided the programming language to use but
> it will probably be either Java or VisualC++. We will have
> SQL server 6.5 running on an NT server with IIS.

> The application must be able to query the database, process the
> results and display appropriate information. So using HTML and
> ASP does not seem to do the job. I would like to avoid using HTML
> anyway if possible.
> What other options are there to connect to the web database and
> what programming language would be best suited?

> We are just in the specification phase of the project and
> before I jump into the deep end I would like to know if anyone
> has any experience for this type of application.
> Any hints appreciated.

> cheers
> holger
> --

--
So the Buddah goes up to a hotdog
stand and says, "make me one with everything".
 
 
 

HELP: Client app to access database on web server

Post by Bruce Tobi » Tue, 05 May 1998 04:00:00



> I don't think I made my intentions perfectly clear. What I want to
> do is write a fat-client that does more than data entry and retrieval.
> For this reason something like ASP does not do enough since for example
> the application must be able to use, manipulate and process data
> retrieved from the database. I really need the client app to do some
> processing of the data.

So why use a web server?  Why not just write a regular old Client/Server
app?
 
 
 

HELP: Client app to access database on web server

Post by Ward Mullin » Wed, 13 May 1998 04:00:00


Why don't you look at our CocoBase Enterprise product?  It gets to
relational, Object and MainframeDatabases, and lets you partition logic
where appropriate.  You can have a lightweight client (we only about 40k of
bytecodes) that's as sophisticated as you need it to be.  Unlike using JDBC
directly, it's also architecturally secure by placing all SQL logic on the
server, instead of opening up SQL to the client, and uses CORBA or RMI
between the client and server without requiring ANY IDL compilation or
efforts.  We're also pure java on the client and server, and use standard
JDBC drivers for relational databases, and include an integrated database
application server for caching, connection pooling, business logic, etc. at
no addition costs!

Just my $.02

Ward Mullins
THOUGHT Inc.

http://www.thoughtinc.com





> >>>I am involved in developing an application that uses a
> >>>central database on a web server to store its data. The
> >>>application should run on the client side and access the
> >>>database across an Intranet.

> >>If your app is more than just data entry and retrieval, you
> >>may consider writing a Java applet for your presentation layer.

> I don't think I made my intentions perfectly clear. What I want to
> do is write a fat-client that does more than data entry and retrieval.
> For this reason something like ASP does not do enough since for example
> the application must be able to use, manipulate and process data
> retrieved from the database. I really need the client app to do some
> processing of the data.

> Is RMIJdbc-JDBC-ODBC the best way to go? Are there other options?

> What is the performance like with Java for serious applications?

> I am new to Internet programming so forgive my ignorance.

> Thanks!

> cheers
> holger
> --

 
 
 

1. Client/server app with Access database

Hi

I'm trying to access an Access database from an application in many clients
through a LAN, although the app doesnt tell me about any error, when
checking the database only one of the Inserts or Updates SQL commands have
effect. these are more less simutaneously (as humanly possible) and cant
get all of them to take place.  I would like to know if there's any kinf of
flag or semaphore I can check so each app can wait for it to take its turn,
or any other solution.

I need an answer as soon as possible!!!  Than you very much for any help.

2. Help Connecting Applets to Oracle Backend

3. client/server WEB access to SQL Server

4. Processing variable column CSV file thru DTS

5. Accessing a web database from vb app

6. Security question

7. Help - database access from web server

8. Microsoft Commom Controls 6.0 (MSCOMCTL.OCX) ?

9. HELP - DSN less connection on Web server for ASP pages with Access database

10. Access to leagcy (OS/390) data and code from client server apps

11. client - server apps and intranet apps

12. please help, database web app to be put on cd

13. Wanted: pure java database with integrated web / app server