Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen
← Alle Lösungen

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

Von MuADMINS anhand der Quelle geschriebenNot 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.

Von MuADMINS geschrieben
Hat das geholfen?

Kommst du immer noch nicht weiter? MuGPS durchsuchen Frag den MU-Assistenten

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.