Solved Unable to connect to ODBC data source

[BufferOverflow]

Hey there!

I'm currently trying to set up a Flyff v21.2 for private use. Compiling works fine but the Account Server, but the server is unable to connect to the ODBC data source. I'm always getting "DB Login Connect Failed". I can't figure out why, even it's pretty straight forward. I made some screenshots, maybe someone finds the issue here. Thanks for any help!

Screenshots:
OS: Windows Server 2025 Standard
SQL: SQL Server 2019 Express
Used ressource: Retail V21.2 (VS22 + SQL19 + C17) from Lodelight

 

[Talos]

Did you configure your ODBC?

 

[BufferOverflow]

Did you configure your ODBC?

Yes, the imgur upload contains multiple screenshots.

 

[zOmbie]

Follow this guide and add 64bit odbc.

Guide Thread 'Installing SQL Server 2019'

Jun 12, 2024

The guide includes visuals to aid you in navigating the installation procedure for SQL Server 2019

Which you can download from here: https://archive.org/details/en_sql_server_2019_standard_x64_dvd_814b57aa_202211

• zOmbie
• Replies: 5
• Forum: Knowledge

• 

 

[Fliperworld]

Yes, the imgur upload contains multiple screenshots.

Not really ...on retail 21.2 , it's source based config...
As I could see, you created and configured odbc connections in windows, but retails 21.2 does not use them... It creates and manages its own connections, and also does not read the connection settings in the ini files.
Check out the Dekane.hpp file. Something like:

Please login and(or) register to see this awesome content today.

Also please check if your "SQL Server Native Client 11.0" is installed, since Query.cpp uses it...

My 21.2 is modified to use Sql Server 2022 and "ODBC Driver 17 for SQL Server" ...so i had to change some things...but yhat's is irrelevant for you...i suppose.

Please login and(or) register to see this awesome content today.

Edit: on your log i can see that you have edited your Dekane.hpp file, just fix your server name.
Also, ignore the ODBC part on windows, just be sure that's your driver is installed("SQL Server Native Client 11.0").

 

[BufferOverflow]

Thank you for your reply. I was unaware that parts of the INI settings, as well as the ODBC data sources, were being ignored. I've already set up V15/V18 servers, but apparently, there's always something new to learn. After correctly setting the server and password as plain text in Dekane.hpp, all other servers started working. Thank you very much for the information!