About ODBC

[labads]

can somebody teach me on how to setup my ODBC's?....
the video from Serus is in Low Quality.....
Please help !!!

 

[aldieri]

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.

 

[labads]

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?

 

[aldieri]

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.

 

[labads]

sorry...i thought logging_dbf
trying to run my flyff ^_^

 

[aldieri]

sorry...i thought logging_dbf
trying to run my flyff ^_^

login goes to ACCOUNT_DBF
character01 goes to CHARACTER_01_DBF
log01 goes to LOG_01_DBF

 

[labads]

another problem T_T
when my game loads...it disappears
what had happened?
alreay deleted flyff.a

 

[aldieri]

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.

 

[labads]

nevermind that loading thing ^_^
but how to create my account?

 

[aldieri]

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)

You must be registered to see links

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

Hope this helps!

 

[mines]

i get error:
''DB Login Connect Failed''
What is that?
And how can i fix that?