if you want to use ODBC, then you have to install the ODBC driver for the DB
you're using, and then create a DSN that references the remote DB. Then you
can use the odbc url -> jdbc:odbc:<dsn>
----- Original Message -----
From: "Zheng, Jennifer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 4:01 PM
Subject: Re: About remote database access
I haven't tried odbc, but for oracle jdbc connection, the url would be
url = "jdbc:oracle:thin:@hpcad145:1521:fe_d";
so for the odbc, it could be protocol followed by subprotocol followed by
@machinename:port:dbname as well.
-----Original Message-----
From: Brad Webb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 3:02 PM
To: [EMAIL PROTECTED]
Subject: Re: About remote database access
Hello,
I am doing something similar and I wrote a dataserver that runs as a java
application on the machine that contains the database. I also wrote a client
that
connects via sockets to this dataserver. I subclass the client
and describe my request and the client sends the request to the dataserver
which
submits the appropriate query locally to my Oracle database. Then the
results are
sent back to the client.
Hope this helps.
Brad Webb
Celal Ceken wrote:
> Hi everybody,
> I want to use a remote database(For example my Database is in another
server
> ). How can I connect this database. (Database that I use is an access
file.
> I use ODBC ).
> String url="jdbc:odbc:Veri"; When the database is in my server there is no
> problem. If the database is in "http://lab19:8080" , What can I do??
> String url="jdbc:odbc:?????";
> Thanks for your help,
> with regards,
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> 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".
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".
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".
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
