Oh, but Access also uses a somewhat strange derivative of SQL, so you
might still find it easier to use other databases with your app if you use
a native SQL database to start with. Go to IBM's software site and
download a copy of the developer version of DB2 6.1 Personal Edition
somewhere under http://www.software.ibm.com. It's not a timebombed copy.
It's the full personal edition of DB2, which does everything the larger
packages does but won't accept connections over the network (meaning that
the database need to run on the same host as the JDBC client).
/Robert
Rob Hazlewood <[EMAIL PROTECTED]>
Sent by: "A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology." <[EMAIL PROTECTED]>
2000-05-14 17:15
Please respond to "A mailing list for discussion about Sun Microsystem's
Java Servlet API Technology."
To: [EMAIL PROTECTED]
cc:
Subject: Re: [Re: [Re: JDBC-ODBC-Access 97]]
I fully agree!!
access is a heap of shit!
the only reason why I (was) using it was for developing purposes. I am
writing
a program that interfaces large databases - the consumer company should be
able to run it on any database. When i'm developing, i probably won't have
any
more than 20 records in each table, and i thought the access db might be
the
easiest to maintain (i'm leaving the url and driver strings configurable)
okay??!
now you know why i was using access - it actually runs really quickly when
there are 20 records :)
thanks, hopefully you understand
Rob
Danny Rubis <[EMAIL PROTECTED]> wrote:
> Hey!
>
> I was wondering when you were going to give up on Microsoft Access.
> You were beating your head against the wall and it was getting bloody.
> By my definition and others, Access is not a real DB.
>
> dbAnywhere is not free. Since you have to pay something, buy
> yourself a DB. Preferably not SQServer because a good
> Type 3 JDBC driver for that thing costs $5000 (Merant).
> Most other DBs include a Type 3 JDBC driver, subsequently,
> DB + driver costs less than $5000. There are many
> other reasons why you should not use SQServer. I have
> experience and if you are interested send me an private E
> for more reasons.
>
> Sans adieu,
> Danny Rubis
>
> Rob Hazlewood wrote:
>
> > Thanks alot - thats what i wanted to know!
> >
> > where would i be able to get the dbAnywhere?? or should i just use a
totally
> > different database. I decided to use access for developing as it is
really
> > easy and quick to change the data in them, but i was always going to
> > distribute with connectivity to any database
> > is access still the easiest db to use?
> >
> > thanks alot
> > Rob
> >
> > Mahmood Shahzad <[EMAIL PROTECTED]> wrote:
> > > AoA
> > >
> > > First thing Access does not provide its services on a particular
port
like
> > any
> > > server. So there is no port for Access.
> > > There seems only one way to be effective. You will have to use
dbAnywhere
> > > server. A middle tier like service providing the facility to access
database
> > and
> > > connection. You have to install it on your NT machine and configure
a
DSN
> > in
> > > dbAnywhere(its own DSN not of ODBC DSN) against the DSN you have
already
> > > configured in ODBC. Then you can access this database from anywhere.
> > Connection
> > > String will be available in the dbAnywhere Server's DOCs.
> > >
> > >
> > > Shahzad
> > >
> > >
___________________________________________________________________________
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in
the
body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources: http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> > ____________________________________________________________________
> > Get free email and a permanent address at http://www.netaddress.com/?N=1
> >
> >
___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
