|
|
| $33.00 Immediate Delivery |
 |
| 1.13 MB |
 |
|
Publisher's description of SQL Tester
|
|
|
SQL Tester The SQL Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the screen in an ad hoc basis from almost all kinds of databases. The output can be placed in worksheets and added to workbooks VBA-projects.
SQL Tester also allows you to:
Copy the displayed data into a worksheet including connection-string and query-string
Create dynamic queries where the data can be updated on a regular basis.
Insert a complete VBA-procedure which is based on the query and the database-connection.
Easily create queries by selecting keywords, names of tables and columns from user-friendly forms.
Create, test and export the queries to the clipboard or to textfiles.
Import queries from textfiles and have them executed.
Work with disconnected records.
Get more accurate and higher quality of the retrieved data compared to MS Query.
An extensive helpfile is available.
The best part is that You are not bound to the databases tools & windows!
SQL Tester has successfully been tested with the following databases::
Textfiles
Dbase version and version VI
Domino / Lotus Notes databases 5.x (Require NotesSQL ODBC Driver)
Ingres (All versions)
vMicrosoft Access version 97, 2000, 2002 and 2003 (extensively)
Microsoft Excel version 97, 2000, 2002 and 2003 (extensively)
Microsoft SQL 6.5, 7.0 and Server 2000 SP-3 (extensively) Microsoft Visual FoxPro Database
Mimer SQL 9 (Windows version)
MySQL version 3.23.57 and 4.0.14 (For best performance use 4.0 or above.)
MaxDB
Oracle version 8i and 9i (Oracle?s OLE DB Provider highly recommended)
Pervasive .SQL V8
SQL Anywhere Studio Base
SQLBase 8.5
SQL Tester has not been tested with the following databases from IBM but it is possible to retrieve data from them by using the appropiated providers.
IBM have developed their own add-in for MS Excel, IBM Office Connect, but this is only avaliable via the Toolbox subscription and the subscription cost 10 times more then SQL Tester!
Following articles about using ADO with the DB2 OLE DB Provider are recommended to take part of:
DB 7.2 and Visual Basic 6.0 - Bound and Unbound Forms
Getting Started with DB2 V8 and ADO using Visual Basic 6
DB2 Development Add-Ins for Visual Studio 6.0 - The Next-Generation AD Tooling
Following providers should be used:
For DB2 it is recommended to use the IBM OLE DB Provider for DB2.For Informix use the OLE DB Provider for Informix or the ODBC-driver Informix.
If You are running AS/400 DB2 you may use the Microsoft OLE DB Provider for AS/400 and VSAM. The provider is bundled with the Microsoft Host Integration Server client software. Please visit the site for Host Integration Server for more details.
|
| $33.00 |
1.13 MB |
 |
 |
|
| Downloads: |
463 |
Last update: |
Aug 26, 2005 |
| Size: |
1.13 MB |
Operating System: |
Windows... |
| Price: |
$33.00 |
License: |
Shareware |
| You may also be interested in: |
|
ISDN & Mail for business using....
Award-winning Excel spreadsheet is a simple alternative to accounting software for a small business to track income and expenses. Easier for you and tax preparer when tax time rolls around. Save time, money and tax time headaches. Requires MS Excel....
Arcade Park is a remix collection of the seven great golden oldest arcade games such as Arkanoid, Asteroids, Black Shark, Digger, Lode Runner, Pac-Man and Ping-Pong. ABC Puzzle is a remix collection of five puzzle and logic games such as Blocks, ......
Excel add-in for quoting stocks, options, mutual funds. Free real time quotes, historical data, alerts. Ideal to watch & research stocks, options & mutual funds your way. Uses simple & familiar =functions(). Works with all internet connections. ......
Simple Spreadsheet 1.2 Simple Spreadsheet is an easy to use, bare-bones spreadsheet creator and editor...
|
|
| More to Try |
Recovery Toolbox for Excel is a powerful tool which can recover damaged Microsoft Excel files...
Noto Personal Organizer is a mini application or 'window gadget' that you can move around your...
PackPal Barcode Generator can make professional ready-to-print barcode graphics easily and quickly.
A-PDF Merger, a professional PDP merging program, could help you to combine images or multiple...
transfer PowerPoint into Video(MPEG-1, MPEG-2), and burn to DVD/MiniDVD disc.
Copy DVD, Convert video, rip DVD to all sorts of video formats and Convert videos to DVD, burn...
|
|
