Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Enthusiast Zone > Classic Macs and Mac OS > ODBC

Thread Tools
Fresh-Faced Recruit
Join Date: Oct 2000
Location: Hanover, NH, USA
Status: Offline
Reply With Quote
Oct 11, 2000, 12:18 PM
Can anyone help with setting up ODBC access. I have FMP 5 and Excel and I would love to access Oracle data. I have an Oracle account for the data, I have sql*net, I have the ODBC drivers installed.

I have gotten sql*net to work, but I really want to access the data from FMP and Excel.

Reply With Quote
Oct 12, 2000, 11:47 AM
1) open sql*net, and login. If you can't login more than likely you have an older version of the oracle drivers, get your oracle dba to get you updated one. once this works go to 2
2) in the ODBC PPC setup, click on User DSN tab, click on add and choose oracle, and log in and fill in the blanks
3) click on File DSN tab and click add and follow the instructions.
4) open excel, choose create new query, choose the file DSN you just created and select your tables.
have fun :-)
Reply With Quote
Oct 20, 2000, 06:46 AM
Also, be sure to check-out our Macintosh ODBC ROUTER at http://odbc.net/ which is designed specifically for Excel, FMPro and many other ODBC-aware apps (4D, REALbasic, OMNIS, etc...)

ODBC ROUTER enables all of your Macs (68K, PPC G4, etc..) to access virtually every version of every database system, by way of any ole' Windows NT/2000 box in your network. (No dedicated machine needed, just a stock Windows ODBC driver for the different kinds of databases you want to use from the Mac, MS-Access, SQLServer 2000, ORACLE 12, Vax Rdb, IMS-COBOL, whatever...) We still support old 68K versions of Office as well as exploit the PowerPC in Office98 and Office2001.

ODBC ROUTER is a one-time network-wide solution that future-proofs your networks of desktop computers from upgrades and changes to database software and their client packages, such as SQL*NET. Pricing is between US$399 and US$2319, with major discounts for US non-profit organizations. The cost savings in adding ODBC ROUTER to your network over trying to acquire and maintain ODBC drivers for all of your desktops and laptops is pretty incredible. We also support PC clients (in addition to Macs) for just this reason.

ODBC ROUTER can also be combined with 4D's WebStar web server to protect your general purpose operating systems (WinNT/2K, LINUX, OS/400, Solaris, etc..) from unknown forms of hacker attacks. We do this using AppleTalk and it is really cool.

Finally, ODBC ROUTER can be used (over a VPN) to make some normal stored-procedures available to other companies/partners (rather than trying to convert your business processes in and out of HTML/XML .

Best Regards,
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Privacy Policy
All times are GMT -4. The time now is 09:39 PM.
All contents of these forums © 1995-2015 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2015, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2