Community-Credit.com | NonProfitWays.com | SOAPitstop.com   Skin:   
      User: Not logged in 
Home
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Presentations
Featured Articles
Book Chapters
Training Courses
Events
NewsGroups
 
Discussions
Examples
Tutorials
Tools
Articles
Resources
Websites
 
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
Logout
 
About Me
My Blog
HeadGeek Articles
Talking Portfolio
Resume
Pictures
World Trip Pics


Articles

 ADO.NET (206)  Pattern (3)  WebDAV (17)  XMLHTTP (3)
 Database (35)  RDF (28)  WebService (230)  XMPP (9)
 Debugging (29)  RSS (29)  WML (95)  XPath (78)
 DIME (14)  SAX (56)  WSDL (80)  XPointer (12)
 DOM (56)  Schema (47)  XAML (5)  XQL (24)
 DTD (23)  SMIL (38)  XBRL (64)  XQuery (72)
 ebXML (56)  SOA (9)  XForms (92)  XSchema (30)
 Flash (12)  SOAP (136)  XHTML (112)  XSL (423)
 Humor (1)  SQL (16)  XLL (1)  XSL-FO (29)
 Java (77)  SQLXML (142)  XML (780)  XSQL (6)
 MathML (11)  SVG (56)  XML.NET (86)  XUL (13)
 Oracle (29)  VoiceXML (82)  XMLA (2)

Total Articles: 3,454

 


database Articles
Prev Next
1 2
 
DERBY Java Database FAQs
Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview? Check out this collection of DERBY Java Database FAQs...

Type: Database  #Views: 256  Category: Article    

Appointment Booking System
There was a time when a small dictionary sized book was enough to note down the appointments that one reserved for his clients. Today the businesses have grown beyond one’s imagination. Even the small scale business goes through end number of activities that are undertaken for organizing the work front. This massive change can be well evaluated with the presence of online appointment system. The appointments which were a tedious task earlier are now a matter of comfort. Most of the companies use scheduling software to make their appointment booking system more flexible and less time consuming. It’s very easy to use since you get an online calendar to schedule appointments. You just need to have the basic computer operating skills in order to simplify your appointing process.

Type: Database  #Views: 325  Category: Article    

Online Appointment Scheduling
Manage your appointments with the most user friendly online calendar and online appointment scheduling management software. Now take online appointments in minutes. Web-based online calendar that manages your schedule and shared resources. Sync appointments with friends and colleagues, schedule appointments with local businesses, and much more. Offer your services online and let your customers use Clockshare to book appointments with you. People in your area already use Clockshare to manage their own appointments, and to book appointments with companies like yours.

Type: Database  #Views: 311  Category: Article    

Cash Advance
Online Payday Loans and Cash Advance in Canada for Canadians by ecash canada. Get fast cash till Pay Day.

Type: Database  #Views: 535  Category: Article    

Microsoft SQL Server FAQs
This FAQ has answers to many frequently asked questions about MS SQL Server. Browse through this collection, you will find those questions and answers useful to improve your MS SQL Server knowledge and programming skills.

Type: Database  #Views: 699  Category: Article    

Metal Roofing Prices

Type: Database  #Views: 500  Category: Article    

Quit Smoking
Ultimate quit-smoking system successful to create simplest & safest way to stop smoking forever and enjoy the wonderful freedom of becoming a non-smoker at long last.

Type: Database  #Views: 420  Category: Article    

Metal Roofing
Top Rated Metal Roofing services and metal roofs. Get high quality metal roofing materials from the best companies around. Get tips and prices on installing metal roofing.

Type: Database  #Views: 450  Category: Article    

SQL Server FAQs - Configuring ODBC Connection and DSN for SQL Servers
A collection of 13 FAQs on connecting SQL Server via an ODBC DSN setting. Clear explanations and tutorial exercises are provided on creating new DSN with the SQL Server ODBC driver; starting SQL Server Browser Service; enabling TCP/IP protocol on SQL Server; verifying TCP/IP port numbers; testing ODBC DSN settings with MS Access.

Type: Database  #Views: 3043  Category: Article    

