Clan System Issues

Hey Guys,

I have been fighting with getting this clan system working for days now, followed several if not every clan related post on this forum but have not had a bit of luck. Hopefully I will be able to help other people with their problems aswell. Orginaly I have getting error 57 until I realized that My ISP that my test server uses blocks port 80. So for now we are gonna stick with working on the LAN. I got Past the error 57 now but I have been getting error 58 for a while now.

I have followed HappyHardCore's
http://forum.ragezone.com/priston-ta...de-166920.html
and Operz's
http://forum.ragezone.com/priston-ta...ed-164246.html
Guides, although well written and very usefull, I still hit a dead end

I have tried double, Triple, even Quadruple checking my configs but to no avail. Heres what I have been working with:

I have 3 different ID's that authenticate with SQL Server Management Studio Express.
Local Administrator - Windows Authentication
clanmaster - SQL authentication
sa - SQL authentication

Orginaly I also had issues with Mixed Mode Authentication. When I installed SQL I chose Windows Intergrated Authentication. After Browsing MS's Knowledge Base I discovered that I can change this through the registry. All 3 user accounts authenticate and I can manage the DataBase.

Here is the File System
Clan folder
http://www.geocities.com/mustang_bj_1999/clan.JPG

ServerMain
http://www.geocities.com/mustang_bj_1999/servermain.JPG

And here are my lines of code

ClanInsert .aspx (the important part)

Code:

---


<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<%@ Page Language="VB" %>
<script runat="server">
Dim connectionString As String = "server='NA-1GB9LR3PPEI8\SQLEXPRESS'; user id='clanManager'; password='mypass:bad: '; database='ClanDB'"

---

Common.inc (important Part again)

Code:

---


xConnection = "Provider=MSDASQL;Driver={SQL Server};Server=NA-1GB9LR3PPEI8\SQLEXPRESS;Database=ClanDb;Uid=clanManager;Pwd=mypass"

---

settings.inc (same as before)

Code:

---

Sub FillSettings()
 dbhost = "NA-1GB9LR3PPEI8\SQLEXPRESS"
 dbuser = "clanManager"
 dbpass = "mypass"
 dbname = "ClanDB"
End Sub
%>

---

my clandb.reg

Code:

---


[HKEY_CURRENT_USER\Software\PristonTale]
[HKEY_CURRENT_USER\Software\PristonTale\GameServer]
"ServerName"="RPT"
"LogPath"="C:\\Program Files\\TriglowPictures\\PristonTale\\ClanLogs"
"SODDbIP"="127.0.0.1"
"SODDbID"="clanManager"
"SODDbPwd"="mypass"
"SODDbName"="Sod2DB"
"ClanDbID"="clanMaster"
"ClanDbPwd"="mypass"
"ClanDbName"="ClanDb"
"ClanDbIP"="127.0.0.1"

---

oh and almost forgot here is my BillingDBError log. This is all that is listed only difference is the id's

Code:

---

004047|SELECT IDX FROM ClanSubView WHERE userid='' and ChName='rthsnake' and DelActive=0 [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
004103|DELETE FROM ClanTicket WHERE userid='rthsnake'

---

I have tried using different ID's(sa, clanMaster) and IP's (localhost, LAN)
I think I got all the important files. Let me know if I need anything else posted. I appreciate any help provided. :ala:

error 57 is a not have conection to sql..

I Posted that I fixed 57, I am getting error 58

Quote:

---

I got Past the error 57 now but I have been getting error 58 for a while now.

---