are you spamming?!?!
Printable View
are you spamming?!?!
hi chumpywumpy, can you help me with this error:
http://img51.imageshack.us/img51/4678/87202187.th.png
and yes i checked the tickbox
The database uses codepage 936 (Chinese) and you need that installed on the computer to be able to restore the databases. For Win7 this is the "install/uninstall languages" on the "keyboard and languages" tab of the "region and languge" option in the control panel.
http://www.mydigitallife.info/2009/0...-in-windows-7/
Downloads (you want simplefied Chinese):
http://keznews.com/6149_Download_Win...Download_Links
installed simplefied Chinese and i still get the same error, il try restarting my pc, hope it works.
EDIT: restarted and i still get the error, i always get an sql error evreytime i try to make an cabal sv( used till now vista x64, and now win7 x64)...always at restoring, maybe if u know how someone can directly make the databases without restoring, please pm me, thanks for the help.
EDIT2:after looking on the internet for an disparate fix ive seen kreains topic on ragezone and im thinking to quit making this server.
I have Win7x64 and the files restored ok for me, though i had all the language packs installed already. It is possible to create the databases without a restore but it would take many queries and you would still run into the same problem, you can't create Chinese language tables without the right language pack.
You could try the other Chinese (Hong Kong) language pack but i'm 99% sure 936 is in the simplified one.
Try checking the registry keys mentioned here:
http://support.microsoft.com/kb/165051
Mine looks like this:
http://i344.photobucket.com/albums/p...2/codepage.gif
fixed, thanks chumpy, seems that you need winOS with all languages preinstalled, it wont work if u install Chinese after, if u install Chinese after you wont have the specific fonts to it.
Hey chumpy!
Ive decided to try again to get this system running in Vista64.
I done exactly as you showed in the guide above, but im still not getting any further.
I start client and there is no connection between client and SQL server. I can input any names and there is no check at all.
Is there any other way I can check the functionality of the database(s)? Running queries for XP_MD5 and creating an account worked fine.
My client is ok, its the same I use for (XP) server.
Sorry, i meant to update this earlier and forgot :/
In Vista it is almost definitely the firewall stopping it if you can ping centos but the server can't connect to sql. I'm using win7 x64 with 2005 express so there are definitely no issues there (though the firewall gave me grief for a few mins).
You can try this little trick to see if centos can connect to sql or not:
http://www.mediafire.com/download.php?qnzlozqkilo
Drop it in your /root/ folder, chmod 0777 the .sh file and run it. It will try connecting to SQL and test a query using xp)md5 to test both. You should get 1 row back (letters and numbers, md5 for "test").
Turned off vista firewall, no difference. So putty and winscp work fine.
That program returned 'could not SQLConnect'. Also did with sa accout too same thing.
What do you suggest is wrong. My config maybe??
---------- Post added at 10:59 PM ---------- Previous post was at 09:27 PM ----------
Im getting sql error:
This is to do with XP_MD5?? Should I use 64 bit version??Quote:
Msg 2601, Level 14, State 1, Procedure cabal_tool_registerAccount, Line 10
Cannot insert duplicate key row in object 'dbo.cabal_auth_table' with unique index 'IX_cabal_auth_table'.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
(1 row(s) affected)
Also randomly, if I put an incorrect password, I get the error 'account/username not found' which means SQL is checking yes? Which means Im connecting? But will only do this once per running the client.
:grr:
Ok i got it working!!
I turned off vista firewall for one, secondly, i added another option under linkedserver->security and added the 'sa' account and chose 'impersonate'.
This seemed to work but not sure why. I was just fiddling with options!
Hopes this also helps somebody else out there???
Ok edit on this...
I connect to cabal randomly. What I mean is, I will connect one time then not another. So its completly random. Im lost now. Officially!
can someone help me? i got this error while installing database. -_-
Quote:
===================================
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "GAMESERVER".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.". (.Net SqlClient Data Provider)