OK, I'm a linux fan running in Red Hat 7.1, Tomcat, postgresql and I use
Microsoft Access to get my postgresql database, MicroAccess is not one
definition or engine, is a tool, don't be so extricted with yourself, of
course, for the web jdbc is the best: one piece of advise: ddo u have sql
server running ?, well, use it with jdbc, with a linux server, tomcat and so
on you can access your sql server or in case that your people is only using
.mdb, well, install a database manager but keep yourself using Microsoft
Access to access your database, for the web, only for the web, use jsp, do
not try to reinvent the wheel my friend !!!, that's all...
Regards...
Guido.
P.D: I also hate ASP :-)
----- Original Message -----
From: "aswath satrasala" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 1:33 PM
Subject: Re: JDBC/ODBC: Technological choice
> Hi,
> First, I would like to point the restrictions Access
> will place in using standard SQL, when you are
> using JDBC or JDBC-ODBC.
> You may not have the same flexibility in your SQL as with
> SQL server or oracle.
>
> Assuming you know the limitations, you are better off
> using ASP, if you are using Access. I am not discouraging
> you from using JSP. You can as well persuade to use
> SQL server and starting working on JSP.
> Working with JDBC/tomcat/JSP is simple, I don't have
> any problems in my application.
>
> However, considering the deployment question, we
> are still thing of deployment, as you may have to
> write scripts to set the datasource (if you are using jdbc-odbc).
>
> -Aswath
>
>
>
>
> >From: Alexandre Bouchard <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: tomcat-user <[EMAIL PROTECTED]>
> >Subject: JDBC/ODBC: Technological choice
> >Date: Wed, 23 May 2001 20:34:29 -0400
> >
> >Hello guys
> >
> > I am building an intranet on a window NT environment. I hate ASP, so
I
> >decided to use JSP as the server-side language. I chose Tomcat to run my
> >JSP
> >and I installed it as a IIS plugin.
> >
> > Now, I have to connect my JSPs with the databases (they use
Access --
> >ouch! ) I never did that before and I don't know if I should use JDBC I
or
> >IV. So my questions are:
> >
> >-first, is it possible to use a JDBC IV sheme with Tomcat
> >
> >-if so, how is it possible? How is it made? In other words, where can i
> >find
> >documentation about that?
> >
> >-why it is recommended to use JDBC IV when dealing with intranet?
> >
> >-JDBC-ODBC bridge vs JDBC IV: how slower? Which one is simplier to setup?
> >
> >-Finally, is it difficult to deal with JDBC, to deploy it?
> >
> >A lot of question, isn't it?
> >I would also apreciate if some of you could share their experience of
> >building a JDBC/JSP/Tomcat infrastructure.
> >
> >Thx !
> >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
