SQL Help!!!

[neo1uk]

i have got ms sql working but one problem m2.exe in C:\mirserver\m2server

cart login to the sql database because cart read or somthing

am adding a pic so u can take a look and see if u can help

and i think i know the problem but not to sure but is the sql "mir2" data base ment to be readonly!!?

\neo16uk

 

[Amenovis]

did u setup odbc ?? odbc is the part that windows can comunicate with the sql

have a look there : http://www.mirfiles.com/ look for LS-Guide its for lom3 but also usable for Lom2 TD´s files (sql setup and odbc setup part)

 

[neo1uk]

Thank m8 onistly i been pulling my hair out hehe

 

[neo1uk]

still got problem with the mir2 crap in sql server database its still readonly and will not let me change to turn off read only gives me this error

 

[Amenovis]

ehm i wonder what u do there ???
delete that db mir2 fully ! right click with mouse and kill it... than have a look inside the guide that i linked u .....and look for new database and restore database..... its also inside and usable for lom2

btw if u use TD files u should call the db also lom2 cause in the dbsvr.ini and !setup.txt there are the db is called also lom2 . if u use another name u must change later both (the names.... the sa pass u must change also)

also i ask me if u had installed sql server right if he make that (read only) self than there is something wrong m8

 

[neo1uk]

thanks again got that bit one more problem
m2.exe dont open the database propley any ideas?

heres is a pick

 

[Amenovis]

u must edit ur dbsvr.ini (inside dbserver folder) and ur !setup.txt (inside ur m2server folder) also u must rename lom2_chardb to lom2 than it will work

 

[neo1uk]

ok ty again hehe ty for all the help you should be a lomcn mod tbh

 

[Amenovis]

na no way i help today only so much cause i have not much todo today normaly i have not really time

 

[neo1uk]

lol fare dos well any ways my server has life all green lights thanks to you so thanks bud been great help

server is online now

 

[neo1uk]

one last thing bud what client dose it use as the clients am trying dont work

 

[Amenovis]

np m8 if there is a new prob write or pm me if i can i will help u (posting is better as pm cause maybe another one have the same prob as u )

lg

ameno

 

[Elvin]

if ur using tds files there should be a mir2.exe inside them, if ur suing the files jasper and i put together there should also be a mir2.exe inthem also.

How many DBs are you using just the lom2 db or lom2_chardb and lom2_datadb.
if its just one then in !setup it should be like this
[SQL]
UseSQL=TRUE
SQLHost=(local) some people have problems with this also it can be 127.0.0.1 or localhost
SQLUsername=sa
SQLPassword=*REMOVED*
SQLDatabase=lom2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=lom2



and in dbsrc it should be like this
SQLType=mssql
SQLHost=(local) as above
SQLPort=3306
SQLDatabase=lom2

 

[neo1uk]

the cleints and such still dont work so am giving up with the sql version

i keep trying and its not working altho i have found an error so maybe somone can tell me what it meens

 

[Amenovis]

that with not found is only that u have a entry in the merchant.txt(lom3)

(in ur version TD FILES ! its a db part called merchant)

inside the merchant part stay all npc that are usable

the prob is that u havent the maps GA and other thats why he can not put a NPC on a map that u didnt have.

so if u took the name out from that npc (shown in ur m2server) and delete that npc out from merchant db part that errors away.

why u have that socket error i dunno m8 rly therefor another one must answer and i dont would give up the files are rly nice if u are ingame

 

[neo1uk]

okkooky ty well am still trying to sort the problem ty guys am close now nayle got it

 

[koni]

the socket error is being caused by an incorrect ip address or a pnp issue

now if your running the files offline and you are not on a router set your ip's to 127.0.0.1

if your on a router the ips in the files need to be your local ip ie, 192.168.*.*

your router will need to have ports 7000 7100 7200 forwarded to your internal ip 192.168.*.*

port forwarding guides can be found here:
http://portforward.com/routers.htm

if its not an ip issue you need to download and run unpnp to turn the pnp off on your pc

download from here:
http://fernys.co.uk/elements_page6.htm

 

[neo16uk]

wrong place sorry didn't read my bad