Please help how to make apps work in network?

[witecloner]

Hi all, i have finished build a simple inventory program. But this program just only work in single pc not at network. Could any body tell me how to make it work in network (multiple pc in network)? thank you...

 

[witecloner]

Help! Run Apps in Network Please...

Hi all could any body tell me how to make vb.net program will run on multiple pc in a network and use together?

i have try using ntire method but when i access to that's program it's send me an error...


thank's

 

[formlesstree4]

You could have the program utilize a database, put the database on a public server that all PC's can access, and just distribute the program.

 

[witecloner]

wew...i still got a problem. my problem is, like above...

How to solved it, i have try search in google and try so many method to do it. But it's not work.

Here above my computer spesification that's i used to put my database and application.
OS . Windows Xp Home Edition (i have try using XP Prof Sp 2, Result it's same), memory 2GB, HDD 80GB, etc.
My Database Server Using SQL SERVER 2005 Express Edition.

Thank you

 

[formlesstree4]

Your error is saying that it can't connect, obviously.

It's also giving you a suggestion. Make sure that your server you're connecting to is allowing remote connections, or has the appropriate port(s) opened up for it to connect successfully.

 

[witecloner]

ok, i have try to allow remote connection in sql server 2005 express edition and it's not work. still show the same error. So i try again to build a very simple database application that using dataset. My Server Computer name is PC2 and the Client name is PC3Client (that's full computer name) And here above is my app.config file :

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="nTrad.My.MySettings.NTRADDBConnectionString" connectionString="Data Source=PC2\SQLEXPRESS;Initial Catalog=NTRADDB;Integrated Security=True;Pooling=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.diagnostics>
        <sources>
            <!-- This section defines the logging configuration for My.Application.Log -->
            <source name="DefaultSource" switchName="DefaultSwitch">
                <listeners>
                    <add name="FileLog"/>
                    <!-- Uncomment the below section to write to the Application Event Log -->
                    <!--<add name="EventLog"/>-->
                </listeners>
            </source>
        </sources>
        <switches>
            <add name="DefaultSwitch" value="Information" />
        </switches>
        <sharedListeners>
            <add name="FileLog"
                 type="Microsoft.VisualBasic.Logging.FileLogTraceListener, Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"
                 initializeData="FileLogWriter"/>
            <!-- Uncomment the below section and replace APPLICATION_NAME with the name of your application to write to the Application Event Log -->
            <!--<add name="EventLog" type="System.Diagnostics.EventLogTraceListener" initializeData="APPLICATION_NAME"/> -->
        </sharedListeners>
    </system.diagnostics>
</configuration>

And I configure my sql sever 2005 in SQL Surface Area Configuration, in tab Surface Area Configuration for Services at Database Engine, Remote Connection i select Local and Remote Connections, Using TCP/IP only. After that, in TCP/IP at Protocols for SQLExpress(My Instance Name) , in IP Addresses tab at IP address i use my server ip address that is 192.168.248.1. and all i left it to default (and the default port at IPAII is 1108).

OK, now i doing a configuration again in Surface Area Configuration, Database Engine, Ad Hoc Remote Queries, i check list at Enable Open.....

After i finish configure the server now i take a look at client. My Client using Windows Xp Prof Sp2 and it's a fresh instalation. So i decided to install .NET Framework 3.5, and SQL Server 2005 Express Edition, and SQL Server Management Studio Express. the client ip is 192.168.248.10, and i configure at the sql server 2005 same as the first at server. ALL is SAME!

Ok, i share my application, and run it from client computer, error show like my last question before. so i try to reconfigure again the app.config file in connection string i change this value.

<connectionStrings>
        <add name="nTrad.My.MySettings.NTRADDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=NTRADDB;Integrated Security=True;Pooling=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

and now the error is LOGIN FAILED for CLIENT02/PC3...bla..bla..bla...

Please whose have the complete tutorial that tell about how to build simple client-server database application with full complete tutorial about how to configure it.

Thank you

 

[witecloner]

Thanks formlesstree4 you'r right, My Problem is solved now. I have try using XP Professional to create simple client-server app, and it's work (with a little bit more configuration too ). The problem is in my Operating System. Windows Xp Home Edition not support Remote Connection so i cannot place my server over there.

Thank you again to formlesstree4.
Witecloner

 

[formlesstree4]

Glad to have helped.