Can't get item id "MainSvrT"

[Mikkel Kaas]

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]

try to create this stored and try it

CREATE PROCEDURE [dbo].[maxiid]

AS

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

 

[Mikkel Kaas]

jup jup worked tyvm

 

[ranged123]

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

 

[Ismirko]

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]

where is odbc

 

[Kallyanna]

~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]

Re: Can't get item id &quot;MainSvrT&quot;

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]

if only you looked up , u will find da solution

try to create this stored and try it

CREATE PROCEDURE [dbo].[maxiid]

AS

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