you said: "You need to change that account to one that has access to your mdb. You can do that through the Services console. Or try starting Tomcat via the startup.bat file, that should launch Tomcat with the same account you've logged into your system with, which hopefully is the same account you need to for "Access". "
I don't know how to do these...Can you explain for me? Also startup.bat is not there in the specified directory. On Sat, Apr 16, 2011 at 1:48 AM, Leo Donahue - PLANDEVX < leodona...@mail.maricopa.gov> wrote: > >-----Original Message----- > >From: RAHUL RAJ [mailto:omrahulraj...@gmail.com] > >Subject: Re: Working of Tomcat with MS Access > > > >Yes, it runs as a service. But how to know under what account does that > >service run? does it mean 'admin' or 'normal user' or 'system'? > >I made a system DSN for this...not the user DSN(Data Source Name) > >and I launched tomcat service by right click 'run as admin' > > I'm really surprised you have had as many responses to this thread as > you've had. > > Assuming you have Tomcat installed as a Windows service, usually the > default account that runs Tomcat as a Windows service is "Local System > Account". You need to change that account to one that has access to your > mdb. You can do that through the Services console. Or try starting Tomcat > via the startup.bat file, that should launch Tomcat with the same account > you've logged into your system with, which hopefully is the same account you > need to for "Access". > > The code you posted should work, although I can't understand what the > purpose of your assignment is. Don't get in the habit of using this code > for anything related to logging in, or anything else. > > If you must stay in the MS world, use SQL Express. > > try { > Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver"); > Connection con = > DriverManager.getConnection("jdbc:odbc:rahul","",""); > > Statement stmt = > con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY); > String query = "Select whatever"; > > ResultSet rs = stmt.executeQuery(query); > > while(rs.next()){ > // do stuff > } > rs.close(); > stmt.close(); > con.close(); > } catch(SQLException ex) { > > } catch(java.lang.ClassNotFoundException jdbce) { > > } > >
