Experienced Elementalist
- Joined
- Aug 5, 2008
- Messages
- 268
- Reaction score
- 28
Continuing with Dios' Guide, I will explain step by step how to create ODBCs for 64-bit OS
This applies for SQL-2000, SQL 2005 (Paid Editions), and SQL 2008 (Paid Editions) only
1. Go to C:\WINDOWS\SysWOW64\odbcad32.exe (DO NOT use "Control Panel\Administrative Tools\Data Sources(ODBC)" in 64-bit)
2. Open it and choose tab "System DSN". Then click on "Add"
3. Scroll down and choose "SQL Server" and then click on "Finish"
4. On Name type MuOnline or whatever ODBC you are creating (Event, Ranking, SCFMuTeam, or any other you need). On Server type (local). Then Click on "Next"
5. In the next window leave as is and click on "Next"
6. Now put a check mark on "Change the default database to:" and change it to MuOnline if you are making the MuOnline ODBC (If creating Ranking ODBC you would ovbiously change the default database to Ranking ^^) and click on "Next"
7. In the next window leave as is and click on "Finish"
8. Now click on "OK"
9. Your ODBC is created and you will see it in the System DSN. It is now ready to work. Now do it for the other databases: Ranking, Event, SCFMuTeam( if you have SCFMT files), MuOnlineJoinDB (Change default DB to MuOnline or Me_MuOnline if you use it), USELOG (Default to MuOnline), LOGIN (Default to MuOnline).
For SQL 2005 and SQL 2008 "EXPRESS" EDITIONS ONLY (32-bit and 64-bit OS)
1. When using Express Editions is a little different and I think this is where most people are having trouble with.
When you open the SQL Management Studio Express you will see the "Server Name" that is YOURPC'SNAME\SQLEXPRESS like this
2. You have to use that exact same Server Name when you are creating your ODBCs in this window like this
And everything else is just the same.
I hope all doubts are now cleared and ENJOY 64-bit SYSTEMS
Credits: KREATOR (ME) for making the guide
This applies for SQL-2000, SQL 2005 (Paid Editions), and SQL 2008 (Paid Editions) only
1. Go to C:\WINDOWS\SysWOW64\odbcad32.exe (DO NOT use "Control Panel\Administrative Tools\Data Sources(ODBC)" in 64-bit)
2. Open it and choose tab "System DSN". Then click on "Add"
3. Scroll down and choose "SQL Server" and then click on "Finish"
4. On Name type MuOnline or whatever ODBC you are creating (Event, Ranking, SCFMuTeam, or any other you need). On Server type (local). Then Click on "Next"
5. In the next window leave as is and click on "Next"
6. Now put a check mark on "Change the default database to:" and change it to MuOnline if you are making the MuOnline ODBC (If creating Ranking ODBC you would ovbiously change the default database to Ranking ^^) and click on "Next"
7. In the next window leave as is and click on "Finish"
8. Now click on "OK"
9. Your ODBC is created and you will see it in the System DSN. It is now ready to work. Now do it for the other databases: Ranking, Event, SCFMuTeam( if you have SCFMT files), MuOnlineJoinDB (Change default DB to MuOnline or Me_MuOnline if you use it), USELOG (Default to MuOnline), LOGIN (Default to MuOnline).
For SQL 2005 and SQL 2008 "EXPRESS" EDITIONS ONLY (32-bit and 64-bit OS)
1. When using Express Editions is a little different and I think this is where most people are having trouble with.
When you open the SQL Management Studio Express you will see the "Server Name" that is YOURPC'SNAME\SQLEXPRESS like this
2. You have to use that exact same Server Name when you are creating your ODBCs in this window like this
And everything else is just the same.
I hope all doubts are now cleared and ENJOY 64-bit SYSTEMS
Credits: KREATOR (ME) for making the guide
Last edited: