Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Windows xp 64 bits

Status
Not open for further replies.
Skilled Illusionist
Joined
Nov 9, 2008
Messages
371
Reaction score
28
Hello
Before telling my problem thx for read^^

I have a new pc and since i have 4gb ram i had to use windows xp 64 bits... now when i want to start up my server... i got many errors by OBDC CONNECTING FAIL and SQL...

I want to know what should i do for the server start normally as before since i know that is possible to start a server in windows 64bits

Thx a lot

xChise^^
 
Newbie Spellweaver
Joined
Nov 20, 2005
Messages
31
Reaction score
0
Either create your own ODBC file or find one that is specific to your installation of windows, they are NOT universal.

Or, if you don't want to do that, or if you already have used a .reg file your registry is screwed up :)

In 64 bit versions of windows you need 64 bit versions of the ODB connections.

For example a regular odbc file format looks like this:

Code:
Windows Registry Editor Version 5.00
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI][/COLOR]

[COLOR="Red"][HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Event][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer][/COLOR]
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Trusted_connection"="Yes"
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"LastUser"="Administrator"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MU2003_EVENT_DB][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="127.0.0.1"
"Database"="muonline"
"LastUser"="sa"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnline"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnlineJoinDB"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources][/COLOR]
"Xtreme Sample Database 2003 CHS"="Microsoft Access Driver (*.mdb)"
"LocalServer"="SQL Server"
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"Event"="SQL Server"
"USELOG"="SQL Server"
"Ranking"="SQL Server"
"MU2003_EVENT_DB"="SQL Server"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN][/COLOR]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Ranking][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="Ranking"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"][COLOR="Lime"](local)[/COLOR][/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="USELOG"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"DBQ"="C:\\Program Files\\Microsoft Visual Studio .NET 2003\\Crystal Reports\\Samples\\Database\\chs\\xtreme.mdb"
"DriverId"=dword:00000019
"SafeTransactions"=dword:00000000
"UID"=""
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines][/COLOR]
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines\Jet][/COLOR]
"ImplicitCommitSync"=""
"Threads"=dword:00000003
"UserCommitSync"="Yes"

Keep in mind almost anything in there is different from Windows versions and SQL versions :) not to mention the 32-64 differences.

(local) if you are using an SQL version that is NOT Express
or MAGNADRAGOON-PC\SQLEXPRESS* (pcname\instance name) if you are using SQL Express


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBCNAMEHERE] should be fine on a 32 bit installation of Windows. [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBCNAMEHERE] if you have a 64 bit version :)

Now as for the "Xtreme chinese database" stuff, I have NO idea what all that is, but I don't use it.

hope this mini-guide helps :thumbup:
 
Upvote 0
Skilled Illusionist
Joined
Nov 9, 2008
Messages
371
Reaction score
28
Either create your own ODBC file or find one that is specific to your installation of windows, they are NOT universal.

Or, if you don't want to do that, or if you already have used a .reg file your registry is screwed up :)

In 64 bit versions of windows you need 64 bit versions of the ODB connections.

For example a regular odbc file format looks like this:

Code:
Windows Registry Editor Version 5.00
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI][/COLOR]

[COLOR="Red"][HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Event][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer][/COLOR]
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Trusted_connection"="Yes"
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"LastUser"="Administrator"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MU2003_EVENT_DB][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="127.0.0.1"
"Database"="muonline"
"LastUser"="sa"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnline"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnlineJoinDB"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources][/COLOR]
"Xtreme Sample Database 2003 CHS"="Microsoft Access Driver (*.mdb)"
"LocalServer"="SQL Server"
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"Event"="SQL Server"
"USELOG"="SQL Server"
"Ranking"="SQL Server"
"MU2003_EVENT_DB"="SQL Server"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN][/COLOR]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Ranking][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="Ranking"
"Server"="[COLOR="Lime"](local)[/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="[COLOR="Lime"][COLOR="Lime"](local)[/COLOR][/COLOR]"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="USELOG"
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS][/COLOR]
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"DBQ"="C:\\Program Files\\Microsoft Visual Studio .NET 2003\\Crystal Reports\\Samples\\Database\\chs\\xtreme.mdb"
"DriverId"=dword:00000019
"SafeTransactions"=dword:00000000
"UID"=""
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines][/COLOR]
[COLOR="Red"]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines\Jet][/COLOR]
"ImplicitCommitSync"=""
"Threads"=dword:00000003
"UserCommitSync"="Yes"

Keep in mind almost anything in there is different from Windows versions and SQL versions :) not to mention the 32-64 differences.

(local) if you are using an SQL version that is NOT Express
or MAGNADRAGOON-PC\SQLEXPRESS* (pcname\instance name) if you are using SQL Express


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBCNAMEHERE] should be fine on a 32 bit installation of Windows. [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBCNAMEHERE] if you have a 64 bit version :)

Now as for the "Xtreme chinese database" stuff, I have NO idea what all that is, but I don't use it.

hope this mini-guide helps :thumbup:

Can u xplain me how to create my odbc please? add me to msn
leanisafreak@live.com.ar T.T
 
Upvote 0
Skilled Illusionist
Joined
Apr 12, 2009
Messages
370
Reaction score
48
all u have to do is.. create MuOnline Database such as MuOnline, Ranking, Event etc..
and RESTORE IT.. And make sure you enter the correct info in ranking and event server..
 
Upvote 0
Experienced Elementalist
Joined
Jan 2, 2007
Messages
245
Reaction score
109
Here are full guide in the forum
And i've uploaded video how to make odbc on win x64
 
Upvote 0
Newbie Spellweaver
Joined
Nov 20, 2005
Messages
31
Reaction score
0
all u have to do is.. create MuOnline Database such as MuOnline, Ranking, Event etc..
and RESTORE IT.. And make sure you enter the correct info in ranking and event server..

that's not an "odbc database"

Also... To make an odbc connection manually on a 64 bit version of windows go into C:/Windows/Syswow64/odbcad32.exe

Then create the appropriate dsn's under SYSTEM Dsn, it will not work if you did it under the control panel already. if you did that, you need to go back and delete everything and start over again :)
 
Upvote 0
Skilled Illusionist
Joined
Nov 9, 2008
Messages
371
Reaction score
28
all u have to do is.. create MuOnline Database such as MuOnline, Ranking, Event etc..
and RESTORE IT.. And make sure you enter the correct info in ranking and event server..

Thx for answer but i think you have to read before answering because you can make the people to mistake...
I know how to restore databases... and how to create them, my problem is about ODBC's...
Coz im trying to running my sv in 64bits OS and its kinda different from 32bits OS... its not like double clicking in .reg archive...

Thx anyways :)
 
Upvote 0
Status
Not open for further replies.
Back
Top