Free jdbc driver for sql server 2005 software for linux

RIPE Whois Server provides support for domain records and lookups.

This is a whois database server. The RIPE Whois server uses a backend SQL database to allow support for very large repositories. There is support for IPv6 records and lookups. Both RPSL and RIPE181 are supported.

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. DBDesigner is a visual database design system that integrates entity relationship design and database creation.

The project generates SQL scripts for Oracle, SQL Server, MySQL, and FireBird.

libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl.
Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework.
The libdbi-drivers project provides the database-specific drivers for the libdbi framework. The drivers officially supported by libdbi are:
- Firebird/Interbase
- FreeTDS (provides access to MS SQL Server and Sybase)
- MySQL
- PostgreSQL
- SQLite/SQLite3
The following drivers are in various stages of completion and are supposed to be included into the next release:
- mSQL
- Oracle
Enhancements:
- This release fixes a packaging error in 0.8.2. There are no source code changes.

DBIx::Version is a Perl extension for getting database software name and version.

SYNOPSIS

use DBIx::Version;

my $dbh = DBI->connect( ... );
my ($dbname, $dbver, $dbverfull) = DBIx::Version::Version($dbh);

DBIx::Version lets you query which database software and version you are connected to.

Return Examples:

(undef, undef, undef)
(mysql, 4.0.17, 4.0.17-standard-log)
(postgresql, 7.4.1, PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 20031107 (Red Hat Linux 3.3.2-2))
(oracle, 8.1.7.0.0, 8.1.7.0.0)
(sqlserver, 8.00.384, Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2))
(sybase,12.5.0.1,Adaptive Server Enterprise/12.5.0.1/SWR 9982 IR/P/Sun_svr4/OS 5.8/rel12501/1776/ 64-bit/FBO/Tue Feb 26 01:22:10 2002)
(sybase,12.5.0.2,Adaptive Server Enterprise/12.5.0.2/EBF 14000 IR/P/Sun_svr4/OS 5.8/rel12502/1776/64-bit/FBO/Tue Jun 4 01:22:10 2002)

Answer 1: This module is useful for cross-platform coding, and in environments like shared hosting where you actually didnt install the database yourself and are curious.

EasyEclipse Server Java is for development of server-side Java applications, such as JavaServer Pages, EJBs and Web Services.
EasyEclipse Server Edition contains lots of plugins to manage different application servers (Tomcat, JBoss, WebLogic), develop on some server-side frameworks (Struts, Java Server Faces), and manipulate common file types on servers (HTML, XML, JSPs).
This distribution includes the following plugins:
Core components with a JDK:
- Eclipse Platform 3.2.1 - Shared platform services from Eclipse.
- Eclipse Tools 3.2.1 - Common libraries for various Eclipse projects.
- Java JDK for Windows 1.5.0.09 - Run Java application on Sun Java(tm) runtime, packaged for Eclipse use. (Windows only)
- Java JDK for Linux 1.5.0.09 - Run Java application on Sun Java(tm) runtime, packaged for Eclipse use. (Linux only)
Tools for general Java development:
- Eclipse Java Development Tools 3.2.1 - Edit, compile, run, debug, test, refactor, document and deploy Java applications.
Some essential utilities:
- AnyEdit Tools 1.5.6.2 - Useful right-click menus in editors: "Open file under cursor", "Open type under cursor", et cetera.
- Eclipse Utils Plugins 1.0.0.1 - Save the cursor position of editors when closing and re-opening a file. Access common team actions with explorer buttons.
- Color Editor 1.2.4 - Edit with syntax highlighting over 100+ file formats.
Tools for development of server-side applications in Java:
- Sysdeo Tomcat Launcher 3.2.0.beta - Start, stop, and manage Tomcat and WAR files without leaving Eclipse.
- JBoss IDE with AOP and EJB3 2.0.0.Beta2 - Develop, deploy, test and debug JBoss-based applications, with support of Enterprise Java Beans 3.0 and Aspect-Oriented Programming.
- Hibernate Tools 3.2.0.beta8 - Edit Hibernate mappings, execute HQL queries and develop applications with Hibernate, a Java persistence and object-relational mapping framework.
- Weblogic Server Plugin for Eclipse 2.0.0.RC3-1 - Start, stop and manage a WebLogic server. Run and debug applications on a Weblogic server.
- Spring IDE 1.3.6 - Develop, manage and deploy Spring Framework based applications.
- Eclipse J2EE tools 1.5.2 - Create and deploy J2EE based applications, including Servlets, JSP and EJB.
- Eclipse Database tools 1.5.2 - Access, manage and query SQL relational databases and servers.
- Amateras IDE 2.0.2 - Edit HTML, XML and JSP. Manage Struts and Java Server Faces configuration files visually.
Tools for web development:
- Eclipse Web tools editors 1.5.2 - Edit and validate XML, XSL, XML Schemas, DTD, HTML, JavaScript and CSS files. Test and validate web services.
- Eclipse HTML Tidy 1.2.2.patch-01-1 - Format and validate HTML, XHTML and XML documents within your favorite editor.
- Amateras HTML and XML editor 2.0.2 - Edit HTML, JSP, XML and CSS files.
Database management tool:
- QuantumDB 3.0.3 - Access, manage and query SQL relational database and servers access using standard JDBC drivers.
Version Control tools (note that CVS support is included in the Eclipse Platform):
- Subclipse 1.1.8 - Access and manage Subversion repositories within Eclipse.

