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

pagesflames_at_usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0204242258.29e41545_at_posting.google.com>...
> "evonbart" <evonbart_at_hotmail.com> wrote in message news:<kPJx8.990$nC4.123873_at_news.uswest.net>...
> > - Use an NT server with IIS and connect to a Unix Oracle server?
>
> Yes, you can use ODBC.
>
> > - Create DSNs from my ASP application to my Oracle servers
>
> Yes, we're using this technology. In ASP you have two ways (probably
> more), you can connect to database using ODBC or Oracle Objects.
>
> > - Convert my Unix Oracle data to Windows NT Oracle.
>
> If you mean export from Oracle on Unix to Oracle on NTs, then without
> problem. However maybe is better to leave you database on Unix, there
> are no differences (from client perspective) in accessing both of
> these platforms.
>
> > 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.
>
> Sorry, but I do not want to start another useless flame about what
> RDBMS is the best. I've worked with MS SQL and with Oracle and I think
> that with Oracle in terms of stability, scalability and overall
> performance, you will get a better tool.
>
> > 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.
>
> As I already said, just install Oracle drivers on that computer, and
> also Oracle Objects or ODBC drivers and after few minutes, you would
> have a complete connectivity to you Oracle server, of course only if
> your network is working.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.

In regards to >>
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 have Oracle on UNIX and have applications that access it from PC using ODBC and SQLNET, NT based web servers, VMS application servers (pro*c programs), and UNIX application servers. As long as you install the Oracle client or make use of the java thin client you can reach an Oracle db anywhere on your network (allowing for firewalls locations and settings).

HTH -- Mark D Powell -- Received on Thu Apr 25 2002 - 07:51:29 CDT