We can say that because Access is a lousy multi-user database, and JdbcOdbc
is almost as good as Access. Single-threaded, buggy crap is what it is,
sufficient only for testing until you get a real JDBC driver.
>From: Atilio Ranzuglia <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Accessing a remote database
>Date: Wed, 18 Jul 2001 05:18:39 -0700
>
>How can you say that! Don't you see that the driver is
>a bridge between JDBC and ODBC, so you can virtually
>connect any database via ODBC.
>
>Hamid: try the following code I found on the Internet
>
>// Register JDBC/ODBC Driver
>// On some platforms with some java VMs, newInstance()
>is necessary...
>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
>
>// Test with MS Access database
>String url = "jdbc:odbc:demo";
>java.sql.Connection c =
>DriverManager.getConnection(url, "user", "pass");
>java.sql.Statement st = c.createStatement();
>java.sql.ResultSet rs = st.executeQuery("select * from
>table");
>
>You have to define the ODBC driver in control panel,
>in the previous example the ODBC source was named
>'demo'.
>
>Good luck
>Atilio
>
>
>
>
>--- Le van Thu <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Access (Desktop Database) can't do that, you need an
> > EnterPrise Database as
> > : DB2, Oracle.
> > Hope this help,
> >
> > ThuLV,
> >
> > ----- Original Message -----
> > From: "Hamid Mukhtar" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 18, 2001 12:09 AM
> > Subject: Accessing a remote database
> >
> >
> > > Hi,
> > > I want to upload information from a
> > database registered with
> > client to my
> > > server.In Wrox's Professional JSP, author has used
> > the path ,say,
> > > "jdbc:mysql://234.56.12.22/mydb"
> > > to connect to a database located on a machine
> > with IP "234.56.12.22". I
> > > haven't try that because I dont use mysql. I use
> > MS-Access and tried in
> > > analogy to that,
> > > "jdbc:odbc://localhost/mydb",
> > > however it doesn't work. Does anybody know how to
> > make an access to
> > > remotely located database?
> > > Thanks,
> > > Hamid Mukhtar
> > >
> > >
> >
>===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff
> > JSP-INTEREST".
> > > For digest: mailto [EMAIL PROTECTED] with
> > body: "set JSP-INTEREST
> > DIGEST".
> > > Some relevant FAQs on JSP/Servlets can be found
> > at:
> > >
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > >
> >
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
>===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body:
> > "set JSP-INTEREST DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
>=====
>Ing. Atilio Ranzuglia Buteler
>[EMAIL PROTECTED]
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
