Skip to content

Invalid Object name 'server'

Featured Replies

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.

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

  • Author

here u are:

 

xlzf48.jpg

 

 

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

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 .

  • Author

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.

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)

  • Author

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...

 

2w408sy.jpg

Name : any word with 11 characters

Region : 0

  • Author

Name : any word with 11 characters

Region : 0

 

Still same problem...

Remake your connections to the SQL Db`s.

 

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 !

  • 1 year later...

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 by GARAB

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.