carlleese24 Posted April 16, 2010 Share Posted April 16, 2010 Hi I wonder if some could Kindly please help me. I want to be able to access a database file which is in MS access 2003How do I setup my Connection properties in order for me to do this JDBC DriverJDBC URlthe file is in this directory C:\db1.mdb Carl Link to comment Share on other sites More sharing options...
carlleese24 Posted April 17, 2010 Author Share Posted April 17, 2010 Hi I have finally done it after 12 hours of searching different forums and here is the solution if anyone else has this problem. I am using Ireport Version and Windows xp what I did is as follows I had to setup a a DSN for Access databaseTo do this I went through these steps 1. Goto start and control panel. Select administrative tools.2. In that select DataSources (ODBC).3. Click on the right side pane. click Add button4. I selected Microsoft Access Driver [*mdb]5. click finish6. Goto select and find the databse name on the drive. Select the location. (Here you are finding the database file you want)7. Once you have found the file click okay8. Leave system database has none9. Put a name in the Datasource call it what ever you want10. go to right panel and click okay11. Find the Dsn name added to the list. (Just to make sure its there) Now we set that up we now setup Ireporting1. Open it up2. Click data on the top menu its next to Format3. click Connections/ Datasources4. Click New button on the right panel5. Select Database JDBC connection6 .Click next7. Name : Type a name in call it what ever you want8. JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver9. JDBC URL: jdbc:odbc:??????? 10. In the question marks you put the name you called the datasource on step 9 on how to setup setup a a DSN for Access database11. Server address: leave blank12. Database: leave blank13. Database: leave blank14. Username: leave blank 15. Password: leave blank16. Test it make sure it connects okay17. Click Save18. Select the datasource you have just done and click set as default I am just a newbie on Ireporting I hope this will of some use for all those newbies outthere Carl Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now