Using Navicat (MySQL client) SSH Tunneling for secure MySQL Server management
Many of the web hosting companies has blocked port 3306 to prevent access from outside, to defend against from security threats. As a consequence, users are required to use web-based client to access their MySQL Server provided by the hosting companies. These web-based clients are usually not visually appealing with annoying page refreshes. However, with the increasing demand from users to connect from remote MySQL clients, some web hosting companies provides SSH Connection which allows user to login remotely across the Internet and support connection through the software based clients. SSH stands for Secure Shell and is a communication protocol for connecting to remote computers over TCP/IP. Encryption provides confidentiality and data integrity, and SSH uses public-key cryptography to authenticate the remote computer and to allow the remote computer to authenticate the user if necessary. There are several benefits to using SSH: * Connect to a MySQL server from behind a firewall when the MySQL server port is blocked. * Automate the authentication of users, no passwords sent in plain text to prevent the stealing of passwords. * Offers Multiple strong authentication methods that prevent such security threats as spoofing identity. * Offers Encryption and compression of data for security and speed. * Secure the file transfer. Setting up a SSH Connection to your MySQL Server with Navicat To successfully establish a SSH connection, set the SSH connection properties in the corresponding boxes: Host name/IP address, Port number, User name, Authentication Method and Password. 1. Click or choose File -> New Connection to set up the Connection Properties. 2. Select the SSH tab and enable Use SSH Tunnel. 3. Fill in the required information in the SSH Tab: Host name/IP address A host where SSH server is activated. Port A port where SSH server is activated, by default it is 22. User name A user on Linux machine. (It is a Linux user. It is not the user of MySQL Server.) Authentication Method Choose Password Authentication Password The password of your user account in linux 4. In the General Settings Tab, the settings should be set relatively to the SSH server. For example, host_of_mysqldatabase shown below is the host address, which is provided by your hosting company of your remote MySQL database. Connection Name A friendly name to best describe your connection. Host name/IP address The host where MySQL Server is located in point of view SSH server. If SSH and MySQL Server are on the same machine, it is equal to SSH Host, or may be 'localhost'. Port The port of MySQL Server on Remote Host, by default it is 3306. User name The username of your MySQL Server. Password The password of your MySQL user. By clicking OK, the SSH connection is made. Hosting Companies providing SSH Connections Listed below are some hosting companies which provide SSH connections and remote MySQL Connection can be setup with Navicat. 1&1 1and1 Hosting 1Host Web Hosting 3FN.net A2 Hosting Advanced Network Hosts AN Host AN Hosting Aplus.net Apollo Hosting Argon Hosting Blue Host Bounceweb Cirtexhosting Crucial Paradigm Dotservant.com Dreamhost eChristian Web Hosting FastDomain Flux Services Hagen Hosting HostGator.com HostHead Hostican Hostland HostMonster.com Hostpapa HostRocket.com Imhosted InMotion Hosting Intermedia iTeraWeb Solutions IX Web Hosting Joyent Liquid Web Lunarpages.com ME Webhost Media Temple Naked Hosting Netfirms Net-Trend Omnis Hosting PowWeb Practical Webhost Server Pronto ServerPro Web Hosting SimpleHelix Start Logic Superbhosting.net Tbhost.com techhosting.com The Host Group ThinkHost UK2NET Velcom.com Verio Vision Web Hosting Web Hosting Buzz Web Hosting Pad WebWizards.net WestHost WireNine YourServing Your-Site.com In the following section, we have selected one of a popular hosting companies and show how a SSH Connection to the MySQL Database can be established with Navicat. Tutorial on how to establish SSH Connection to a MySQL database hosted in Dreamhost DreamHost provides shell access to all of its customers, but it needs to be specifically enabled for each user added to a customer's account. By default, the Type of the user is set to be “FTP”, you will need to enable the shell access before you can connect through SSH. Enabling the Shell access for an existing user: 1) In your Control Panel, Visit User > Manage Users. 2) Click the [ edit ] link located next to the user you'd like to enable shell access for. 3) Check the 'Enable ssh/telnet?' box for that user. 4) Leave the 'Type' as it is unless you need it to be something other than bash. 5) Click Save Keep in mind that it takes about 20 minutes for this change to take effect. After changing the user account to Shell Type, you’ll also need to grant rights for your local machine to connect to the database server, before you can connect remotely by Navicat. This must be done for all MySQL user accounts you plan on logging in from your local machine. Granting rights for your local machine: 1) Login to your Dreamhost Control Panel 2) Select the Manage MySQL link under the Goodies section. 3) Under the Database(s) on this server section, find the desired database and click the username you wish to grant access to. 4) Under the section titled Allowable Hosts, type in the domain or subdomain or your IP Address your local machine identifies itself as on the public internet. 5) Click Save You have completed the settings required in your Dreamhost account, now you will go to Navicat to create the Connection. In Navicat, click the Connection button to New a Connection. In the General Tab of the Connecting Setting box, Hostname/IP address: the hostname of your mysql server at dreamhost, you can check this at Control Panel > Goodies > Manage MySQL Port: 3306 (this is the default port number for the MySQL Server) Username: username with access right granted in Manage MySQL section Password: password In the SSH Tab of the Connecting Setting box, Hostname / IP Address: machine_name.dreamhost.com Port: 22 (this is the port for SSH connection) Username: username which you have changed the account to Shell type in Dreamhost Password: password To test if the Connection settings are correct, you may click the “Test Connection” button to check. Connecting to your MySQL Database from remote client Navicat offers you a greater flexibility on working with your data in MySQL. With Navicat, you can easily import your data in to your MySQL database from various file formats, build queries visually, set a schedule to perform backup, generate report from your raw data and more. For more information on how Navicat helps you to manage your MySQL database effectively, please visit here: http://mysql.navicat.com/details.html.

