> I would like to know if MySQL work with ODBC or JDBC. Does it
> take just ODBC
> or JDBC?
>
> Also do you have a DSN to work with your database, or you can use
> a DNS-less
> connection?
>
> If I setup an id for a field, can it autu increment by itself?
I don't know about JDBC but it definately works with ODBC, I have a linked
MS Access using ODBC to MySQL (uses DNS) that I give our less tech-savvy
administrators so they can make modifications to the information contained
within MySQL w/o me worrying about them breaking anything :)
As for auto incrementing...as long as you specify you specify the field to
be auto incrementing and it's an integer than it should work (I don't
remember if MySQL allows more than one auto incrementing field in a table)
ex.
CREATE TABLE foo (
id INT unsigned NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
PRIMARY KEY(id)
);
Sincerely,
Craig Vincent
