MSACCESS Connection
posted 17 years ago
Could someone please explain how to connect to the MS Access Database using JDBC completely. I am really frustrated using JDBC. I tried using the Microsoft Text Driver for a simple databse and the error I recieved was : " Cannot Create Table, The Databse is in a Read Only Mode"
Any explanations???
Thanks In Advance!
Any explanations???
Thanks In Advance!
Commentary From the Sidelines of history
posted 17 years ago
To connect to MS Access you have to create a DSN first.Assuming you are using Windows 98 or above,
Select control panel from Windows menu, Select ODBC. Follow the directions to create a new Data Source Name selecting MSAccess driver and add it to the list of DSNs.
A good first lesson in JDBC is 'Duke's Bakery' provided in Sun's tutorials.Check it out.
Select control panel from Windows menu, Select ODBC. Follow the directions to create a new Data Source Name selecting MSAccess driver and add it to the list of DSNs.
A good first lesson in JDBC is 'Duke's Bakery' provided in Sun's tutorials.Check it out.
Originally posted by Sriraj Rajaram:
Could someone please explain how to connect to the MS Access Database using JDBC completely. I am really frustrated using JDBC. I tried using the Microsoft Text Driver for a simple databse and the error I recieved was : " Cannot Create Table, The Databse is in a Read Only Mode"
Any explanations???
Thanks In Advance!
|
All of life is a contant education - Eleanor Roosevelt. Tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
|