ODBC Driver Manager Connection Problems (to Access)

[Essie]

I'm having problems connecting to the ODBC Driver on my Laptop. (I'm trying to connected my NetBeans project to a Microsoft Access database)
This is the steps I follow when I try to connect to it.
I go to ODBC Data Dource Administrator, System DSN and click to add system datasource.
The Only Driver available is SQL Server.
I enter these details when i click to add it.
Name: GPSQL
Description: ODBC connector for MS Dynamics
Server: DELPHSQL\DYNAMI CSSQL
But I get a Microsoft SQL server login error
SQL Server Error: 11001

Any help on how to set up the connection or advice on what i am doing wrong?

Thanks

[NeoPa]

Two questions :

1. Why do you think Access has an ODBC driver?
2. Why would you try to connect to a SQL Server instance if you need to connect to an Access database?

Access is not a SQL back-end server. Even using a back-end database in Access, all the processing is done by the front-end instance of Access. Does that help to clarify?

[Essie]

1. In my project i have created a connection to my Access database and when i run the project i get this error
java.sql.SQLExc eption: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I saw a video on youtube and they used an ODBC Driver to make the connection.
It works ok on the PC's in college when I connect to "Microsoft Access Driver (*.mdb. *.accdb)"
By having this connection its prints out the info in my database.


2. I used SQL Server, beacuse it was the only driver that is listed when I go to add a system data source.

[NeoPa]

This is probably not the forum for this question. NetBeans implies something open-source to me. What are you programming in - Java? If you let me know I can move this thread to the appropriate forum for you.

You have answered intelligently however. I'm no expert in NetBeans or Java, but I suspect that the reason the driver is unavailable on that particular PC is because it hasn't been installed. I would expect that to be automatic with the installation of Office or Access, but there may also be downloads available for just that driver. probably worth a look.

Using SQL Server won't work I'm afraid. That's a blind-alley.

[Essie]

Yes I am programming in Java, using NetBeans IDE.

Thank you for you help.

[NeoPa]

I'm not sure I was a great deal of help, but I can at least move this for you to the Java forum. Best of luck going forward.

[kuldeeprsks]

Connecting to Ms Access with ODBC require [Microsoft Access Dreiver(*.mdb)] create your DSN and then move forward for sun.JDBC.ODBC connection.