Re: Ok let me ask that again - maybe someone intelligent will answer this time

"evonbart" <evonbart_at_hotmail.com> wrote in message news:kPJx8.990$nC4.123873_at_news.uswest.net...
> Hi,
>
> I need information and feedback on the different aspects of implimenting a
> web
> based application with an existing oracle database server. If I
> wanted to write my front end in ASP as opposed to Cold Fusion, is the
> following feasible?
>
> - Use an NT server with IIS and connect to a Unix Oracle server?

Easy.

> - Create DSNs from my ASP application to my Oracle servers

Easy. You may have to install the oracle client software on your web-server though.

> - Convert my Unix Oracle data to Windows NT Oracle.

Convert??? You can get the data out of your Oracle database how you like. The OS that it happens to be running on is largely irrelevant. Generally to the client of an Oracle database you do not need to know what OS the server is running on.

>
> What are the benefits to leaving my database in Oracle as opposed to
> migrating it to Microsoft SQL Server (besides the simple fact that you
> all loathe Microsoft). I realize Oracle is seriously powerful and
> since my company has been heading in that direction for some time, I
> would like to keep the advantage of all the Oracle knowledge we have.
>
> I'm just hoping someone will write and tell me that I can set up a
> connection to my Unix Oracle servers through ODBC (or something
> similar) with as much ease as I can with my MS-SQL servers. This
> would be HUGE cost savings and prove that Oracle can co-exist with
> whatever platform we will use in the future. We're trying to push to
> keep Oracle as a primary tool and any information you can provide
> would be appreciated very much.
>

If you wanted to connect to a SQL server through ODBC what would you do? You'd create an ODBC data source right? Well it's the same for Oracle, or Sybase, or DB2, etc etc. Received on Thu Apr 25 2002 - 02:07:15 CDT