Invalid Object name 'server'

[largirucho]

Hi guys, i have a problem in AuthD (c4 server) that says

 

 [ODBC SQL... ] Invalid object name 'server'

 

 

and is there a

 

Invalid object name 'worldstatus'

 

I have check the server table in lin2db and there is ok... idk why this happends

 

im using SQL Server 2008 developer edition.

 

Ty in advice.

[xOutlaw]

Post a printscreen of the actual issue, it would be more helpfull to help you solve this.

[largirucho]

here u are:

 

 

 

I checked dbo.server and it's ok so idk why is doing this error. I think odbc can't reach database.

[xOutlaw]

If the config in dbo.server is fine as you said, then it must be a wrong connection to the SQL server, check ODBC again and try to re-connect again throught the necesary executables to the SQL DB, prolly you connected by mistake to another .

[largirucho]

I check my ODBC and they are ok. Can it be the database ip config ? (@conn_str) cause i have an ip who finish with 104 and worldid is 1 and that config shows conn_str '127.0.0.' +@worldId

 

 

it's the only thing could be doing this, i think.

[xOutlaw]

Your problem is here :

***

4. Close the New Query window. Look at the left side for "Databases". Open it, then go to lin2db > tables. Right click on dbo.server and choose "Open Table". Now you'll configure the server settings in this table.

 

 

ID: 1 (2, 3, 4 and so on for more servers)
Name: Pick a 11 characters (no more, no less) name.
IP: Insert the WAN IP here. ([url=http://whatsmyip.org]Click to learn it![/url])
inner_ip: Insert your localhost (127.0.0.1) IP here.
ageLimit: 0
pk_flag: 1
kind: 0
port: 7777
region: 0 (1, 2, 3 and so on for more servers)

[largirucho]

Your problem is here :

***

4. Close the New Query window. Look at the left side for "Databases". Open it, then go to lin2db > tables. Right click on dbo.server and choose "Open Table". Now you'll configure the server settings in this table.

 

 

ID: 1 (2, 3, 4 and so on for more servers)
Name: Pick a 11 characters (no more, no less) name.
IP: Insert the WAN IP here. ([url=http://whatsmyip.org]Click to learn it![/url])
inner_ip: Insert your localhost (127.0.0.1) IP here.
ageLimit: 0
pk_flag: 1
kind: 0
port: 7777
region: 0 (1, 2, 3 and so on for more servers)

 

i already made it...

 

[xOutlaw]

Name : any word with 11 characters

Region : 0

[largirucho]

Name : any word with 11 characters

Region : 0

 

Still same problem...

[xOutlaw]

Remake your connections to the SQL Db`s.

 

[lordvenancio]

u selected logd for lin2world....change for lin2log !! and u cached for lin2world and  auth for lin2db ! Rename u odbc and open executable again....and change db name for executable and work ;D !

[GARAB]

HI guys!
 

I have the same problem, checked the connections like 2 times, remade them, still the same errors. I don't have any more ideas

 

[EDIT]

Works fine, I missed a line in the config (readlocalserverlist). I set it to false, now its working

Edited August 12, 2014 by GARAB