Can't get item id "MainSvrT"

Mikkel Kaas · Oct 24, 2014

hallo all

i get this error each time i open MainSvrT, (Can't get item id)
anyone that know how to fix ?

best
Kukki

Ismirko · Oct 24, 2014

try to create this stored and try it

CREATE PROCEDURE [dbo].[maxiid]

AS

SELECT MAX([IID]) FROM Item WHERE [IID] < 0

Mikkel Kaas · Oct 24, 2014

jup jup worked tyvm

ranged123 · Nov 27, 2014

Hey i have problam with DB id and pw where i get that?

Ismirko · Nov 27, 2014

ranged123 said:
Hey i have problam with DB id and pw where i get that?

check odbc first,then if it ask for id and pw just press yes

ranged123 · Nov 28, 2014

where is odbc

Kallyanna · Nov 30, 2014

~Go into start -- control panel -- administrative tools -- Data Sources (ODBC)

~Go into system DSN and click on "add"

~Now search for "SQL server". Select it and click on finish

~Name it KAL_AUTH and for "which SQL server do you want to connect to?" select (local) or type yourcomputername-PC\SQLEXPRESS

~Click next-next- then check "change the default database to" and select "kal_auth"

~click next two more times and then OK

~Do the same thing for kal_db

blbl · Jun 7, 2015

Re: Can't get item id "MainSvrT"

i don`t know how to fix mainsvrt can`

i don`t know how to fix main svrt can`t get itemid please tell me how

GallantS · Jun 8, 2015

if only you looked up , u will find da solution

Ismir93 said:
try to create this stored and try it

CREATE PROCEDURE [dbo].[maxiid]

AS

SELECT MAX([IID]) FROM Item WHERE [IID] < 0

Can't get item id "MainSvrT"

Mikkel Kaas

Newbie Spellweaver

Ismirko

Helper for everyone

Mikkel Kaas

Newbie Spellweaver

ranged123

Initiate Mage

Ismirko

Helper for everyone

ranged123

Initiate Mage

Kallyanna

Banned

blbl

Initiate Mage

GallantS

Elite Diviner