Creating ODBC (64 bit OS 4 all Mu Servers)

[Dios]

Most users think Mu Servers won't work on 64bits OS, this is WRONG! Many users just run the .reg and then try to open the server they see errors like this:

Source [Microsoft OLE DB Provider for ODBC Drivers].
Description [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

The problem is that you can't use 32bits ODBC to connect to a 64bits OS, so...

Using the Run dialog box, type %SystemRoot%\SysWow64\odbcad32.exe

Note: Do not use Start > Control Panel > Administrative Tools > Data Sources (ODBC).


Create the ODBC's manually and run your server


Now you can take advantage of all your ram and check how much faster SQL x64 is.



PS: I tested this on s1 GS and in 97 gs (I've being running 97gs on 64bits OS for over 1 year without ANY problems.

[MentaL]

[Annaev]

Yes, you're right. I run muserver on x64 OS, without odbc problem using odbcad32.exe.

[Annaev]

But create ODBC manually you need to use ODBC.reg to know what you need to add.
Not register but read.

[Dios]

Good Point.

If you don't know what the ODBC links you need for your server simple rightclick on the odbc.reg and open it on notepad, then you'll see all the info you will use to manually create them.

[KREATOR]

this is what ive always told when ppl think they cant make a server in a 64-bit OS... :D

[Shatter]

well its been available to run muservers on 64 bits for long time, just need different configures to get it working so i guess this is good for those who dont know how to configure it yet gl

[star3stone]

well the thing is that we that doesnt know how to configure it didnt get any help? yeah im pretty stupid but really. you didnt tell us where to go and what to write you just told us where to start. and thats more like a hint then a tutorial dont you think? i whould be glad if you told me what to do when im on odbc administrator program. i guess im not the only one that whould get happy. well if you got some time to spend, please add more "hints" so we stupid people know what were doing.

thanks for taking your time reading this btw

[-/7y/I9I-]

well the thing is that we that doesnt know how to configure it didnt get any help? yeah im pretty stupid but really. you didnt tell us where to go and what to write you just told us where to start. and thats more like a hint then a tutorial dont you think? i whould be glad if you told me what to do when im on odbc administrator program. i guess im not the only one that whould get happy. well if you got some time to spend, please add more "hints" so we stupid people know what were doing.

thanks for taking your time reading this btw

Nice guide Dios, Thanks. I agree with star3... Noob friendly guide is always better + you will avoid many stupid question's. If they still cant get the server running (with the step by step guide), it's because they screwed it up. Not because you didn't tell them how to do it, the right way.

[fdinufdinu]

It would me better to tell us what to do once you get into the program

[crasnaru]

waer to put the %SystemRoot%\SysWow64\odbcad32.exe in ODBC in ODBC i have

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)"
"Database"="MuOnline_Event"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

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

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

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

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

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"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 I have 64bit computer

[budsmoker997]

Thanks bro.

I just started using 64-Bit and i had trouble getting Apache to work. I finally got it to work and then i had ODBC_Connect problems. After hours of searching google i couldn't find anything helpful on the situation.

I then after hours of looking remembered seeing this post a couple of days ago.

You saved my life bro.....Thank you

:D

[hana-michi]

Hi,

I run all links OK with my XP 64bit except only the joinserver one, it always crashes; does it because of wrong configuration of ODBC?

If I manually create ODBC as introduced in this post, will the problem be solved?

Thanks all,

[Doxake]

can some one help me i goy an error when i open the dataserver.... i get GSDBSET ODBC CONNECT FAIL im using windows vista

[cymonik]

I LOVE YOU! =D much appreciated !

[jeus16]

Hello, God, MasterJeus has created a fix for ODBC.reg to 64x for your original you can find it at their forum: http://www.hastlegames.com/foro/f133...r-2003-a-2521/

LINK ODBC.REG FIX 64x Windows Server 2003: http://www.sendspace.com/file/loohfr

You created a copy of this topic ^ ^ No offense, look at the dates of publication.