A total newbie here with some questions.. please help!

[m3du5a]

Hey all.. I've been using tomcat + microsoft sql server, now Im trying to switch it to tomcat + MySQL, but im totally new to it. Been reading up a little but Im still unsure of some things.

1. Is is a big difference in coding whether it's installed on win98 or win2k or winXP systems?

2. I downloaded the mysql-3.23.51-win and installed it but I dun knoe how to go about using it. I installed it on a win98 system. Do I need the MyODBC thingey or sumthin? Totally confused here..

3. Are the connection statements similar to the way we use it for mSQL?

I apologise for my ignorance here but I reallie have no idea .. Please help!! ~>_<~

 

[laffreuxthomas]

2 -> You have to choose: you can access mysql through ODBC with MyODBC. You can access mysql with a JDBC driver. I think the name of the official jdbc driver is &quot;ConnectorJ&quot;. It's a jar file, that you have just to reference in the classpath.

3 -> Yes, with many limitations. See the list in the documentation on the mysql web site. Note that date functions are very different.

Thomas ---
A free GUI for your database:

http://www.sashipamelba.com

 

[likelylad]

I found this site very good to get you up and running and to give you a better understanding of MySQL

http://www.devshed.com/Server_Side/MySQL

 

[m3du5a]

Thank you all so much.. I will read it up.
Thanks alot!