Unable to create character

[adam910]

[Fri Nov 28 2008 03:33:53.639042 3044240288]: Database Connect success!
[Fri Nov 28 2008 03:33:53.047094 3054730144]: Database Connect success!
[Fri Nov 28 2008 03:33:53.365839 3065220000]: Database Connect success!
[Fri Nov 28 2008 03:35:15.096763 3044240288]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Fri Nov 28 2008 03:35:15.097586 3044240288]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""account"."dbo"."cabal_newCharData_table"". The table either does not exist or the current user does not have permissions on that table.
[Fri Nov 28 2008 03:35:15.097647 3044240288]: [##ERROR##] DB ERROR(CODE) : 7314
[Fri Nov 28 2008 03:35:15.097698 3044240288]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Nov 28 2008 03:35:15.097748 3044240288]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Nov 28 2008 03:35:15.097799 3044240288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?

Help Please... Thanks in advance

 

[kc0gcm]

[Fri Nov 28 2008 03:33:53.639042 3044240288]: Database Connect success!
[Fri Nov 28 2008 03:33:53.047094 3054730144]: Database Connect success!
[Fri Nov 28 2008 03:33:53.365839 3065220000]: Database Connect success!
[Fri Nov 28 2008 03:35:15.096763 3044240288]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Fri Nov 28 2008 03:35:15.097586 3044240288]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""account"."dbo"."cabal_newCharData_table"". The table either does not exist or the current user does not have permissions on that table.
[Fri Nov 28 2008 03:35:15.097647 3044240288]: [##ERROR##] DB ERROR(CODE) : 7314
[Fri Nov 28 2008 03:35:15.097698 3044240288]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Nov 28 2008 03:35:15.097748 3044240288]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Nov 28 2008 03:35:15.097799 3044240288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?

Help Please... Thanks in advance

ok u need to check ur permissions for the user.. you have not allowed the user permission to the database..

are u using SQL 2000 or 2005?

 

[adam910]

hmm SQL 2005

 

[~NaraShikamaru]

I'm using SQL 2005 and I need a bit of help setting up the linked server with my account, could you help me out gcm?

 

[kc0gcm]

http://forum.ragezone.com/f460/setting-up-linked-server-in-sql-2005-a-503557/

there u go I made a guide for this...

 

[adam910]

ok u need to check ur permissions for the user.. you have not allowed the user permission to the database..

are u using SQL 2000 or 2005?

i don't quite really get what you mean..... can you explain abit more ??? thanks alot

 

[kc0gcm]

http://forum.ragezone.com/f460/how-to-configure-your-sql-database-in-sql2005-express-431889/

read this link

 

[adam910]

i follow it but still getting the same error HELP !!!!!!

 

[an2ny_18]

use sa for your data base username/account.