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)
Common.inc (important Part again)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'"
settings.inc (same as before)Code:
xConnection = "Provider=MSDASQL;Driver={SQL Server};Server=NA-1GB9LR3PPEI8\SQLEXPRESS;Database=ClanDb;Uid=clanManager;Pwd=mypass"
my clandb.regCode:Sub FillSettings()
dbhost = "NA-1GB9LR3PPEI8\SQLEXPRESS"
dbuser = "clanManager"
dbpass = "mypass"
dbname = "ClanDB"
End Sub
%>
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
I have tried using different ID's(sa, clanMaster) and IP's (localhost, LAN)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 think I got all the important files. Let me know if I need anything else posted. I appreciate any help provided. :ala:
