is a mysql database any different from any other sql database ?

also can you connect to mysql data via .ado rather than odbc ?

thanks steve

steve

Is it different? Not any more than Access differs from MSSQL - it does have some features that other RDBMSs doesn't have, like the LIMIT-clause.

I usually connect (from ASP) using a connectionstring like this:
strConn = "Driver={mySQL};Server=localhost;Option=16834;Data base=xxxxxx;UID=xxxxxx;PWD=xxxxxx;"

You might want to have a look here:
http://www.connectionstrings.com/

The MySQL-manual is located here:
http://www.mysql.com/doc/en/index.html

my question i guess is can a sql file be read by any server ....mysql,microsoft or do you have to read a sql file with the same as it was written?

steve