Type: Database  #Views: 4106  Category: Article    

Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

Type: Database  #Views: 1970  Category: Article    

MySQL - Reference Implementation of JdbcRowSet
This article provides tutorial notes on Sun's Reference Implementation of JdbcRowSet working with MySQL database. Topics include installing JdbcRowSet reference implementation; connecting JdbcRowSet objects to database server with connection URL, DataSource name, ResultSet objects or Connection objects; query parameters; inserting rows.

Type: Database  #Views: 1028  Category: Article    

SQL Server FAQs - Transact-SQL Managing Character Strings and Binary Strings
A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character strings; converting binary strings; inserting new line characters; locating and taking substrings; bitwise operations.

Type: Database  #Views: 1195  Category: Article    

MySQL - Sending Non-ASCII Text to MySQL
This article provides tutorial notes on sending non-ASCII text data to MySQL. Topics include sending non-ASCII text data in SQL statements; changing MySQL character set settings to send Latin1, UTF-8, BGK, and Big5 characters

Type: Database  #Views: 2551  Category: Article    

Managing content in an employee workplace, Part 5: Create an authoring process using portlets and IB
In this fifth article in the series about managing content in an employee workplace, the author describes how the team designed and implemented a sample Web portal application to support the authoring tasks for the document management scenario called Analyst research reporting. The scenario is about employees collaborating to author, review, and publish research reports accessible to every employee in the company.

Type: Database  #Views: 2733  Category: Article    

Using Database Engines in a Mobile Application
Learn how to use databases on mobile devices.

Type: Database  #Views: 1666  Category: Article    

The Elements of a Database
What elements comprise a database? This article deals mainly with the objects that comprise a database. Several concepts are worthy of coverage within the scope of the database as it relates to database design. As you work with data and databases, you will see how the origination of business information and databases is formulated into database elements. The intent here is to provide a brief coverage of basic database elements to provide you with a basic understanding of the elements found in a database.

Type: Database  #Views: 1989  Category: Article    

Death, Taxes, and Relational Databases, Part 1
Showcases the XML functionality of SQL Server 2000 by turning SQL Server into an object repository using XML as the bridge between relational and object-oriented data.

Type: Database  #Views: 1542  Category: Article    

Relational databases get a grip on XML
Find out how well IBM DB2, Microsoft SQL Server 2000, Oracle Database 10g, and Sybase ASE handle the structured documents that drive today's business.

Type: Database  #Views: 1605  Category: Article    

How To Get Column Values from a SqlDataReader
Doug explains how to get data out of the SqlDataReader. He explains how to get the column data including GetString(), GetDateTime(), GetValue(), etc.

Type: Database  #Views: 1800  Category: Article    

Prev Next
1 2


Advertise on XMLPitstop


4,686 Total Members
12 members(last 30 days)
0 members(last 7 days)
0 members(today)

2,002 Total Discussions
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

47,487 Total Blog Posts
0 Blogs(last 30 days)
0 Blogs(last 7 days)
0 Blogs(today)

8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

14,413 Total Resources
3 Resources(last 30 days)
0 Resources(last 7 days)
0 Resources(today)


 

David Silverlight's XMLPitstop.com| 2801 Florida Ave #225|Miami, FL 33133|Ph:305-447-1139