Creating ODBC 64-bit OS (Continuing Dios' Guide)

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)
http://img97.imageshack.us/img97/7008/50919347.jpg

2. Open it and choose tab "System DSN". Then click on "Add"
http://img10.imageshack.us/img10/4205/20659561.jpg

3. Scroll down and choose "SQL Server" and then click on "Finish"
http://img17.imageshack.us/img17/7385/71922752.jpg

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"
http://img21.imageshack.us/img21/6240/42238556.jpg

5. In the next window leave as is and click on "Next"
http://img23.imageshack.us/img23/8065/83643010.jpg

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"
http://img36.imageshack.us/img36/9421/49827359.jpg

7. In the next window leave as is and click on "Finish"
http://img195.imageshack.us/img195/1008/80529034.jpg

8. Now click on "OK"
http://img5.imageshack.us/img5/9606/60276979.jpg

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
http://img7.imageshack.us/img7/5621/22397753.jpg

2. You have to use that exact same Server Name when you are creating your ODBCs in this window like this
http://img17.imageshack.us/img17/2281/19981698.jpg
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

all done :D

I am solution the problem with odbc but now i have the problem dont conect to the server the client no conect.

I ned you help

5. In the next window leave as is and click on "Next"

???

u p ut ur sql pass lol xD

Quote:

---

Originally Posted by karLi

5. In the next window leave as is and click on "Next"

???

u p ut ur sql pass lol xD

---

no you do NOT. Its gonna connect through windows authentication which is safer

dont teach me -.- i do with that way and it works
why the heck sql must connect to administrator acc?
and not MY-PC account name?
eh?
yea it connect to whatever but if u get errors with event and so then ^^?

you ust made an I-know-everything comment. SQL does not connect through Administrator acc... ODBCs are being made with Administrator acc(windows authentication). I am not saying putting sql username and password does not work, Im just saying windows authentication is more secure and works just as good as typing sql username and password, you will never get errors using win authentication unless you put a wrong name for the ODBC...

the easiest way its..

edit the odbc.req with notepad
and put this



Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline _Event]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="Event"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline JoinDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Ranking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="Ranking"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MuOnline_Event"="SQL Server"
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"Ranking"="SQL Server"
"USELOG"="SQL Server"

AND That works great

Quote:

---

Originally Posted by karLi

the easiest way its..

edit the odbc.req with notepad
and put this



Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline _Event]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="Event"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline JoinDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Ranking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="Ranking"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)" <<--- ur PC - NAME
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MuOnline_Event"="SQL Server"
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"Ranking"="SQL Server"
"USELOG"="SQL Server"

AND That works great

---

that wont work with 64-bit

omg think whatever u want ;D

first time i had win 64bit
i had errror on odbc
and i did that and it runned.

Where i can find it on vista windows? C:\WINDOWS\SysWOW64\odbcad32.exe i cant find SysWOW64 folder.. sry.. i find it :D

Sql Server 2008 6 base de dato


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MU2003_EVENT_DB]
"Driver"="c:\\Windows\\system32\\sqlncli10.dll"
"Server"="DSDESISTEMA-PC" --- Tu nombre de la pc o Sql2008
"Database"="MU2003_EVENT_DATA"
"LastUser"="Ds de Sistema"---- Usuario de windows
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Muonline]
"Driver"="c:\\Windows\\system32\\sqlncli10.dll"
"Server"="DSDESISTEMA-PC"
"Database"="MuOnline"
"LastUser"="Ds de Sistema"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB]
"Driver"="c:\\Windows\\system32\\sqlncli10.dll"
"Server"="DSDESISTEMA-PC"
"LastUser"="Ds de Sistema"
"Trusted_Connection"="Yes"
"Database"="Me_Muonline"
"Language"="日本語"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"Muonline"="SQL Server Native Client 10.0"
"MuOnlineJoinDB"="SQL Server Native Client 10.0"
"USELOG"="SQL Server Native Client 10.0"
"MU2003_EVENT_DB"="SQL Server Native Client 10.0"
"RANKING_DATA"="SQL Server Native Client 10.0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\RANKING_DATA]
"Driver"="c:\\Windows\\system32\\sqlncli10.dll"
"Server"="DSDESISTEMA-PC"
"Database"="Ranking"
"LastUser"="Ds de Sistema"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG]
"Driver"="c:\\Windows\\system32\\sqlncli10.dll"
"Server"="DSDESISTEMA-PC"
"Database"="MuLog"
"LastUser"="Ds de Sistema"
"Trusted_Connection"="Yes"

can someone help why my data server wont start? :|

Quote:

---

Originally Posted by DZINTAS

Where i can find it on vista windows? C:\WINDOWS\SysWOW64\odbcad32.exe i cant find SysWOW64 folder.. sry.. i find it :D

---

thats only if u have a 64-bit OS
if 32-bit just use the regular ODBC

Hello, thanks for guide, i follow it step by step, but i still got this error, en ExDB logs:

Quote:

---

12:59:59p ExDB Server Start!!
01:00:24p ExDB Server Start!!
01:06:30p SQLSTATE:42000, diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]No se puede abrir la base de datos "MuOnline" solicitada por el inicio de sesión. Error de inicio de sesión.
01:06:31p ExDB Server Start!!
GuildOnOff system : 0 Count: 1
01:06:32p SELECT * FROM Guild
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:
01:06:32p SQLSTATE:, diagnosis:

---

in dataserver: http://img220.imageshack.us/img220/1722/13766308.jpg

3 days ago and i still cant fix it, i really need help, il apreciate it, thanks alot.

More info about server:
Intel core i7 4x2x2.66 Ghz
Ram: 12 GB DDR3
HDD: 2x80GB Intel M25
Windows Server 2008 standard edition
MSSQL Server 2005 express (mix mode, windows and account (sa))
Server Files: Muserver Season 4 Full + SubServer

Another screen with MSSQL info: http://img521.imageshack.us/img521/2807/55200113.jpg

Thanks for help.