[Help]EP3 DSN

Page 1 of 3 123 LastLast
Results 1 to 15 of 33
  1. #1
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    [Help]EP3 DSN

    hello i have a error when i add the dns ples help me how to add
    thnks
    Last edited by jison; 15-02-12 at 03:42 PM.


  2. #2
    You won't get me... PanKJ is offline
    MemberRank
    Sep 2010 Join Date
    Too Damn HighLocation
    593Posts

    Re: [Help]EP3 DSN

    Lol i dont know this language at all, how do you expect anyone to tell you what it means without giving a translation? Btw, ep3 does NOT require dsn settings, leave them blank and just fill your db ip, port, user, pass and db name. These should be enough for a connection to db anyway.

  3. #3
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    Re: [Help]EP3 DSN

    are you sure ?
    i have log server errors

  4. #4
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    Re: [Help]EP3 DSN

    look here
    Last edited by jison; 15-02-12 at 03:42 PM.

  5. #5
    You won't get me... PanKJ is offline
    MemberRank
    Sep 2010 Join Date
    Too Damn HighLocation
    593Posts

    Re: [Help]EP3 DSN

    I can tell you for sure it works for me without dsn. Idk about your set up. But youve certainly done something wrong with sql. What sql did you install?
    Last edited by PanKJ; 10-06-11 at 12:53 AM.

  6. #6
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    Re: [Help]EP3 DSN

    sql server not sql express

  7. #7
    Member Renaissance is offline
    MemberRank
    Apr 2011 Join Date
    64Posts

    Re: [Help]EP3 DSN

    i think he means what version.. 2005 or 2008

  8. #8
    You won't get me... PanKJ is offline
    MemberRank
    Sep 2010 Join Date
    Too Damn HighLocation
    593Posts

    Re: [Help]EP3 DSN

    I suggest you use mssql 2008 r2, use the db backups, follow my guide about mssql users and logins, configure mssql setting to set ip and port and THEN try to run the server (with correct settings in global.cfg).

  9. #9
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    Re: [Help]EP3 DSN

    i do i read your guide
    check my golbal.cfg
    Last edited by jison; 15-02-12 at 03:42 PM.

  10. #10
    Account Upgraded | Title Enabled! l34V3 is offline
    MemberRank
    Jan 2011 Join Date
    244Posts

    Re: [Help]EP3 DSN

    Quote Originally Posted by jison View Post
    i do i read your guide
    check my golbal.cfg
    Code:
    ################################################################################
    # Database Settings 1 - PreServer
    ################################################################################
    	$PRE_ODBC_DSN				= db_acc
    	$PRE_ODBC_UID				= 21474103
    	$PRE_ODBC_PASSWD			= 2352580204405E
    	$PRE_DB_SERVER_DATABASE_NAME		= atum2_db_account
    	$PRE_DB_SERVER_IP			= JISON\SQLEXPRESS
    	$PRE_DB_SERVER_PORT			= 9979
    
    ################################################################################
    # Database Settings 2 - ServerGroup(IMServer, FieldServer, LogServer, NPCServer)
    ################################################################################
    	$SERVER_GROUP_ODBC_DSN			= db_1
    	$SERVER_GROUP_ODBC_UID			= 21474103
    	$SERVER_GROUP_ODBC_PASSWD		= 2352580204405E
    	$SERVER_GROUP_DB_SERVER_DATABASE_NAME	= atum2_db_1
    	$SERVER_GROUP_DB_SERVER_IP		= JISON\SQLEXPRESS
    	$SERVER_GROUP_DB_SERVER_PORT		= 9979
    
    ################################################################################
    # Database Settings 3 - Log DB Server(LogServer)
    ################################################################################
    	$LOG_SERVER_GROUP_ODBC_DSN		= db_1
    	$LOG_SERVER_GROUP_ODBC_UID		= 21474103
    	$LOG_SERVER_GROUP_ODBC_PASSWD		= 2352580204405E
    $LOG_SERVER_GROUP_DB_SERVER_DATABASE_NAME	= atum2_db_1
    	$LOG_SERVER_GROUP_DB_SERVER_IP		= JISON\SQLEXPRESS
    	$LOG_SERVER_GROUP_DB_SERVER_PORT	= 9979
    JISON\SQLEXPRESS <-- That one is wrong , there should be an IP not SQL login info.

  11. #11
    Enthusiast Whee1717 is offline
    MemberRank
    Mar 2011 Join Date
    The NetherlandsLocation
    34Posts

    Re: [Help]EP3 DSN

    it does say pre_db_server_IP for a reason

    else it maybe would say something like pre_db_server_path or something

  12. #12
    You won't get me... PanKJ is offline
    MemberRank
    Sep 2010 Join Date
    Too Damn HighLocation
    593Posts

    Re: [Help]EP3 DSN

    Facepalm. But i wonder why there was an 127.0.0.1 when you got this file... In the original version of my cfgs i even had COMMENTS so that noobs no what to put there. I even recommended to use the 127.0.0.1 without changing it. Idk what else i should say.

  13. #13
    Account Upgraded | Title Enabled! l34V3 is offline
    MemberRank
    Jan 2011 Join Date
    244Posts

    Re: [Help]EP3 DSN

    Quote Originally Posted by PanKJ View Post
    Facepalm. But i wonder why there was an 127.0.0.1 when you got this file... In the original version of my cfgs i even had COMMENTS so that noobs no what to put there. I even recommended to use the 127.0.0.1 without changing it. Idk what else i should say.
    Using 127.0.0.1 isnt best idea...

  14. #14
    Account Upgraded | Title Enabled! desp08500 is offline
    MemberRank
    May 2011 Join Date
    245Posts

    Re: [Help]EP3 DSN

    Hum interesting,do you know the JISON\SQLEXPRESS is like my config i use MIKAL\SQLEXPRESS cause if i use my ip that not work, my instance on db query is like this,and when i setup my sqlexpress on your way using 192.168.1x or 127.0.0.1 or 5.x.x.x.x i got my instance working on it on log but preserver not runningiocp init fail,have to go back to MIKAL\SQLEXPRESS config instance in sqlexpress to get it work.This interest me cause i think that if i got some problem with admintools,that start by that cause when i use MIKAL\SQLEXPRESS on patching that got wrong entry.
    Last edited by desp08500; 10-06-11 at 10:00 AM.

  15. #15
    Unsealed/FILES jison is offline
    MemberRank
    May 2011 Join Date
    Bangladesh/FrLocation
    378Posts

    Re: [Help]EP3 DSN

    okay what ip i do give
    the hamachi ip or the 192.0.0.0?



Page 1 of 3 123 LastLast

Advertisement