Re: Microsoft to Oracle SQL

From: Steve Jorgensen <nospam_at_nospam.nospam>
Date: Mon, 30 Dec 2002 01:10:56 GMT
Message-ID: <357v0vc7r3f4lh2l4ufottp0r5a85m3um7@4ax.com>

I think you could use the MSDE on the client with the Oracle server set up as a linked server under MSDE. MSDE will accept Transact SQL syntax, then execute Oracle queries via OLE DB to get the data for you. The only uncertainty here is whether MSDE supports linked servers or if you would need the Standard Edition SQL Server to do that.

On Mon, 30 Dec 2002 11:20:51 +1100, "news.bigpond.com" <mclass_at_bigpond.com> wrote:

>Hello
>
>I have an application that expects to write to a Microsoft SQL server and
>expects a Microsoft SQL database.
>
>I would like to know if there is a utility/gateway that will allow me to use
>the same application but to convert/write to a Oracle database.
>
>I am planning on creating the Oracle table manually.
>
>Regrds
>
>MICK
>
Received on Sun Dec 29 2002 - 19:10:56 CST