Login / ODBC error

11/04/2010 18:37 NicoBlacktir#1
I have the damned odbc all RTS register all went super well.

Then came a complete idiot has always done well here's what this error at the register.




Warning: odbc_connect () [function.odbc-connect]: SQL error: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C: \ xampp \ htdocs \ register. php on line 28

Warning: odbc_do () expects parameter 1 to be resource, boolean given in C: \ xampp \ htdocs \ register.php on line 34

Warning: odbc_fetch_row () expects parameter 1 to be resource, null given in C: \ xampp \ htdocs \ register.php on line 35

Warning: odbc_result () expects parameter 1 to be resource, null given in C: \ xampp \ htdocs \ register.php on line 36


am responding to a answer




2.

how can i add new npc on a map ?
11/05/2010 00:17 janvier123#2
1 search
2 search
;)
11/05/2010 05:47 yahoo5000#3
Quote:
Originally Posted by NicoBlacktir View Post
I have the damned odbc all RTS register all went super well.

Then came a complete idiot has always done well here's what this error at the register.




Warning: odbc_connect () [function.odbc-connect]: SQL error: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C: \ xampp \ htdocs \ register. php on line 28

Warning: odbc_do () expects parameter 1 to be resource, boolean given in C: \ xampp \ htdocs \ register.php on line 34

Warning: odbc_fetch_row () expects parameter 1 to be resource, null given in C: \ xampp \ htdocs \ register.php on line 35

Warning: odbc_result () expects parameter 1 to be resource, null given in C: \ xampp \ htdocs \ register.php on line 36


am responding to a answer




2.

how can i add new npc on a map ?
1. chenck your register.php in some file are wrong password i think
2. go to share/map/07_loa/npc_07_loa.csv

in that csv add your npc index example :
npc index :701
dec :80
x:250
y:250
11/05/2010 16:38 NicoBlacktir#4
Quote:
Originally Posted by yahoo5000 View Post
1. chenck your register.php in some file are wrong password i think
2. go to share/map/07_loa/npc_07_loa.csv

in that csv add your npc index example :
npc index :701
dec :80
x:250
y:250
Yea i know that but where can i find the Dec.

i look at Trane but he dont say where we can find the dec. number
11/05/2010 17:46 yahoo5000#5
Quote:
Originally Posted by NicoBlacktir View Post
Yea i know that but where can i find the Dec.

i look at Trane but he dont say where we can find the dec. number
hmm realy i dont know , try use any dec or search from another map , but i thing dec are something like data/script/string folder
11/05/2010 22:24 NicoBlacktir#6
DONE I FOUND IT !!!!!!

he mean Desc that can you found at npc line to right side 4


#### Close !
11/06/2010 01:33 -8gX#7
odbc_connect('Driver={SQL Server};Server=<serverip>;Database=account;','user name','password');

To fix your SQL error, I think. I would recommend using mssql_connect. Makes everything a lot easier because it has almost the same syntax as mysql.
11/06/2010 11:53 janvier123#8
Quote:
Originally Posted by -8gX View Post
odbc_connect('Driver={SQL Server};Server=<serverip>;Database=account;','user name','password');

To fix your SQL error, I think. I would recommend using mssql_connect. Makes everything a lot easier because it has almost the same syntax as mysql.
Quote:
Originally Posted by janvier123 View Post
well its easy
open your PHP.INI in your xampp or whate even you use
path for xampp "\xampp\php"

and look for

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

Find:

;extension=php_mssql.dll

note that there is a ; before the line
remove the ; save file and restart xampp

you should have

extension=php_mssql.dll

That's it :)
IF mssql_connect does not work
11/06/2010 11:56 ~Kakkarot~#9
Quote:
Originally Posted by NicoBlacktir View Post
DONE I FOUND IT !!!!!!

he mean Desc that can you found at npc line to right side 4


#### Close !
#closed