• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

need some help with MysQL

T

TechBoyJK

Lifer
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!
 
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.
 
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.
 
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.
Click to expand...

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

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top