dsn « MS Access « Java Database Q&A





1. Creating a DSN-less connection for MS Access within Java    stackoverflow.com

I'm building a desktop app that needs to communicate with a MS Access database. Now, unless I want to register the DSN for the database on every computer that's going to ...

2. Java MSAccess DSN Less    stackoverflow.com

So the problem is that I want to make a connection to a msaccess database that has password every time you open it.

  • The password works if I directly open ...

3. jdbc:odbc with DSN less connection for MS Access    coderanch.com

hi Edmon so: thank you so much for replying. I really appreciate it. I tried it with JDK1.1.8; 1.2 and 1.3 It only works under JDK1.3. However I have to use JDK1.1.8, since I am using PersonalJava VM -- this is an application runs on winCE and we need to use java vs. VB...... under JDK1.1.8 the error is: java.sql.SQLException: [Microsoft][ODBC ...

4. MS Access with DSN    coderanch.com

6. MS ACCESS DSN less Connection    coderanch.com

7. MS Access DSN Less conn. Problem    coderanch.com

8. Connectting to MS Access in Remote machine without DSN    coderanch.com

You can connect from a Windows machine to an MDB file that resides on a Linux machine using this method, but you cannot connect from a Linux machine to a MDB file residing on another computer this way. This "DSN-less" connection is not really DSN-less. Instead of configuring an explicit System or Machine DSN using the ODBC manager on a Windows ...

9. Problem with DSN less Connection with MS Access 2000    coderanch.com

Most people don't have time to wade through a bunch of code, so if you could distill your problem down to a few lines of code, you might get some more responses. Also, please post any exceptions you code generates. One thing you might look at is updates and inserts routinely fail because of problems related to the keys.





11. Connecting to remote ms access without DSN    forums.oracle.com

I used the following code to connect to a microsoft access database which is kept in LAN:- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String path=request.getParameter("path"); path=path.replace(" ","/"); out.print("Path= "+path); String myDB ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+path; con = DriverManager.getConnection(myDB,"Admin","WDNBASEALLDATABASE"); This is working fine when database is kept in the local machine itself and even when the path of the local machine is given from the the network.But ...