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

**KREATOR** · 26-09-09

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

**MentaL**

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

**meohen1989** · 30-09-09

all done :D

**pasawebado** · 30-09-09

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

**KarLi** · 30-09-09

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

???

u p ut ur sql pass lol xD

**KREATOR** · 30-09-09

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

**KarLi** · 02-10-09

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 ^^?

**KREATOR** · 02-10-09

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...

**KarLi** · 03-10-09

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

**KREATOR** · 03-10-09

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

**KarLi** · 04-10-09

omg think whatever u want ;D

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

**DZINTAS** · 10-12-09

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

**themrtime** · 26-12-09

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"

**Restore** · 23-02-10

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

**KREATOR** · 24-02-10

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

**lucas123** · 07-03-10

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

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:

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:

Thanks for help.

**KREATOR** · 20-03-10

it says that there is a problem with the logging process..
Did you type your user and password correctly in exdb.ini

**lucas123** · 22-03-10

yes, im sure with user sa and password.

**KREATOR** · 28-03-10

did you do step 6 correctly?

**dujapa** · 19-05-10

Here after settings all. Joinserver.exe and DataServer.exe closed after 1 second after his execution.

It will be a problem even with these two executables ODBCs or do not work in 64-bit version

**GameGuard10** · 18-07-10

I run edataserver(working). Then start up.... All works fine but when comes to dataserver it says, Failed... ? :(

**freezer** · 17-09-10

the odbc that i have fail at the db db2 and ds.exe to start and i used those registery keys modified everything as said it still crashes any ideas?

**jeexiic** · 28-10-10

Hey!
I can't explain :O

**malinog1** · 29-08-14

Sir I used season3 files, and the obdc is error i will try yours , ahm can i ask a question ? it is ok if i used sqleval2000 ? for my windows7 64bit ?

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

Thread Tools

Search Thread

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

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

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

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

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

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

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

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

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

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

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

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

Re: [Guide] Creating ODBC 64-bit OS (Continuing Dios' Guide)

Advertisement