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