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
