Java Answers Forum - want to create access db from java using jdbc

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
want to create access db from java using jdbc

4 replies on 1 page. Most recent reply: Oct 12, 2005 5:30 AM by Kondwani Mkandawire

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 4 replies on 1 page

Hemal Kotak

Posts: 2
Nickname: hems
Registered: Oct, 2005

want to create access db from java using jdbc

Posted: Oct 12, 2005 2:32 AM

hi i want to create a access database from java jdbc as i m developin database converter if anyone knows then pl. reply soon and pl. tell me which driver to use which must be freeware and give the site name from where i can download the driver , and if anyone has developed the db converter in java then pl. post to me thanks

-Hemal

Kondwani Mkandawire

Posts: 530
Nickname: spike
Registered: Aug, 2004

Re: want to create access db from java using jdbc

Posted: Oct 12, 2005 2:47 AM

Use Jdbc-Odbc driver that comes with Java, then on your
Windows machine configure you database using the odbc
Configuration Application that comes with most Windows
version. On windows run a Search for "*odbc*.*" one of
the apps that show up as the search result is you
Configuration application. Double click it, make sure
you have the correct database name source - that should
be what determines your url when you are connecting
via DriverManager.connect(url, user, password).

Matthias Neumair

Posts: 660
Nickname: neumi
Registered: Sep, 2003

Re: want to create access db from java using jdbc

Posted: Oct 12, 2005 4:53 AM

I think his problem is to create a new DB.

Your solution offers only access to an existing DB.

I once read something about how to do this, but I can't remember it. It was in this forum, so using the search engine would probably help.

Matthias Neumair

Posts: 660
Nickname: neumi
Registered: Sep, 2003

Re: want to create access db from java using jdbc

Posted: Oct 12, 2005 4:54 AM

btw: I donT believe ODBC is able to create a new DB.

Must take a look at the driver I'm using (IZMADO, costs 150 Euro) if it's able to do it.

Kondwani Mkandawire

Posts: 530
Nickname: spike
Registered: Aug, 2004

Re: want to create access db from java using jdbc

Posted: Oct 12, 2005 5:30 AM

> btw: I donT believe ODBC is able to create a new DB.
>
> Must take a look at the driver I'm using (IZMADO, costs
> 150 Euro) if it's able to do it.

No need to spend all that money, use the ODBC Configurator.
It has an Option to create a New Database - I've done
it before though a while back on an Oil Project.
odbc32 I believe its called comes with windows - just
run a Search with it. It used to take me a while
poking around the Configuration App, but believe me
it can create a New Database. What you do is then you
write an App. that can Create Tables, run Inserts on your
tables etc.

Good luck.
Spike

Flat View: This topic has 4 replies on 1 page

Previous Topic

Next Topic


	Web Artima.com