[Guide]Setting up ODBC (32/64bit)

[jM2.me]

Okay so first off we have to open Data Sources (ODBC)
32bit users go to Start > Control Panel > Administrative Tools and open Data Sources (ODBC)

64bit users go to folder c:\Windows\SysWOW64\ and open file odbcad32.exe



Now you have to click on System DSN and you will see empty list unlike me because I already have added entries. But all you do here is click Add (sorry forgot to highlight)



Then you have to select SQL Server and click Finish



After that you enter Name and Server which is (local) and click Next (sorry forgot to highlight again). Note: you will have to do this for three times, first for IRIS_LOGDB, second for IRIS_GAMEDB, and last time for IRIS_MEMBERDB



Once you are done you will see this. Select highlighted radio button and enter Login ID which is irisdb and Password which is ehdwjq10aks! Once done click Next (yeah, yeah, I know, forgot to highlight again)



Then make sure to check Change the default database to and select corresponding database and press Next (don't even ask...).
IRIS_LOGDB -> IRIS_LOGDB
IRIS_GAMEDB -> IRIS_GAMEDB
IRIS_MEMBERDB -> IRIS_MEMBERDB



Here simply enough press Finish (yey highlighted I know )



And lastly we press OK and repeat same process for other databases. Note: you can test if everything is okay by clicking on Test Data Source...



Remember do this for all three databases, at the end you must have something like in first picture

Credits:
Me for writing this guide and everyone else who worked on iris

[MentaL]

[Memiko]

thank you for the guide.

[l2runner]

W00t! Thanks very much! I forgot to change the default database that's why im having errors. thanks again :)

[kuza2007]

I have setup as you shown but stuck when I check (change the defauld database to) i cant find IRIS_LOGDB only has (system database DB)....

[Stoner66]

Once I get to the part that where I have to type the user and pass in it gives me this error...

[TriumpH]

Just read

SQL server does not exist as in sql is not installed or not running as a service and or the user/pw is wrong

[Stoner66]

I have the sql running and the user/pass is correct....

[cyloneboy]

Actually at this parts i cant use "(local)" as my listen server, which i can only select my operating SQLserver name.. < --- is that correct to be done?

[vodafono]

help

error

[tompika]

Try VODAFONO\SQLEXPRESS instead of (local), cause you use name instance.

[vodafono]

ahhhhh ok thx 1000

[super man]

I've tried all different types of things now and I still get the same error all the others are.

Help please :)

[tikkaroe]

show your error screen, others may help you.

[scruff]

OMGZ THANK YOU!!!!! this was where i have been stuck at the past few days. i needed to put\SQLEXPRESS on the server title. such a simple fix, just glad it works!