Printable View
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^^
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:
Keep in mind almost anything in there is different from Windows versions and SQL versions :-) not to mention the 32-64 differences.Code:Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Event]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer]
"Server"="(local)"
"Trusted_connection"="Yes"
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"LastUser"="Administrator"
[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\MU2003_EVENT_DB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="127.0.0.1"
"Database"="muonline"
"LastUser"="sa"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnline"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="muonline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"
"Description"="MuOnlineJoinDB"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"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"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Ranking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="Ranking"
"Server"="(local)"
"Database"="muonline"
"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"
"Description"="USELOG"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS]
"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"=""
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Xtreme Sample Database 2003 CHS\Engines\Jet]
"ImplicitCommitSync"=""
"Threads"=dword:00000003
"UserCommitSync"="Yes"
(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 msnQuote:
Originally Posted by Magnadragoon
leanisafreak@live.com.ar T.T
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..
Here are full guide in the forum
And i've uploaded video how to make odbc on win x64
Can u give me the link please?Quote:
Originally Posted by Annaev
that's not an "odbc database"Quote:
Originally Posted by Flawless
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 :-)
Thx for answer but i think you have to read before answering because you can make the people to mistake...Quote:
Originally Posted by Flawless
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 :-)