[ricwash]

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.

Thanks,
Ric

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 :-)

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,
AUGSOFT