 |
ODBC 4 ALL is a 32 bit Windows utility designed to easily allow any application, including DOS, to run SQL queries using any ODBC data source, (Access, Informix, MySql, Oracle, Sql Server, ...), redirecting the output to the screen, an ascii file / table or a DBF table.
When run in interactive mode, you can interactively choose the ODBC Data Source and Table, then insert the SQL command to send to the database server to see the resulting data on a screen grid.
To use it inside a 3rd party application, you can create an ascii configuration file, then run ODBC4ALL.EXE to obtain the results of the SQL query into the desired output format.
In this case user intervention is not required. Even the error messages could be redirected to an ascii file (for example if the SQL query contains a syntax error, or if the database server is unreachable because the server PC is down) allowing the running application to check for errors before managing the results.
Ascii tables are particularly useful to obtain data views which are automatically printable using our Printfil - Windows Printing System for Applications software: http://www.guolo.com/printfil
The two modes can be mixed, allowing you to run it in interactive mode obtaining an ascii output file or to run it from within your application only to automatically show the results of the query to the user.
odbc dos database dsn dbf db3 clipper access excel informix oracle mysql server network easy connection odbc data sources application dos too
|
|
|
 |
Create ODBC Data Source Names (DSNs) on the fly with the simple click of a button
saving your company both time and money! Imagine having to spend 3 minutes per PC to setup
a DSN. Now imagine having to setup 100 PCs - that's 5 hours spent creating DSN files!!! At
$25 per hour that's $125!!! So you can see how DSN Now can easily pay for itself the first
day it's used! With DSN Now you can drastically reduce the amount of time it takes to create
DSNs. DSN Now creates DSNs in the amount of time it takes to click a button! DSN Now creates
both user and system DSNs and the drivers supported are dBase, MS Access, SQL Server and
Adaptive Server Anywhere 6.0.
dsn odbc database utility automatically create dsns odbc databases
|
|
|
 |
SQLIdl is a Universal Web based Command Line Database (SQL) Tool for Application Developers
Features:
- Execute SQL Commands (DML/DDL)
- Invoke from Windows Start-->Run (command line)
- Connect any database by changing the connection string at run time. Tested databases are:
- Oracle
- SQL Server
- Preconfigure settings, so that you need not bother about typing in everytime:
- Connection string (Database, username, password)
- Frequently used SQLs
- SQLs for retrieving table/view/trigger/stored procedure definitions
- DML commands like Insert/Update need a password for preventing tampering
of database opened up using this utility. This Password is configurable (default: mypwd)
- Generation of Insert/Update command based on query results.
Retrieve from Oracle and insert/update into SQL Server or vice-versa
as it is or after typing in changes visually!!!
- Multiline data can be retrieved, changed and updated back
- Works fine with CLOB/LONG types
- Use multiple statements separated by semicolon!!! For ex: select * from dept;select * from emp
Requires .Net Framework (I use v1.1), MDAC 2.6, Internet Explorer (IE 5.5)
Installation and usage:
After installing to a IIS Virtual Folder, open Web.config from the Virtual folder and change the key conStr_def to point to your database. Please change other values if necessary.
open IE and type in as follows:
http://localhost/SQLIdl/SQLIdl.aspx
You would need to provide the correct virtual folder if you changed it during installation. Type in your SQL query and enjoy!!!
To install the command line utility, simply copy the two files SQL.exe and SQLIdl.ini to your workstation windows system32 folder, open SQLIdl.ini in notepad and provide the correct path to IIS.
Now just invoke run from Start Menu, type in your query as follows :
sql "select * from dept"
It is THAT simple!!!
If you like SQLIdl, please buy ($10 only).
database ole db universal utilities system file dsn tools windows win small fast thin quick command line utility tool oracle sql server db2 odbc web
|
 |
The component provides you complete DSN management. Access to the component can also be turned on at website basis like all other ASPFusion components. The component is very easy to use and is more flexible for DSN management. With few lines of code, DSN can be easily managed. It provides these operations.
Complete basic DSN management operations, such as Add, Configure and Remove a DSN.
asp fusion aspfusion asp fusion components advdsn
|
 |
Ever needed to create a Microsoft Access Datasource Name (DSN) on the fly from inside your Delphi code? We certainly have! This incredibly useful little Delphi component allows you to create, modify and delete DSNs at runtime from a Delphi application (32 bit only).
Now supports Delphi 4, 5 and 6
Why would you want to do this? Quite often we (as developers at GWAcc) find ourselves having to climb into the control panel and muck around inside the ODBC32 applet. It gets annoying, especially if you have to do it several times in a row, even more so when it means having to switch between changing user names, passwords, paths, exclusivity... you get the idea!
dsn datasource name microsoft access control delphi
|
 |
Manage info on your website in a linked checklist web, with a browser, mobile phone or Pocket PC. Ideal for all checklist types: task, to do, shopping, meeting notes, travel, packing, bookmark, wish, wedding registry, recipe, direction etc. Perfect for teams, clubs, groups, associations and families to share and organize info. Publish with professional presentation on the web those checklists you want to share. Preview and interactively format your checklists to create custom emails print hardcopies that you can send to friends and contacts. Quickly and easily setup your OmniChex accounts by browsing, importing and customizing templates. Customize the look of OmniChex Web with your colors and linked logo icon for seamless integration into your website. Don't blog, keep your info on your website dynamic and organized, and manage it with OmniChex! OmniChex enables you to manage your information in multiple account(s), each with a hyperlinked checklist web. Access OmniChex online securely from your web browser, or on the go using your mobile phone. Also access OmniChex accounts offline with your Pocket PC powered device, and sync later with your website. Increase the value of your hosted, personal or corporate website with interactive OmniChex products. Linux, UNIX and Windows website installations supported. IIS and Apache web servers supported. Installs on websites with Perl/CGI-BIN or ASP support, and MySQL, CSV, or Windows DSN / DSN-Less databases. OmniChex Manager Windows application bundles the OmniChex product suite, and provides easy install. Manager enables deployment to either local or remote website using FTP. Request evaluation and license keys using OmniChex Manager. OmniChex Web works on Internet Explorer version 5 or above. OmniChex Pocket PC installs on Pocket PC powered mobile devices including PDA's and smart phones. OmniChex Mobile Phone works on any phone with WAP / WML 1.1 support.
perl asp checklist list hyperlink web wireless isp database hosted todo to do task shopping travel packing action meeting wap wml mobile bookmark favorites personal information management pim
|
 |
Database Gate is SQL editor able to connect to every kind of database using ODBC.
You can write and execute queries, create, alter or drop tables, execute stored procedures, get information about all the objects in the database, the columns list/primary or foreign keys/indexes of a table with the Object and Table browser, export/import data, also in HTML, with or without transaction.
Database Gate allows you to connect to different kind of database at the same time and helps you in editing, there are useful shortcuts to minimize the writing of standard SQL statements and formatting text tools.
You have also custom shortcuts by using the macro keys. The Syntax Highlighting, Words and Context Completation helps you in writing your SQL statements. With the batch language you can do in automatic way particular tasks. With the Finder function you can look for objects in the database using many different criteria.
Database Gate needs only ODBC 32 bit support installed in the system.
sql editor odbc database table syntax highlighting client server dsn sql editor able connect every kind database using odbc tools
|
|
|
