Re: newbie:client-server linux-windows

Well,

I'm not an Oracle guru, but I am trying right now to do just about the same thing -

Informix on IRIX as a client to a WinNT box running SQL Server.

So far what I have found is that it is not an easy thing to do. The primary way that most people think of doing this is to use ODBC.

It turns out that there is no standard ODBC for anything, so just because you have an ODBC driver, and someone publishes an ODBC Datasource does not mean that you can make a connection.

I am now searching for commercial products that will do this for me. And these are expensive, and not ODBC based.

At anyrate, you can consider going with some kind of gateway that will take an oracle request, and convert it to MS SQL, that way, the SQL Server appears as part of the Orawcle database, and that would be a very nice solution - you simply query against the NT box from oracle, adn voila, you can migrrate data, update tables, whatever.

You may end up using perl, unless you choose to use the Oracle application server like the Oracle Web Server.

The most knowledgable person that I know on these subjects is Phillip Greenspun. checkout www.photo.net, he has vast quantities of information on formulating database backed web systems. He also has a very good book on the subject.

David Buttrick

Actually if anyone would chime in on this I'd very interested in hearing what you've got to say, because this is a bone of contention for me.

Haaino Beljaars wrote in message ...
>Hi,
>
>I am a newbie with databases. So I need some big time help. What I want is
>the following:
>1) I have SQL server 7.0 running on a windows NT server machine and I want
>to keep it that
>way.
>
>2) I have an oracle server running on a linux machine, this must become
>the client of the
>windows machine.
>
>3) I want to acces the database from my web page, an apache server. With
>the of ...? Please
>don't tell me perl? Or are there some default scripts I can use?
>
>I have no clue of to get this done, so I am searching for a step by step
>plan. Where can
>I find this on the web? Or a good book?
>
>Please help me!!!!
>
>ps. please answer my mail direct and not post it in the newsgroups.
>
>
>--
>Greetings from Haaino Beljaars
>
>E-Mail: beljaars_at_phys.uu.nl
>Home Page: HTTP://www.phys.uu.nl/~beljaars/
>
>
>
Received on Wed Feb 03 1999 - 00:00:00 CET