Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

About ODBC

Newbie Spellweaver
Joined
May 2, 2009
Messages
10
Reaction score
0
can somebody teach me on how to setup my ODBC's?....
the video from Serus is in Low Quality.....
Please help !!!
 
Banned
Banned
Joined
Oct 14, 2008
Messages
246
Reaction score
123
can somebody teach me on how to setup my ODBC's?....
the video from Serus is in Low Quality.....
Please help !!!

Well open the ODBC panel, by going to start the search bar type in 'ODBC' Open it.
OR Goto 'run' type in odbcad32 and click enter. (Run or windows key + R)

You'll have to add three things here.
1.character01
2.login
3.log01

1. character01
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: character01
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: CHARACTER_01_DBF
I) Click next, and then finish.

2. login
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: character01
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: ACCOUNT_DBF
I) Click next, and then finish.


3. log01
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: character01
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: LOG_01_DBF
I) Click next, and then finish.
 
Last edited:
Newbie Spellweaver
Joined
May 2, 2009
Messages
10
Reaction score
0
working ty..
another problem....
when i tried to open account server it had an error

this is the messsage i got from the Logfile
2009/12/31 21:28:37
query:LOGINJOIN_STR 'A3', '(null)'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'LOGINJOIN_STR'.

can you help?
 
Last edited:
Banned
Banned
Joined
Oct 14, 2008
Messages
246
Reaction score
123
working ty..
another problem....
when i tried to open account server it had an error

this is the messsage i got from the Logfile


can you help?

Think it might mean you didn't do the account ODBC correctly, let me test.

Edit: Yes if you didn't link login to ACCOUNT_DBF then it will give that error.

Make sure login is connect to ACCOUNT_DBF.

Add me to msn it'll be much easier then, andrewaldieri@msn.com.
 
Last edited:
Newbie Spellweaver
Joined
May 2, 2009
Messages
10
Reaction score
0
sorry...i thought logging_dbf
trying to run my flyff ^_^
 
Newbie Spellweaver
Joined
May 2, 2009
Messages
10
Reaction score
0
another problem T_T
when my game loads...it disappears
what had happened?
alreay deleted flyff.a
 
Banned
Banned
Joined
Oct 14, 2008
Messages
246
Reaction score
123
another problem T_T
when my game loads...it disappears
what had happened?
alreay deleted flyff.a

Whats the error log in your game folder say? (Error.txt)

Also do you have data.res, datasub1.res and datasub2.res in that folder.
 
Newbie Spellweaver
Joined
May 2, 2009
Messages
10
Reaction score
0
nevermind that loading thing ^_^
but how to create my account?
 
Banned
Banned
Joined
Oct 14, 2008
Messages
246
Reaction score
123
nevermind that loading thing ^_^
but how to create my account?

Open SQL Server Management Studio Express, go to your ACCOUNT_DBF.
You'll see Programmability. Then 'Stored Procedures'. Then right click dbo.createaccount. 'Execute Stored Procedure.'

You'll See
@account row
@password row

@account row under the Value is the account name 'make it lowercase'
@password value is the password -REMEMBER THAT THIS NEEDS TO BE Salt+Password (AS MD5 HASH)

Default Salts:
v11: nForceisGay
v14: kikugalanet

So if you want your password to be apples. you'll have to do
nForceisGayapples (For v11)
and kikugalanetapples (For v14)



v11 md5 hash for apples: d386d27157bcb483427d488b47c5cd47
v14 md5 hash for appples: ab57eb732e27dff2a6f212699ea8888c

Hope this helps!
 
Newbie Spellweaver
Joined
Nov 4, 2009
Messages
10
Reaction score
0
i get error:
''DB Login Connect Failed''
What is that?
And how can i fix that?
 
Back
Top