Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon

ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

Isinulat ng MuADMINS mula sa sourceNot verified

MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN:

  • JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnline).
  • The packs ship the DSN as registry files: MuOnline.reg writes HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline, MuOnline64.reg writes HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnline: Driver SQLSRV32.dll ("SQL Server"), Server (local), Database MuOnline.

Checks:

  1. On 64 bit Windows a 32 bit server program sees only the 32 bit DSNs: use MuOnline64.reg or create the DSN in C:\Windows\SysWOW64\odbcad32.exe.
  2. The DSN must point at the right SQL instance: (local) is the default instance; a named instance needs PCNAME\SQLEXPRESS.
  3. The DSN default database must be MuOnline (not master), or the server looks for the tables in the wrong database.
  4. MSPro logs in with an SQL user (JoinServerUSER / SQLUser = sa): SQL Server must allow mixed mode authentication.

IGCN is different: IGCDS.ini [SQL] connects with SQLServerName, User and Pass, no DSN name; the IGCN documentation asks for an English language SQL user and a case insensitive collation.

Source: JoinServer.ini / DataServer.ini and DB/MuOnline.reg / MuOnline64.reg of Louis S6E3 V13, Louis S6 Update 27, X-Team S17, MSPro V14; IGCN S16 IGCDS.ini; IGCN doc notes in the MuADMINS SQL guide research.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.