jdbc-odbc cannot connect

[ArneBassez]

Hi,

I'm using a standard connection code for jdbc-odbc.

But I keep getting:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

-I've done everything on the microsoft page. (regedt32.exe : OCDB.INI set permissions to all, but no DSNName visible..also MAKER EIGENAAR doesnt have permission, - in english MAKER OWNER)
-uninstalled access, installed New Database Manager for office 64bit and reinstalled access.
- downloaded MDAC_TYP for 32-bit drivers.
-Changed permissions in control panal - data source . Also changed Target and Start
- changed location of my database to c:/users/Arne instead of C: since I always need to give authorization to write there.

if I execute: c:\windows\sysWOW64\odbcad32.exe I see all drivers

I get the message that driver is loaded, so I don't think problem is there, more likely in the authorization department :)...

This is really driving me crazy, spent many hours trying to fix it. And it might be an easy solution.

Just to be sure, here is my code:):

package Database;

import java.sql.*;

public class Database {

private Connection dbConnection;

    //constructor
    public Database(String dbFile)
    {
        loadDriver();
        connectDatabase(dbFile);
    }

    //driver laden
    private void loadDriver()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            System.out.println("Laden van de driver is gelukt.");
        }
        catch (ClassNotFoundException e)
        {
            System.out.println("Kan de driver niet in de classpath vinden.");
            e.printStackTrace();
            System.exit(1);
        }
    }

    //connectie tot stand brengen
    private void connectDatabase(String dbFile)
    {
        try
        {
            String protocol = "jdbc";
            String subProtocol = "odbc";
            String subName = "Driver={Microsoft Access Driver (*.mdb,*.accdb)}; " + "DBQ=" + dbFile;
            String URL = protocol + ":" + subProtocol + ":" + subName;

            dbConnection = DriverManager.getConnection(URL);
        }
        catch (SQLException error)
        {
            System.err.println("Error connecting to database: " +
                               error.toString());
        }
    }

    public Connection getDbConnection()
    {
        return dbConnection;
    }

    public void closeConnection()
    {
        try
        {
            dbConnection.close();
        }
        catch (SQLException error)
        {
            System.err.println("Cannot disconnect database");
        }
    }

}

[demonick]

Either database is not found, wrong name/URL or security issues.

[mine0926]

Please use code tags [CODE] [/CODE] .


Did you put password on your database? If yes, you have to give the username and password when trying to
connect in database.

[b]EXAMPLE:[/b]
dbConnection = DriverManager.getConnection(URL, "myUSERNAME", "myPASSWORD");

[ArneBassez]

No, there is no password on my MS access database.

I have no problem making a connection on my old computer with the same database and program.

[mine0926]

Check the path that you input and the actual location of your database.