Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir
← Toutes les solutions

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

Rédigé par MuADMINS à partir de la 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.

Rédigé par MuADMINS
Cela vous a-t-il aidé ?

Toujours bloqué ? Rechercher sur MuGPS Demander à l'Assistant MU

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.