Anyone?

[Monaf]

Hi all
I have problem with my odbc, the server was running for 2 weeks, and now it crushed, it says connect fail please my players are waiting to fix this problem if anoyone can help?

[MentaL]

[RSLocs]

Ahm, what SQL ? and which files? Also try Restarting your VPS/Host and running Server again ;)

Usually helps in these Cases

[Monaf]

I restarted alot, im using SCFTeam season 3 files an sql 2000
I tried with season 4 shatter files too but still same error

[kstor1234]

and why don't you DELETE all your current ODBC and then ADD them manually?
http://forum.ragezone.com/f196/creat...bit-os-610473/ This is a guide... NOT that really hard...

And before you come up with the excuse that you do not know which ODBC's you need to create manually, right click the ODBC.reg that comes with your serverfiles and click EDIT... It should open up with notepad or some other lightweight text editor. After that, all you must do is read and use your brains.

And here, I totally stole a guide from another web, just in case you come up with the excuse that you do not have sql 2005, nor a 64bit OS. Credit to the respective owner, the only thing I claim is for you being too stupid to google this simple and indeed stupid error, dear lord.

Building ODBC manually - Why?

Sometimes you have server files with no ODBC.reg, the file, which makes write to registry and set the ODBC (Open Database Connectivity) for you by 2 clicks. Or you want to do server from scratch by yours, want to see it... however, you have to do it manually.

For all, at first:
At first point, you must have MU SQL Server database, restored from serve files of your server downloaded. For example, i will use database from 1.2Q Server guide. No matter what version you use (non-router / router). I will not explain how to restore it etc. but use MSSQL 2000(i've downloaded it from torrent).

If you have Vista or other 64bit OS, you have to run "setup.bat" to install MSSQL2000, not autorun

At this point, we must have restored MuOnline and Ranking database. Now...

XP 32bit
Open your Start menu and choose "Control panel". There find "Administrative tools".
Run "Data Sources(ODBC)"

XP 64bit
Open your Start menu and choose "Run". There paste this "%SystemRoot%\SysWow64\odbcad32.exe"

Vista 32bit
Open your Start menu and type "Data Sources(ODBC)" and press enter.

Vista 64bit
Open your Start, paste this "%SystemRoot%\SysWow64\odbcad32.exe" and press enter.

! In 64bit Vista&XP you have to use these ODBC, trying to open ODBC like in 32bit OS will open the 64bit version of ODBC, which doesnot work with MSSQL 2000 !

Now, once you have opened administration of ODBC you have to create connections to your databases.
On top, switch to System DNS.

You will se this:


*probably you'll see here some things there, you can ignore them.


For 1.2Q we must build these connections:
Event
LOGIN
MuOnline
MuOnlineJoinDB
Ranking
USELOG

In mu server files in readme you will 100% find what connections you have to make, if not, shift+click right muse button on "ODBC.reg" file, select "Open with..." and choose Notepad, there you will see what you should made.

How to do that? Easy as can be...

1. On the right side click on "Add..." button.
2. Select "SQL Server" and press Finish.
3. New dialog will apear. In the "Name" field put the connection name (ex. Event , i dont know if is it case senstive but its better to write as it is, not "event" but "Event")
4. Skip description and In listbox "Server" choose "(local)".
5. Click on next. Now be sure that you have all checked like on this screen:



6. Continue by clicking "Next". Now check the "Change the default base to:" and from the list choose the MuOnline database or Ranking database. You will know what to choose from readme / .rg file, viz. blue text.
7. On the next screen leave checked only "Perform translation for character data" and press finish.

Cool, you're done. Now, you have to repeat all these points until you have all connections made.
At last, i will show you, how to simply read informations from .reg files.

There we have some of ODBC.reg of 1.2Q server, opened in notepad:


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\Ranking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="Ranking"
"Server"="(local)"
"Database"="Ranking"
"LastUser"="Alberto"
"Trusted_Connection"="Yes"


yep, its not complete, but this will be enought do show you what we need:

It tells us that we have to build 2 connections: Raking and MuOnline.
Only one thing what you need is end of the first line each connection:

...\ODBC.INI\Event]

and

...\ODBC.INI\Ranking]

Now we know names - Event and Ranking. Yeah, its that last word in line. Only one remaining thing is database. And yes, its next to "Database"=. You can see that the Event belongs to MuOnline and Ranking belongs to Ranking. Easy as can be

[Monaf]

I did it manually but im still getting the same error
I found this error in the SystemDNS, for the Mircoroft access driver.mdb i installed another one from Download: Microsoft Data Access Components (MDAC) 2.8 SP1 - Microsoft Download Center - Download Details
But still same error, it's asking for re-installing it how to do it ;p

[Monaf]

I Made them manually
I insallted new microsoft access driver
I did all the guides u gave
BUT STILL NOTHING NEW
this shit is eating my brain

[BirthZone]

try back up database then request reformat to your host..

[Monaf]

I'll do it now .. i'll post here if anything new happens