| |   Skin:   
      User: Not logged in 
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Featured Articles
Book Chapters
Training Courses
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
About Me
My Blog
HeadGeek Articles
Talking Portfolio
World Trip Pics

Prev Next
1 2 3 4 5 6 7 8 9
Metal Roofing Prices
Corrugated Metal Roofing, Residential Metal Roofing

Type: Database  #Views: 28  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: 30  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: 32  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: 1904  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 A2 Hosting Advanced Network Hosts AN Host AN Hosting Apollo Hosting Argon Hosting Blue Host Bounceweb Cirtexhosting Crucial Paradigm Dreamhost eChristian Web Hosting FastDomain Flux Services Hagen Hosting HostHead Hostican Hostland Hostpapa Imhosted InMotion Hosting Intermedia iTeraWeb Solutions IX Web Hosting Joyent Liquid Web ME Webhost Media Temple Naked Hosting Netfirms Net-Trend Omnis Hosting PowWeb Practical Webhost Server Pronto ServerPro Web Hosting SimpleHelix Start Logic The Host Group ThinkHost UK2NET Verio Vision Web Hosting Web Hosting Buzz Web Hosting Pad WestHost WireNine YourServing 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: 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:

Type: Database  #Views: 1635  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: 1551  Category: Article    

FAQ Management Software - Customer Support Software - Knowledge Base Software
Universal FAQ Manager is knowledge base software, customer support software, online support software, or technical support software. Specifically called FAQ Management Software, quality releases such as Universal FAQ Manager 2008 save businesses time and money while delivering higher levels of customer satisfaction. Worth it? Return on investments often are 1,000%. Any business today must get customer service right or will not be around tomorrow.

Type: Database  #Views: 890  Category: FAQ    

MySQL FAQs - Introduction to SQL Date and Time Handling
A collection of 15 FAQs on MySQL date and time handling. Clear answers are provided with tutorial exercises on date and time data types; formatting and converting date and times; incrementing dates and times; calculating date differences; understanding TIMESTAMP columns.

Type: Database  #Views: 2111  Category: Developer    

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: 730  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: 843  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: 2139  Category: Article    

SQL Server Tutorials - Getting Started with Transact-SQL Statements
A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

Type: Database  #Views: 2339  Category: Tutorial    

MySQL FAQs - Command-Line End User Interface mysql
A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats.

Type: Database  #Views: 1172  Category: TipsAndTricks    

PHP Script Tips - Working with MySQL Database
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

Type: Database  #Views: 2324  Category: Tutorial    

MySQL FAQs - Server Daemon mysqld Administration
A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.

Type: Database  #Views: 907  Category: Tutorial    

Background Screening and Security Issues
This new web-based software application can assist companies and businesses in retrieving all the information they need for a thorough background check on their employees. Reports are typically returned in less than 48 hours. The background checking service verifies such information as: Employment History Dates of employment and position held Job performance and reason for leaving Pay rate Residential Address History County Criminal Records County level Felony and misdemeanor criminal history Based on zip codes provided by applicant State and Federal Criminal Records Name check for criminal history at State and Federal level repositories County and Federal Civil Records County and Federal records check for lawsuit involvement Liens and Judgment History Workers Compensation Search Discovery of any workers compensation claims in a particular state Social Security Number Verification Validate SSN and applicant's legal name Credit Report Credit History report covering previous seven years DMV Record Verify valid driver's license Identify derogatory driving history (traffic tickets, accidents, DWIs) US Bankruptcy Search Federal index search for Chapter 7 and Chapter 13 bankruptcy filings Formal Education and Degree Verification Degree and date earned (or in progress) GPA. Contact to verify Military Record U.S. Military service records Rank and discharge status Professional License and Certification Verification Type of license, status, date of issue, expiration, and any noted disciplinary action Professional References Telephone interviews of references to verify applicant's work performance and character Drug Screening Applicant drug testing (outsourced to lab)

Type: Database  #Views: 1163  Category: Website    

Free Online Class - MapForce Database Essentials
The costs and complexities of data integration have been greatly reduced by using XML as a common data-exchange format. However, without the right tool and the knowledge to use it, data mapping between relational and hierarchical structures can be intimidating and time-consuming. This intermediate, instructor-led, online class provides an in-depth look at how to use Altova MapForce to visually create and execute data mappings between relational databases and XML. It provides an overview of the database support features available within MapForce, and explores the issues that arise in mapping relational structures to hierarchical XSD. Register for this FREE class today!

Type: Database  #Views: 2282  Category: Tutorial    

NEW! From the creators of XMLSpy - Altova DatabaseSpy
Altova DatabaseSpy 2007 is the unique multi-database data management, query, and design tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. Its straightforward Project Manager organizes connections and related files to make accessing your databases and their components effortless. You can even open connections to multiple databases at once. The Database Browser clearly presents your tables, views, and data in easily negotiable windows. The DatabaseSpy SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop construction, and more. And the powerful Database Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to duplicate existing structures in differing database types. DatabaseSpy supports Microsoft SQL Server 2000 and 2005, Microsoft Access 2003, Oracle 9i and 10g, IBM DB2 8.x and 9, MySQL 4.x and 5.x, and Sybase 11, as well as other ADO or ODBC databases. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and it imports data from CSV files. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. It is the one tool to finally liberate data management. Do data differently! Download Altova DatabaseSpy today, and try it free for 30 days.

Type: Database  #Views: 1693  Category: Tool    

Oxygen XML Editor
Oxygen offers support for importing database data, MS Excel files and text files into XML documents, that can be further converted into other formats using the Transform features. The user can examine the database contents and select the table to be exported using the database browser. It is possible to refine the data source by editing the generated SQL select statement in order to join multiple tables or to use advanced SQL expressions. Oxygen can generate an XML Schema from the database structure.

Type: Database  #Views: 1001  Category: Resource    

Relational and XML Integration
This tutorial covers accessing Relational Data as XML. The following topics are covered: Overview of Database to XML Data Sources, Creating a Database to XML Data Source, Specifying Connection Settings, Using an ODBC Data Source in Stylus Studio, Working with Scenarios, Composing SQL/XML in Stylus Studio, Working with Relational Data as XML, Using the URL Builder.

Type: Database  #Views: 2892  Category: Tutorial    

Prev Next
1 2 3 4 5 6 7 8 9

Fans of "The Office"
Dwight Bobbleheads are here!
  “It's me! I'm the bobblehead! Yes!”

Advertise on XMLPitstop

Advertise on XMLPitstop

EggHead Cafe
Web Servicee development
hp printer refills
single point of contact
fax server
conference call services
chicago web design
Alojamiento de Web
Cheap Web Hosting
PTZ IP Network Cameras
Fendi sunglasses
Video Surveillance
Skype vs. sipcall

4,027 Total Members
16 members(last 30 days)
9 members(last 7 days)
3 members(today)

1,948 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,120 Total Resources
8 Resources(last 30 days)
1 Resources(last 7 days)
1 Resources(today)


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