Flyff V21.2 no database connection

01/15/2025 22:42 jarovart#1
Hello flyff friends

-accountserver does not connect to DB via ODBC
-I do not have BACKEND_DBF, ITEM_DBF, WORLD_DBF db. do I need them? does anybody have it?

I play flyff on my own private server several years now. I would like to play a newer flyff version with new updates on my own. Therefore I found Retail Flyff V21.1 and I could find database backupfiles for SQL 2019 with sql version 15. I restore the db to the server, linked the databaseses with odbc and add the login data of db server to accountserver.ini and dekane.hpp and build the entire workspace with vs22. Accountserver.exe of v21.2 can not connect to the db server. But somehow the old v15 accountserver can login into sqlserver19 db. Maybe this is a hint? I would love to hear from you.

Please check my link, if u can not see my picture.
[Only registered and activated users can see links. Click Here To Register...]

Greetz Artem




__________________________________________________ ______________________________________________
Hallo Flyff Freunde,

-Accountserver verbindet sich nicht mit ODBC DB
-mir fehlen die DBs von BACKEND_DBF, ITEM_DBF, WORLD_DBF hat sie jemand oder sind sie nicht notwendig?
-Fallen euch noch mehr Hinweise auf, die ich nicht berücksichtigt habe?

ich spiele nun seit einigen Jahren privat für mich v15 und würde gerne v21 mit neuen Updates spielen. Dafür habe ich mir Retail Flyff V21.2 und die Datenbankbackupfiles für SQL2019 heruntergeladen. Die Datenbanken mit ODBC verlinkt und die logindaten der DB jeweils in die accountserver.ini und dekane.hpp eingegeben und alles bauen lassen. Der AccountServer.exe von v21.2 verbindet sich nicht mit der DB. Der v15 AccountServer kann sich aber immer noch mit der DB verbinden. Vielleicht seht ihr den Fehler auf Anhieb?

Bitte schaut auf den Link, falls ihr meinen Anhang nicht sehen könnt.
[Only registered and activated users can see links. Click Here To Register...]

LG Artem
01/16/2025 23:10 jarovart#2
hello flyff friends,

does my query looks correct? How your query of flyff v21.2 looks like?
Servername: DESKTOP-IO1OS70\FLYFFV21
user id: sa
decrypted pw: flyff


I can read the log, but today I tried a lot of things. And reinstall SQL Server 19 to english adv version. I also removed ODBC connection, since the author of the server put all requirements for the db connection to dekane.hpp.
Activate TCP/IP in sql server configuration manager. Checked the server is running. my ideas are running out... Please help.

[Only registered and activated users can see links. Click Here To Register...]

Quote:
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
[2025-01-16 22:28:42] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=ACCOUNT_DBF;
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2].
[2025-01-16 22:28:42] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=ACCOUNT_DBF;
SQLSTATE:HYT00 error:[Microsoft][SQL Server Native Client 11.0]Login timeout expired
[2025-01-16 22:28:42] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=ACCOUNT_DBF;
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

[2025-01-16 22:28:52] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=LOGGING_01_DBF;
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2].
[2025-01-16 22:28:52] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=LOGGING_01_DBF;
SQLSTATE:HYT00 error:[Microsoft][SQL Server Native Client 11.0]Login timeout expired
[2025-01-16 22:28:52] (ERROR) CQuery::WriteLogFile(819): query:Server=DESKTOP-IO1OS70;Driver={SQL Server Native Client 11.0};PWD=4F5C86C71044BC79683563F07DCD7B4D683563F0 7DCD7B4D;UID=sa;Database=LOGGING_01_DBF;
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Solution was:
Quote:

constexpr char username[] = "sa";
constexpr char server[] = "DESKTOP-IO1OS70\\FLYFFV21";
constexpr char password[] = "flyff"; // no encryption
in dekane.hpp