01_INSTALL_LS and 02_INSTALL_GS errors

[Herpityderp]

Hey erryone, I got the database set up and the odbc settings all correct, but when I run those two batches I always get:

C:\MyIris>IrisLoginSrv.exe /insert

=============== INSERT START ===============
TB_CAPTCHA table was not complete!!!
Press Any Key to Continue...

=============== Completed ===============

INSERT - ERROR(=1)

Press Any Key to Continue.

C:\MyIris>IrisGameSrv.exe /insert

=============== INSERT START ===============

SQLGame Initialization & Data loading success.
TB_ITEM_DEFINE table was not complete!!!
Press Any Key to Continue...
TB_ITEM_ABILITY table was not complete!!!
Press Any Key to Continue...
TB_ITEM_LIMIT table was not complete!!!
Press Any Key to Continue...
TB_ITEM_CARD table was not complete!!!
Press Any Key to Continue...
TB_ITEM_CARD_SLOT table was not complete!!!
Press Any Key to Continue...
TB_ITEM_TAROT table was not complete!!!
Press Any Key to Continue...
TB_ITEM_TAROT_RESULT table was not complete!!!
Press Any Key to Continue...
TB_ITEM_SPREAD table was not complete!!!
Press Any Key to Continue...
TB_ITEM_DISJOINT table was not complete!!!
Press Any Key to Continue...
TB_ITEM_ENHANCED table was not complete!!!
Press Any Key to Continue...
TB_ITEM_ENHANCED_RATE table was not complete!!!
Press Any Key to Continue...
TB_ITEM_CHANGE table was not complete!!!
Press Any Key to Continue...
TB_DEFAULT_ITEMS table was not complete!!!
Press Any Key to Continue...
TB_SKILLLIST_PC table was not complete!!!
Press Any Key to Continue...
TB_DEFAULT_SKILL table was not complete!!!
Press Any Key to Continue...
nTB_JOBTREE table was not complete!!!
Press Any Key to Continue...
TB_QUEST table was not complete!!!
Press Any Key to Continue...
TB_ITEMDROP_LIMIT table was not complete!!!
Press Any Key to Continue...
TB_GUILD_EXP table was not complete!!!
Press Any Key to Continue...

=============== Completed ===============

INSERT - ERROR(=19)

Press Any Key to Continue.

If anyone can help me, thanks.

 

[ptuser]

the problem is your odbc, it needs to be in user dsn, not system dsn.

 

[Herpityderp]

Thanks. :>

 

[Caosfox]

and check the login right of user 175iris

175iris need db_owner on the 3 main databases (iris_*****)
cant remember if need it on WEB_*****)

 

[Herpityderp]

It was just the user/system dsn mix up, but thanks.

Now just having trouble on getting the gm tool + client to work. :<

 

[Saikoh]

Switching between user and system doesn't help me... Win7 :/
Using 2008 SQL.

 

[CodeSkilLs]

Try to check iris175 user Rights, DB_OWNER if it`s checked.

 

[alikemal234]

Have error on odbc!

 

[xtannerx]

i guess you are useing windows 7 64bit

Try this

Start > Run > C:\Windows\SysWOW64\odbcad32.exe

if it not works try without sql id-password with auto login

 

[MU_TITA]

plz help me too imy odbc full conect but still can't fix this eror ..

 

[CodeSkilLs]

If you have 64 bit OS, you need to add odbc to Windows/SysWOW64/odbcad32.exe

 

[tidie10]

If you have 64 bit OS, you need to add odbc to Windows/SysWOW64/odbcad32.exe

That's not needed.. If they just used the Windows Button and actualy look for ODBC, they would end up at the right ODBC.

 

[abhiru7401]

Adding in both user DSN and System DSN is still giving same errors for GS (19) and LS (1). Someone please help me fix this,