Connecting Remote DataBase

Hi,

Could any one tell me how to connect with Remote Database.
for e.g, I am having a Ms-Access database in a machine which is windows NT,
i need to connect that database from a solaris machine, but both are web servers.

It is possible, if yes how ?

Thanks,
G Ramesh
rameshg21Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ravindra76Commented:
Hi Ramesh,

Ms-Access won't be connected like that.

See Jdbc drivers info

Best answer: Vladi21

Java Database Connectivity is a standard SQL database access interface, providing uniform access to a wide range of relational databases. It also provides a common base on which higher level tools and interfaces can be built. This comes with an "ODBC Bridge" (except on Mac 68K). The Bridge is a library which implements JDBC in terms of the ODBC standard C API.
http://java.sun.com/products/jdk/1.1/docs/guide/jdbc/index.html 
http://java.sun.com/products/jdbc/index.html 
http://java.sun.com/docs/books/jdbc/intro.html 
http://java.sun.com/products/jdbc/faq.html 

Silicaon Valley Java SIG JDBC Talk Page
http://www.hooked.net/~gturner/JDBCTalk.html 

Java how-to DB section
http://tactika.com/realhome/javaht/java-d1.html 

articles from Oracle:
http://technet.oracle.com/tech/java/sqlj_jdbc/index.htm 

JDBC 2.0 New Features
http://java.sun.com/products/jdk/1.3/docs/guide/jdbc/getstart/appendixA.html#1006294 
http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/index.html 

MS bridge
http://www.microsoft.com/Java/sdk/relnotes/JDBCrel.htm 

Drivers:
http://java.sun.com/products/jdbc/drivers.html 
http://www.idssoftware.com/jdriver.htm 

Books online
http://www.itknowledge.com/reference/standard/1576100561/book-index.html 
Java Database Programming with JDBC
http://www.itknowledge.com/reference/standard/1576100561/book-index.html 
Java 1.2 Unleashed : Connecting to Databases with the java.sql Package
http://www.itknowledge.com/reference/standard/1575213893/ch44/ch44.htm 

and some useful DB stuff:
InstantDB
http://208.234.21.207/ 

WebLogic JDBC (30 day trial)
http://www.beasys.com/download/weblogic.html 

http://www.thoughtinc.com/cocofree/doc/index.html 

http://www.agave.com/html/products/jdbc_dwnld.htm 

--
Multilingual Databases and Global Internet Integration
http://www.chg.ru/inet97/A8/A8_2.HTM 


Summary :

You are using Ms-Access ( ODBC )
JDBC-ODBC bridge won't support networking.

Best of luck
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vladi21Commented:
http://java.sun.com/products/jdbc/faq.html#5
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

Most desktop databases currently require a JDBC solution that uses ODBC underneath. This is because the vendors of these database products haven't implemented all-Java JDBC drivers.


The best approach is to use a commercial JDBC driver that supports ODBC and the database you want to use. See the JDBC drivers page for a list of available JDBC drivers.

The JDBC-ODBC bridge from Sun's Java Software does not provide network access to desktop databases by itself. The JDBC-ODBC bridge loads ODBC as a local DLL, and typical ODBC drivers for desktop databases like Access aren't networked. The JDBC-ODBC bridge can be used together with the RMI-JDBC bridge , however, to access a desktop database like Access over the net. This RMI-JDBC-ODBC solution is free. http://dyade.inrialpes.fr/mediation/download/
0
rameshg21Author Commented:
Thanks to vladi & ravindra

thank you very much for the list of URL's provided.

Regards,
G Ramesh
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.