Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Focus Six for Windows - Oracle interface
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Focus Six for Windows - Oracle interface
 Login/Join
 
Member
posted
Hi,
I would like to know how to connect to Oracle database
using the same technique as MSSQL06 for MS SQL.
Regards
JF

This message has been edited. Last edited by: Kerry,


Focus Six
Windows XP
 
Posts: 3 | Location: France | Registered: November 13, 2008Reply With QuoteReport This Post
<JG>
posted
You have to be joking.

But if you are serious then for Focus Six you need a 16 bit Oracle client
Probably 7.something that almost certainly will not run on XP.

I do not think that Focus Six was officially supported on that platform either
Because it’s 32bit

I very much doubt that you’ll manage to find the client you need nowadays and it’s going to be
Very specific as to which versions of Oracle it can access.

Focus Six was de-supported at the end of the last century.
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Oh No I remember that product. Can we help you talk someone into a much needed upgrade? Wink
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
That's no joke and your response is no use to me.
( even if it make me painfully smile ! )
It works fine with MS-SQL and this junk library :

03/04/1996 00:00 23ÿ920 DBMSRPC3.DLL
03/04/1996 00:00 10ÿ576 DBMSSOC3.DLL
03/04/1996 00:00 21ÿ744 DBMSSPX3.DLL
03/04/1996 00:00 18ÿ620 DBMSVIN3.DLL
03/04/1996 00:00 10ÿ893 DBNMP3.DLL
15/03/1996 00:00 163ÿ625 HELP.HLP
25/03/1996 00:00 1ÿ119ÿ215 HELPSQL.HLP
07/11/1995 00:00 561ÿ408 INFOVIEW.EXE
03/04/1996 00:00 55ÿ792 ISQLW.EXE
27/03/1996 00:00 83ÿ883 ISQLW.HLP
03/04/1996 00:00 210ÿ880 MSDBLIB3.DLL
12/07/1995 00:00 30ÿ016 NWIPXSPX.DLL
12/07/1995 00:00 106ÿ047 NWNETAPI.DLL
12/07/1995 00:00 14ÿ848 READPIPW.EXE
12/07/1995 00:00 4ÿ608 RPC16C1.DLL
12/07/1995 00:00 10ÿ240 RPC16C3.DLL
12/07/1995 00:00 11ÿ776 RPC16C4.DLL
12/07/1995 00:00 9ÿ728 RPC16C5.DLL
12/07/1995 00:00 9ÿ728 RPC16C6.DLL
12/07/1995 00:00 5ÿ632 RPC16DG3.DLL
12/07/1995 00:00 7ÿ168 RPC16DG6.DLL
12/07/1995 00:00 24ÿ064 RPCNS1.DLL
12/07/1995 00:00 159ÿ744 RPCRT1.DLL
12/07/1995 00:00 21ÿ504 SECURITY.DLL
31/03/1996 00:00 766 SQLBOOKS.ICO
03/04/1996 00:00 385ÿ232 SQLGUI.DLL
03/04/1996 00:00 86ÿ496 SQLQRY.DLL
03/04/1996 00:00 43ÿ584 SQLSVC.DLL
03/04/1996 00:00 323ÿ344 SQLTOOLS.DLL
03/04/1996 00:00 210ÿ080 W3DBLIB.DLL

and all I just want is to get the Oracle equivalent...

JF


Focus Six
Windows XP
 
Posts: 3 | Location: France | Registered: November 13, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
What version of Oracle is it ?

My suggestion is to go look at Oracle sites, and see if there is a driver/client for your version.

If its new, I don't like your chances.

If you find a solution, please let us know.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6278 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
It's Oracle version 10.
If by chance I find a solution I'll let you know ( a few days more and I give up ! )
jf


Focus Six
Windows XP
 
Posts: 3 | Location: France | Registered: November 13, 2008Reply With QuoteReport This Post
<JG>
posted
I'm afraid that you are totally out of luck.

For FOCUS Six you need a 16 bit Oracle client which means going back to a 7.3 version of Oracle.

A 7.3 client can not talk to a Oracle 10 DB. Minimum usable client would be 8.2 which is not available as 16 bit

The 7.3 client does not work on XP.

One possible solution is available.

That is to install the Oracle transparent gateway on the MSSQL server machine and create a DBLINK
in MSSQl to the required Oracle tables.

You can then use your existing MSSQL connection. Be warned performace sucks.

This message has been edited. Last edited by: <JG>,
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Focus Six for Windows - Oracle interface

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.