I've done every progress in the tutorial video.
And I can't buy item in myshop.
Yes, I already know the disccusion about this problem about linking with IIS webserver and database.
But I don't understand what they means, cus I don't care about computer language whole my life time.
I already change ip of client at 5 position with my ip.(start with 180.)
Let me know what I have to do and how can I fix it.
1. I confuse the making webserver.
I guess the program Ms SQL server including the IIS program or something like that because the server can run.
But seeing that the server don't respond when buying the item myshop, I guess three possibility.
first. I need another program and additional progress for webserver.(Using like AMP or php, mysql)
second. I miss the some progress what I have to do.
three. there exists more progress what I have to do.
Which is right?
2. I don't understand about 'link webserver with database'
If MS SQL server includes IIS program, I've done for linking webserver with database. And I have to accomplish more progress to link completely.
Or the progress including obdcad32.exe might be the linking progress. But I follow that progress exactly what I see. In this case some computer setting is wrong condition.
I know the fact that above guesses is worthless for you. I just have to sort my thinking for understanding your advices.
I'm really appreciate if you explain what I have to do in step by step.
And I prepare some picture for your convenience.
1. run the trickster client
2. Myshop disconnect
3. Create IIS server.
4. Install PHPManagerForIIS-1.2.0-x64
5. Create new windows user "tricktser"
6. install php driver for sql server
>> my computer has ODBC dirver 11. so i installed php 5.6(non thread safe for IIS) and SQLSRV 3.2, right? I just follw the microsoft recommendation.
php-5.6.29-nts-Win32-VC11-x64
7. I select php_pdo_sqlsrv_56_nts.dll, php_sqlsrv_56_ts file and paste it in C:\inetpub\php-5.6.29-nts-Win32-VC11-x64\ext where php ext file.
8. I change the context of php.ini file.
9. I create connect file. and paste it wwwroot file. the context is below.
<?php
$ServerName = "HK-PC\SQL";
$connectionInfo = array( "Database"=>"gmg_account");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn )
{
echo "Connection established.\n";
}
else
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
?>
10. And I got HTTP 500 errer sitll........ (from my localhost/connect.php...)
11. Distributed Transaction Coordinator start it, also to make it automatic startup
12. I install webmatrix for asp file. opened C:\Trickster\trickster-online-s2-server-release\CBA\Inc\config.asp change like below.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="950"%>
<%
Option Explicit
response.Buffer = True
response.Charset = "big5"
Server.ScriptTimeout = 180
Dim MsSqlIp, MsSqlData, MsSqlUserName, MsSqlPassWord
Dim HostName
'################MsSQLシニセレョwウsアオウ]クm################
MsSqlIp = "192.168.25.28,1443"
MsSqlData = "gmg_account"
MsSqlUserName = "eliza"
MsSqlPassWord = "password" << my sql password
'####################ウ]クmコクォHョァ####################
HostName = "http://" & request.ServerVariables("HTTP_HOST") & "/"
%>
13. I edit web.config from C:\Trickster\trickster-online-s2-server-release\CBA like below.
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<defaultDocument>
<files>
<clear />
<add value="index.html" />
<add value="index.asp" />
</files>
</defaultDocument>
</system.webServer>
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SqlServerCe.4.0" />
<add invariant="System.Data.SqlServerCe.4.0" name="Microsoft® SQL Server® Compact 4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<add connectionString="server=HK-PC\SQL;database=gmg_account;uid=eliza;pwd=password" name="gmg_account" providerName="System.Data.SqlClient" />
<add connectionString="Server=HK-PC\SQL;Database=trickster;Uid=eliza;Pwd=password" name="trickster" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
I don't have idea about DbPrividerFactories contents. What should I write there?
14. I hexed my clinet 5 position(search 180). Where is the two additional position needed fixing?
15. ISS connection stiring.
Q. How could I link gmg_account and trickster databases to my IIS webserver?
Q. I use wireless router. And I can run the server with my ipconfig ip(IPv4 192.168.25.48 now). But I wondering I have to use public ip where is confirmed by internet web site.211.212.6.190
This content is all the thing I have done.
I waiting for your advices. Thanks.
And I can't buy item in myshop.
Yes, I already know the disccusion about this problem about linking with IIS webserver and database.
But I don't understand what they means, cus I don't care about computer language whole my life time.
I already change ip of client at 5 position with my ip.(start with 180.)
Let me know what I have to do and how can I fix it.
1. I confuse the making webserver.
I guess the program Ms SQL server including the IIS program or something like that because the server can run.
But seeing that the server don't respond when buying the item myshop, I guess three possibility.
first. I need another program and additional progress for webserver.(Using like AMP or php, mysql)
second. I miss the some progress what I have to do.
three. there exists more progress what I have to do.
Which is right?
2. I don't understand about 'link webserver with database'
If MS SQL server includes IIS program, I've done for linking webserver with database. And I have to accomplish more progress to link completely.
Or the progress including obdcad32.exe might be the linking progress. But I follow that progress exactly what I see. In this case some computer setting is wrong condition.
I know the fact that above guesses is worthless for you. I just have to sort my thinking for understanding your advices.
I'm really appreciate if you explain what I have to do in step by step.
And I prepare some picture for your convenience.
1. run the trickster client
2. Myshop disconnect
3. Create IIS server.
4. Install PHPManagerForIIS-1.2.0-x64
5. Create new windows user "tricktser"
6. install php driver for sql server
>> my computer has ODBC dirver 11. so i installed php 5.6(non thread safe for IIS) and SQLSRV 3.2, right? I just follw the microsoft recommendation.
php-5.6.29-nts-Win32-VC11-x64
7. I select php_pdo_sqlsrv_56_nts.dll, php_sqlsrv_56_ts file and paste it in C:\inetpub\php-5.6.29-nts-Win32-VC11-x64\ext where php ext file.
8. I change the context of php.ini file.
9. I create connect file. and paste it wwwroot file. the context is below.
<?php
$ServerName = "HK-PC\SQL";
$connectionInfo = array( "Database"=>"gmg_account");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn )
{
echo "Connection established.\n";
}
else
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
?>
10. And I got HTTP 500 errer sitll........ (from my localhost/connect.php...)
11. Distributed Transaction Coordinator start it, also to make it automatic startup
12. I install webmatrix for asp file. opened C:\Trickster\trickster-online-s2-server-release\CBA\Inc\config.asp change like below.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="950"%>
<%
Option Explicit
response.Buffer = True
response.Charset = "big5"
Server.ScriptTimeout = 180
Dim MsSqlIp, MsSqlData, MsSqlUserName, MsSqlPassWord
Dim HostName
'################MsSQLシニセレョwウsアオウ]クm################
MsSqlIp = "192.168.25.28,1443"
MsSqlData = "gmg_account"
MsSqlUserName = "eliza"
MsSqlPassWord = "password" << my sql password
'####################ウ]クmコクォHョァ####################
HostName = "http://" & request.ServerVariables("HTTP_HOST") & "/"
%>
13. I edit web.config from C:\Trickster\trickster-online-s2-server-release\CBA like below.
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<defaultDocument>
<files>
<clear />
<add value="index.html" />
<add value="index.asp" />
</files>
</defaultDocument>
</system.webServer>
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SqlServerCe.4.0" />
<add invariant="System.Data.SqlServerCe.4.0" name="Microsoft® SQL Server® Compact 4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<add connectionString="server=HK-PC\SQL;database=gmg_account;uid=eliza;pwd=password" name="gmg_account" providerName="System.Data.SqlClient" />
<add connectionString="Server=HK-PC\SQL;Database=trickster;Uid=eliza;Pwd=password" name="trickster" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
I don't have idea about DbPrividerFactories contents. What should I write there?
14. I hexed my clinet 5 position(search 180). Where is the two additional position needed fixing?
15. ISS connection stiring.
Q. How could I link gmg_account and trickster databases to my IIS webserver?
Q. I use wireless router. And I can run the server with my ipconfig ip(IPv4 192.168.25.48 now). But I wondering I have to use public ip where is confirmed by internet web site.211.212.6.190
This content is all the thing I have done.
I waiting for your advices. Thanks.
Attachments
You must be registered for see attachments list
Last edited: