frondoc picture

What is Frontier?
Download
News & Updates

Web Tutorial
Scripting Tutorial
BBEdit Scripting
Directory

Mailing Lists
Sample Scripts
Verb Set
Frontier Site Outline

Search
Guestbook
BBS

User's Guide
1 2 3 4 5 6
7 8 9 10 11

Apple File Edit
Main Open Suites
Web Window

Menubar Outline
Script Table WP

frondoc picture

Preston Holmes on the ODBC UCMD

One thing the Mac has never been a real star at is large database connectivity.

No More!

Thanks to Stephen Tallent we now have a UCMD connect to most large databases (Oracle, MS SQL, Sybase, etc) to Frontier.

http://www.tallent.com/root/system/extensions/odbc.html

Some highlights:

The extension takes care of managing differences between 68K and PPC datasources.

The extension keeps connections to the DBMS open for blazing performance.

You can have multiple connections to different databases open at the same time.

Data can be returned in three different formats: lists, tables, or text.

This has been found to be very robust and stable on several test machines but is still beta until it gets some burn in from more environments. There are still some problems with the Butler 68K driver that are being worked out but has been stable with all other drivers tested.

If you don't have the runtime ODBC components you can get them from the SDK:

ftp://ftpdev.info.apple.com//Developer_Services/Development_Kits/MacODBC/

For a real quick intro to SQL check out:

http://w3.one.net/~jhoffman/sqltut.htm

Preston Holmes, pholmes@ucsd.edu
Stephen Tallent, stephen@tallent.com


© Copyright 1996-97 UserLand Software. This page was last built on 5/7/97; 1:52:05 PM. It was originally posted on 3/27/97; 9:18:15 PM. Internet service provided by Conxion.