Boston University Linux is based on Fedora Core Linux, but specifically tailored for the BU environment.

Weve added security updates, made modifications to make software work better with the way things are set up here, and added some applications that we think you might like to have.

The server edition of BU Linux provides a modern, stable, and robust server platform suitable for long-term deployment in many roles throughout the university.

Supported Hardware

Currently, only i686-class machines are supported. This includes almost everything from Intels Pentium Pro on. AMD64 and Intel EM64T systems will work fine using their 32-bit mode. Watch for a 64-bit version later this summer.

Specific Notes on Server Applications

Mail Server:

BU Linux 4.5 Server Edition (Zodiac) includes three different choices of Mail Transfer Agent (MTA) for your mail server. Each of these open source servers has its unique strengths, and you can install one or more and use the utility system-switch-mail to choose which is active.

The default is IBMs Postfix, which is designed from scratch to be secure and easily configurable. On a newly-installed BU Linux machine, Postfix is configured to exchange mail on the local machine and to send mail out to other systems, but not receive mail from the network. For this reason, outgoing mail from global BU accounts (those matching valid BU login names and with the proper UID) will appear to come from @bu.edu rather than @hostname.bu.edu. Local users (including system accounts) will retain the hostname, but without reconfiguration, any replies will bounce. Changing the system to accept mail is easy; see the BU Linux web site for details.

For the maximum flexibility and for compatibility with existing configurations (and with existing expertise), we also include the traditional standard Sendmail. And, if you have particular special needs, you may find that the new Exim MTA fits your situation best.

No matter which MTA you choose, please contact us if you need any assistance. With so many options available, the situation can be confusing, and its unfortunately easy for an accidentally misconfigured system to become a target for spam relayers. We have significant expertise at configuring both Postfix and Sendmail in a variety of situations, and will be glad to help.

FTP Server:

This release of BU Linux provides two options for FTP. The first is vsftpd, which is designed to be simple and secure. This is the most appropriate for almost all situations, but if you require more power and flexibility, we also include ProFTPd, which has many more options and a configuration syntax similar to that of the Apache web server.

Please also remember that FTP is an insecure protocol and that any passwords used travel over the network in plain text. For this reason, its best to avoid anything but anonymous FTP. For user-authenticated file transfer, use SSH and SFTP. (SFTP is provided by the OpenSSH server and enabled by default.)

Web Server:

The web server software included in BU Linux is the industry-standard Apache httpd. We also include PHP 4.3 and many other useful tools for building a web server.
If you need to provide authenticated access to web services to BU users, please contact us and we will provide you with our University-standard Weblogin module. This provides a powerful and flexible means of single-signon access control for the BU user community and we want to make it as easy as possible for you to provide this for your users.

Database Server:

BU Linux includes MySQL 4.1 and PostgreSQL 7.4. For less demanding SQL applications, we also provide SQLite 3, which provides simple SQL databases without the management overhead of running a SQL server.

Since MySQL is the most popular SQL server that is used in conjunction with web sites, there was a need for incremental backup utility. ZZEE Active SQL Backup is designed for clients of web hosting companies, and can be useful to system administrators as well.
Main features:
- Can perform *incremental* backup of MySQL database
- Can perform full backup of MySQL database
- Can replicate database
- Can process SQL queries
- Can dump database structure
- Can suggest database changes needed to process incremental backup
- Can send data backed up by email
- Can transfer backed up data by FTP to other computer (if Net::FTP is installed)
- Can compress backed up data
Usage synopsis
Active SQL Backup can do incremental or full backups of MySQL database as often as needed. It is suitable both for the clients of web hosting companies who can not get access to MySQL update logs and for the host administrators. Backup syntax is:
shell> ./zmdb.pl -b
It stores backup files in BACKUP_DIR, specified in user_settings.txt, named like YYYY_MM_DD_hh_mm_ss.sql[.gz]. The backup files consist of series of SQL INSERT statements and may contain DELETE statements. The database scheme is stored in file database_name.create.sql. If gzip is available, then Active SQL Backup automatically uses it to compress stored data. The program can automatically send backed up files by email or upload to the other computer by FTP.
If the system fails, Active SQL Backup can restore the database. Restore syntax for incremental backups is:
shell> ./zmdb.pl -r
If you make full backups, restore syntax is the following:
shell> ./zmdb.pl -e < BACKUP_DIR/database_name.create.sql
shell> ./zmdb.pl -e < BACKUP_DIR/YYYY_MM_DD_hh_mm_ss.sql &
The first line is needed to restore database structure, and the second is the *most recent* data file. You may need to "gunzip" it before supplying to restore.
You can use the program to dump database structure
shell> ./zmdb.pl -s > structure_dump_file
or to process queries. The latter feature is useful if you need to process queries regularly, for example, to update membership status of the users of your online service. The syntax to execute SQL queries is:
shell> ./zmdb.pl -e < some_sql_file
Where format of some_sql_file is the same as with Mysql utility: SQL statements are separated by semicolon. Note that if you pass SELECT queries to Active SQL Backup, then no result will be returned.
Syntax summary is:
zmdb.pl [SINGLE_OPTION]
-a --advice suggest database modifications and tables_config.txt
-b --backup backup database structure and data
-e --execute execute SQL queries [from STDIN]
-h --help print this screen
-r --restore restore database structure and data
-s --structure dump database structure [to STDOUT]