Re: Windows and Oracle access.

In article <dtb.726316321_at_otto> dtb_at_otto (David Bath) writes:
>jessea_at_u013.me.vp.com (Jesse W. Asher) writes:
>
>>I remember a recent thread on accessing Oracle from MS Windows, but I
>>didn't pay any attention to it at the time. Can someone bring me up to
>>date on the thread? Is there a way to access Oracle from MS Windows?
>>Is there some sort of orasrv (SQL*NET) available for Windows?? Thanks.
>
>I have used and seen USERS use Q&E to access Oracle. Q&E (without Oracle

                                                         ^^^^^^^^^^^^^^

Au contraire' The Q+E distributed with Excel (late 3.0, 4.0 and 4.0a) ALL support ORACLE access. The "full" version from Pioneer Software is much better, though.

>
>The nice thing is it does NOT attempt to fiddle with the SQL, just
>hands it over to Oracle (cf MS-Access)
>
>David T. Bath Email:dtb_at_otto.bf.rmit.oz.au Phone:03-3477511
>Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
>"Failure to emulate is the best revenge" - Marcus Aurelius
>--
>David T. Bath Email:dtb_at_otto.bf.rmit.oz.au Phone:03-3477511
>Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
>"Failure to emulate is the best revenge" - Marcus Aurelius

I have a couple of major applications using Excel as a "front-end" to ORACLE databases residing on UNIX servers. We have SQL*Net for TCP (DOS version) installed on the PC and use Q+E (currently the version supplied with Excel) as the intermediary. An important key is to start up sqltcp in your winstart.bat file so it is in Windows-managed memory space.

Works like a champ.

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm_at_ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!