In Feburary 2016 29,
The first and most obvious thing you will need to have your own server is an Internet connection. This connection can be dedicated to the server or shared with other computers, however, there are a few things to consider when choosing an service plan for a server. The first is upstream speed. Because most Internet users download far more data than they upload to the Internet, most service plans have a drastically higher downstream speed than upstream speed. The amount needed will vary according to the type of server you wish to run. So it’s important to estimate your needs and, when shopping for service, read the fine print to ensure that the plan provides enough upstream bandwidth.
Static Internet Protocol (IP) Address
The other important consideration when shopping for service is how IP addresses are assigned. An IP address is a number that is used to identify a computer on the Internet. With most service plans, this number will often change each time a computer reconnects. This is called a Dynamic IP address. This works fine, unless you have a server that intends to have its own domain name. Domain names (such as www.ehow.com) must be looked up using a special service to translate them into a server’s IP address. However, if a server’s IP address is constantly changing, this can create problems when users try to look up your server by domain name. Therefore, it is important to purchase a Internet service plan that promises you a Static IP, one that does not change.
Dedicated Computer
While it’s quite possible to use a server computer as a desktop computer also, there are a number of reasons why this is not advisable. The biggest reason is security: servers are visible to the Internet in a way that a well-maintained desktop system usually isn’t. Running server software is essentially opening a window into a computer that is usually kept closed and locked.
Server Software
You will need software to serve the content you wish to serve. What you choose will depend on your own needs. If you wish to serve a website, the open source and very widely used program Apache is the most common. If you wish to serve an online game, you will need server software from the game’s publishers.
Security Software
Finally, and sadly, you will need security software. While you ought to have security software such as antivirus protection and a firewall running on every machine in your network, this becomes doubly important with a server. As mentioned above: running server software opens gateways into your computer that are normally left closed, and that makes it easier and more likely that your computer will be targeted by malicious hackers.
In Feburary 2016 29,
Showing posts with label Print. Show all posts
Showing posts with label Print. Show all posts
Monday, 29 February 2016
Monday, 15 February 2016
How to Sell Homemade FurnitureIn Feburary 2016 15,
In Feburary 2016 15,
For most craftspeople, initial sales come from their local area, such as neighbors that spot a chair you made and want one for themselves. That market will probably dry up quickly, but it provides you an opportunity to build some word-of-mouth marketing. You can also place ads in the local paper or in publications that cater to handcrafted items. Another option is to print brochures and catalogs to distribute at local handmade craft stores, fairs and shows. Craft shows that judge the best designers are especially effective because they give you access to customers as well as a chance to win awards that bolster your credibility.
Online Sales
The Internet offers multiple options for you to sell your furniture. A dedicated website that features images of your furniture, prices and contact info gives you access to the global marketplace. Be sure you have a secure payment processing system in place so it's easy for customers to conduct transactions. You can also sell through craft or auction sites such as Etsy or eBay. These sites typically provide the website infrastructure and payment processing, but also hit you with commission or processing fees.
In Feburary 2016 15,
For most craftspeople, initial sales come from their local area, such as neighbors that spot a chair you made and want one for themselves. That market will probably dry up quickly, but it provides you an opportunity to build some word-of-mouth marketing. You can also place ads in the local paper or in publications that cater to handcrafted items. Another option is to print brochures and catalogs to distribute at local handmade craft stores, fairs and shows. Craft shows that judge the best designers are especially effective because they give you access to customers as well as a chance to win awards that bolster your credibility.
Online Sales
The Internet offers multiple options for you to sell your furniture. A dedicated website that features images of your furniture, prices and contact info gives you access to the global marketplace. Be sure you have a secure payment processing system in place so it's easy for customers to conduct transactions. You can also sell through craft or auction sites such as Etsy or eBay. These sites typically provide the website infrastructure and payment processing, but also hit you with commission or processing fees.
In Feburary 2016 15,
Thursday, 11 February 2016
How to Execute FTP Commands With VBAIn Feburary 2016 11,
In Feburary 2016 11,
Create the FTP command file with a list of commands that the FTP client will execute. The following VBA code fragment creates such a file:Dim ftpFileHandle As IntegerftpFileHandle = FreeFileOpen 'ftpCommand.txt' For Output As #ftpFileHandlePrint #ftpFileHandle, 'open ftpserver.com'Print #ftpFileHandle, 'userid'Print #ftpFileHandle, 'password'Print #ftpFileHandle, 'send localfile.xls'Print #ftpFileHandle, 'recv remotefile.doc'Print #ftpFileHandle, 'bye'Close #ftpFileHandleReplace 'ftpserver.com' with the name of the FTP server, 'userid' with the name of your account in that server and 'password' with your password. The sample code uploads a spreadsheet contained in a file named 'localfile.xls' and downloads a document contained in a file named 'remotefile.doc.' You can use any of the commands from the 'List of FTP Commands' on the NSF Tools website before closing the session with 'bye.'
Create a batch, or executable script, file that invokes the FTP client to have it execute the FTP command file. The following VBA code fragment creates such a file:Dim batFileHandle As IntegerbatFileHandle = FreeFileOpen 'doFtp.bat' For Output As #batFileHandlePrint #batFileHandle, 'ftp -s:ftpCommand.txt'Close #batFileHandle
Execute the batch file by including the following line in your VBA code:Shell ('doFtp.bat'), vbHide '', vbMinimizedNoFocusNote that the line contains two single quotes, without any character between them, immediately before the second comma. Your VBA program will invoke the batch file that, in turn, will invoke the FTP client and have it execute the sequence of commands from Step 1.
In Feburary 2016 11,
Create the FTP command file with a list of commands that the FTP client will execute. The following VBA code fragment creates such a file:Dim ftpFileHandle As IntegerftpFileHandle = FreeFileOpen 'ftpCommand.txt' For Output As #ftpFileHandlePrint #ftpFileHandle, 'open ftpserver.com'Print #ftpFileHandle, 'userid'Print #ftpFileHandle, 'password'Print #ftpFileHandle, 'send localfile.xls'Print #ftpFileHandle, 'recv remotefile.doc'Print #ftpFileHandle, 'bye'Close #ftpFileHandleReplace 'ftpserver.com' with the name of the FTP server, 'userid' with the name of your account in that server and 'password' with your password. The sample code uploads a spreadsheet contained in a file named 'localfile.xls' and downloads a document contained in a file named 'remotefile.doc.' You can use any of the commands from the 'List of FTP Commands' on the NSF Tools website before closing the session with 'bye.'
Create a batch, or executable script, file that invokes the FTP client to have it execute the FTP command file. The following VBA code fragment creates such a file:Dim batFileHandle As IntegerbatFileHandle = FreeFileOpen 'doFtp.bat' For Output As #batFileHandlePrint #batFileHandle, 'ftp -s:ftpCommand.txt'Close #batFileHandle
Execute the batch file by including the following line in your VBA code:Shell ('doFtp.bat'), vbHide '', vbMinimizedNoFocusNote that the line contains two single quotes, without any character between them, immediately before the second comma. Your VBA program will invoke the batch file that, in turn, will invoke the FTP client and have it execute the sequence of commands from Step 1.
In Feburary 2016 11,
Tuesday, 9 February 2016
How to Insert HTML Values Into an Oracle DatabaseIn Feburary 2016 09,
In Feburary 2016 09,
Create the web page in HTML. Make sure the page includes two text input fields named 'user' and 'password.' Set the form action to call 'input.cgi' from the cgi-bin on your server. Save the HTML as 'info.html.'
Create the server side script. For PERL to speak to a database, you must use the DBI module. The following script shows how to connect to the database:!/usr/bin/perl -wuse CGI;
use DBI;
print 'Content-type: text/html\n\n';
$cgi = CGI->new();
$user = $cgi->param('user');
$password = $cgi->param('password');
$dbh = DBI->connect( 'dbi:Oracle:your_Database_name', 'your_username', 'your_password' )
or die 'Can't connect to Oracle database: $DBI::errstr\n';
You must get the values for 'your_Database_name,' 'your_username,' and 'your_password' from your server administrator. For this tutorial, it is assumed you already have this information.
Write the SQL. To do this, you must have a table set up in Oracle that can receive the two fields. Call the table 'user_auth' and make sure it has a column called 'user' and another one called 'pwd.' The following SQL statement will insert the data into the table:
$sqlstatement='INSERT INTO user_auth VALUES ('$user','$password')';
$sth=$dbh->prepare($sqlstatement);
$sth->execute || print $sqlstatement;
Confirm the data have been entered by including a print command. To do this, add the following line of code to the end of the program:
print 'Information accepted';
If this does not print out, then you can be sure the information was not sent. You must go back and check the database settings. Save the script as 'input.cgi.'
Upload the HTML and CGI files to the server. The HTML must go in docs area, and the CGI must be uploaded to the cgi-bin.
Execute the program. Do this by opening the HTML document in a browser and entering some mock information. Once you submit it, you should see the confirmation printout. If you see the printout, the information has been sent to the database.
In Feburary 2016 09,
Create the web page in HTML. Make sure the page includes two text input fields named 'user' and 'password.' Set the form action to call 'input.cgi' from the cgi-bin on your server. Save the HTML as 'info.html.'
Create the server side script. For PERL to speak to a database, you must use the DBI module. The following script shows how to connect to the database:!/usr/bin/perl -wuse CGI;
use DBI;
print 'Content-type: text/html\n\n';
$cgi = CGI->new();
$user = $cgi->param('user');
$password = $cgi->param('password');
$dbh = DBI->connect( 'dbi:Oracle:your_Database_name', 'your_username', 'your_password' )
or die 'Can't connect to Oracle database: $DBI::errstr\n';
You must get the values for 'your_Database_name,' 'your_username,' and 'your_password' from your server administrator. For this tutorial, it is assumed you already have this information.
Write the SQL. To do this, you must have a table set up in Oracle that can receive the two fields. Call the table 'user_auth' and make sure it has a column called 'user' and another one called 'pwd.' The following SQL statement will insert the data into the table:
$sqlstatement='INSERT INTO user_auth VALUES ('$user','$password')';
$sth=$dbh->prepare($sqlstatement);
$sth->execute || print $sqlstatement;
Confirm the data have been entered by including a print command. To do this, add the following line of code to the end of the program:
print 'Information accepted';
If this does not print out, then you can be sure the information was not sent. You must go back and check the database settings. Save the script as 'input.cgi.'
Upload the HTML and CGI files to the server. The HTML must go in docs area, and the CGI must be uploaded to the cgi-bin.
Execute the program. Do this by opening the HTML document in a browser and entering some mock information. Once you submit it, you should see the confirmation printout. If you see the printout, the information has been sent to the database.
In Feburary 2016 09,
Subscribe to:
Comments (Atom)