- Joined
- Nov 9, 2006
- Messages
- 55
- Reaction score
- 0
Re: [VS22] v18.3
Actually, I really had some progress in the few hours I've tried to troubleshoot this thing
After fixing the config files, the only problem I have now is that after I open the binaries... it just runs and just closes
I would start debugging it but I don't have a few libraries the debugger needs such as d3dx9.lib;;
btw just in case anyone's curious about what I did, here's a copy of the Certifier.ini
also, you need to manually create USERs (not LOGINs) for login, character01, and log01 in their respective databases, and also manually set permissions
not sure if everything is fine after just enabling EXECUTE permissions, as that was the one I had the most error after creating the users... so I also enabled ALTER permissions too
if an error occurs regarding the user during CQuery, you should create another user inside that specific database
example of my error here:
then I did this:
now I don't get any CQuery errors, I also don't get any server binary errors, and now that they're just closing without any sort of log something, I guess I really just have to try to use the debugger
...the debugger does highlight the line of code for every part of execution, right?
Actually, I really had some progress in the few hours I've tried to troubleshoot this thing
After fixing the config files, the only problem I have now is that after I open the binaries... it just runs and just closes
I would start debugging it but I don't have a few libraries the debugger needs such as d3dx9.lib;;
btw just in case anyone's curious about what I did, here's a copy of the Certifier.ini
Account "192.168.1.10" // String, lpConnection (of database)
DB_ADMIN_ID_LOGIN "sa"
DSN_NAME_LOGIN "login"
DB_PWD_LOGIN "abcd1234" // String
//LIMIT nLimitation // number, Set Limitation
//WebCertURL "" // String, Web Certifier URL for Japan only
//HEARTBEAT // Switch, If uncomment hb.Init()
DSN_NAME_LOGIN "login"
also, you need to manually create USERs (not LOGINs) for login, character01, and log01 in their respective databases, and also manually set permissions
not sure if everything is fine after just enabling EXECUTE permissions, as that was the one I had the most error after creating the users... so I also enabled ALTER permissions too
if an error occurs regarding the user during CQuery, you should create another user inside that specific database
example of my error here:
2022/05/30 23:02:38
query:usp_GuildHouse_MaxSEQ '01'
SQLSTATE:08004 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]The server principal "character01" is not able to access the database "LOGGING_01_DBF" under the current security context.
//================================================================================================================
then I did this:
use [LOGGING_01_DBF]
create user character01
go
now I don't get any CQuery errors, I also don't get any server binary errors, and now that they're just closing without any sort of log something, I guess I really just have to try to use the debugger
...the debugger does highlight the line of code for every part of execution, right?