ODBC Database connection in Frontier
You've got a SQL server somewhere, from Oracle, Microsoft, Sybase or other ODBC-compliant database vendors. It's got data in it. Very useful data. Do you think Frontier might be interested in it?
[ Previous - Next ]
Well, this tutorial will help you get Frontier to talk to that SQL server. In fact, it may even make you ditch MS Query once you're done reading.
This tutorial assumes average working knowledge of Frontier. If you know how to navigate the ODB and how to run scripts, you're good to go. Of course, you should also know some SQL, and prior knowledge of how to connect another application (such as Excel) to your SQL server is very useful.
Once you read through this tutorial, you will be able, in Frontier, to:
- retrieve, update and delete data from your SQL server
- send any SQL command, including stored procedures
- easily query your SQL server through the built-in Frontier odbc query tool
- save, load and delete queries
Author: Henri Asseily
First Published: Tue, Mar 31, 1998 at 5:46:03 PM
Last Revision: Wed, May 6, 1998 at 2:57:00 PM
Keywords: ODBC, SQL, database
Level of Difficulty: Easy
Are you ready? Let's go to the First Page.
Page 1: Before the installation
Page 2: Installation of the ODBC extension to Frontier
Page 3: ODBC Functions
Page 4: ODBC Query Tool
Page 5: Old DLL Versions
Page 6: Known Bugs and Limitations
This tutorial was written by Henri Asseily in Los Angeles, USA.
Page last revised 3/31/98; 6:37:28 PM.
Copyright © 1998 ScriptMeridian. All rights reserved
All trademarks are the property of their respective owners.
2:57:16 PM Wednesday, May 6, 1998