[v1.2] Complete Pangya Setup Guide

[GroGro]

Great tutorial, Been following it from the start but I have come across a problem.

In the ODBC screen, I click 'Add...' then I click on the 'SQL Server Native Client 10.0' then 'Finish', After that I call the connection 'ini3_py_account' but when I click on the dropdown menu to select a server, the window lags and eventually it does show a list but it is just white space with no options. I tried Copy/Pasting the Server name and using '(local)' like on the demonstration, That got me to the next window but if I press 'Next' again and change the default database to 'ini3_py_account' and click next it just says 'The database entered is not valid'

Hope you know what this is and can help me soon!

EDIT: Can't believe I forgot to mention this, I am on Windows 7 64x

[chreadie]

You have to use the odbcad32.exe inside C:\Windows\SysWOW64\ to make it work when on 64bit

[GroGro]

You have to use the odbcad32.exe inside C:\Windows\SysWOW64\ to make it work when on 64bit

Same result, I still get an empty drop down Menu. Thank You for the reply though.

[terrorofdeath]

There are two of those ODBC things for 32 and 64; you should set up the ODBC connections for both types. (How I did it myself, I don't recall. >_<)

(Same for the registry if you run across the update problem.)

[GroGro]

There are two of those ODBC things for 32 and 64; you should set up the ODBC connections for both types. (How I did it myself, I don't recall. >_<)

(Same for the registry if you run across the update problem.)

But I can't set it up at all because it doesn't show up any servers!

Hope the issue can get resolved soon, Can't wait to set up the server!

EDIT: Thought I would post a picture.

[X_Sarah_X]

For SQL Servername you want to add the following:

<SQL hostname or ip>\SQLEXPRESS (if you named the instance SQLEXPRESS)

so lets say your ip is 12.34.56.78 and you named your SQL Instance "PANGYASQL" your servername would be:

12.34.56.78\PANGYASQL

[GroGro]

EDIT: Decided to start the thing over again and when I did I realised that I had missed a LOT of stuff that is most likely causing me many issues.

When I run the 'Bootstrap' Execution THIS is what I get.

When I run 'INI3BIll_DB' THIS is what I get.

When I run 'ini3_py_account' THIS is what I get.

When I run 'Pangya_S4_TH' THIS is what I get.

When I run 'Pangya Items' THIS is what I get.

Why is there so many errors? lol Its crazy!

[crazykirs]

are there any working clients to download suit for this?

[Tsukasa]

EDIT: Decided to start the thing over again and when I did I realised that I had missed a LOT of stuff that is most likely causing me many issues.

When I run the 'Bootstrap' Execution THIS is what I get.

When I run 'INI3BIll_DB' THIS is what I get.

When I run 'ini3_py_account' THIS is what I get.

When I run 'Pangya_S4_TH' THIS is what I get.

When I run 'Pangya Items' THIS is what I get.

Why is there so many errors? lol Its crazy!

A failing bootstrapper will result in non-existent databases, groups and database users, therefore resulting in the errors you see. From the output I guess you're using SQL Server 2005 (which will give you the LOGIN errors, from what I recall from the original release thread). Try SQL Server 2008 (Express edition will do) and start over.

are there any working clients to download suit for this?

See this thread. The MegaUpload folders gets updated on a regular basis to provide you the full client setup + the latest patch to bring the client up to par.

As an alternative you can try this pre-patched client (be sure to read the thread beforehand!).

[GroGro]

I am actually using 2008 >_<

I have no idea why I am getting those errors

[Sonict]

It would be nice if there could be a guide on how to add some of the new fixes to the database since these aren't in the current release. For example... This: http://forum.ragezone.com/f513/relea...ave_s4-720758/ (You also need to add a new field to the table...) and this: http://forum.ragezone.com/f513/relea...veitem-721247/ (You need to populate a table with some info)

This would be helpful for me as I tried my best, but I can't figure it out.

Thanks!

[GroGro]

I previously had SQL 2005 a few months ago while trying to make a server without the Guide and after giving up on that I un-installed and then when this guide came along I installed 2008. I think some parts of 2005 are still hanging around in the registry maybe, And after a reinstall of 2008 I can't even connect to the server!

Anyone know how I can totally wipe SQL 2005/2008 so I can start fresh?

[gempz]

when I try to open the ProjectG.exe, "Please re-install the game or run the update program first" message pop up. can anyone help me plz?

[malcomtidus]

Please, look around a little bit. The answer is in the "beginner questions" thread.

http://forum.ragezone.com/f200/commo...stions-715711/

[gempz]

Well it fixed, but new prob comes..
this time, "An error occured while receiving the file list from the server." message comes out..

---------- Post added at 07:29 AM ---------- Previous post was at 07:25 AM ----------

Well it fixed, but new prob comes..
this time, "An error occured while receiving the file list from the server." message comes out..