Hi:

As a JAVA beginner, I just download J2SDK1.4.2 and NetBeans IDE 3.6. for Windows.

I have some questions on JDBC driver and SQL function:

1) How to find a Driver Name for Access 2000 or MS SQL except JDBC-ODBC Bridge (I have Access 2000 and SQL on my PC) for Class.forName(). --(.Jar files only?)

2) Can I directly code Driver and its attributes for Data Source in URL instead of DSN? And how to code them?

3) How to drop a table from a database, for example to drop a table in a MS SQL file. I can't find sample code for table drop neither in NetBeans nor JAVA (only found updating and querying).

Appreciate your help!