need some help with MysQL

[TechBoyJK]

Hi,

I have an app written and I just need to migrate the DB from Access to mySQL. I was going to use MS SQL, but I want to try mysql cause its free.

ANyways, I used the migration toolkit, and I migrated a .mdb file which contained 7 tables. After the migration, I was left with a folder with the name of the .mdb file, and the tables in the folder as individual files.

My app is written using ODBC datasources. How can I replace the datasource with a new one that will point to the mysql data?

I already have Mysql server running.

Thanks!

 

[mugs]

Have you considered MSDE? It's a free, stripped down version of SQL Server that is perfectly fine for most applications that won't have a lot of users connecting to the DB at the same time.

 

[EagleKeeper]

If the app points to an ODBC connection, then using the Admin tools for ODBC, just change the location of the DB to use.

If not already done, you need to define a connection for the MySQL database.

If the actual name of the database is built into the code, change it to point to a ODBC connection.

 

[TechBoyJK]

Originally posted by: mugs
Have you considered MSDE? It's a free, stripped down version of SQL Server that is perfectly fine for most applications that won't have a lot of users connecting to the DB at the same time.

The app needs to be able to handle thousands of users. Its either mySQL or MS SQL for this one.