Hi people..

I am building an interface which displays the database information...according to the specified datasource name..

The problem is to determine wheter an attribute is the primary key or not of the corresponding table??

When i execute the following statement :

ResultSet rs = dbMetaData.getPrimaryKeys(null, null, tableName);

i get an exception


java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support this function

Do you have any suggestions...??? Sincerely i dont know what i can do..If it can helps the database i m connecting to is an access 2000 database and i am connecting to the database like this:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbcdbc:"+dataSourceName,username,password);


Regards


Sandro