This webapp demonstrates jdbc-odbc connection with ms access database using servlets and jsp.
Download the netbeans project
Before running the project:
1)make ms access database with 1 table called 'student'
2)student has 2 columns(attributes) name and day. Both attributes are of type text.
3)Add DSN for this database, Watch Tutorial
Set name of DSN as 'dsn1' instead of "NWIND-DSN" as shown in above tutorial.
4)Run the project in netbeans.
Download the netbeans project
Before running the project:
1)make ms access database with 1 table called 'student'
2)student has 2 columns(attributes) name and day. Both attributes are of type text.
3)Add DSN for this database, Watch Tutorial
Set name of DSN as 'dsn1' instead of "NWIND-DSN" as shown in above tutorial.
4)Run the project in netbeans.
Thanx a lot for this urgent post :)
ReplyDeleteIf anyone has problem locating drivers of microsoft access 2007 it is available here
ReplyDeletehttp://www.microsoft.com/download/en/confirmation.aspx?id=23734
wht to browse in the dsn??
ReplyDelete@above_comment :
ReplyDeleteBrowse to the database file you made in access
It must be of extension .mdb or .accdb