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,

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.

Oh No I remember that product. Can we help you talk someone into a much needed upgrade?

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

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.

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

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