Re: Can Oracle Forms talk to SQL Server 2000?

novaweb_at_iinet.net.au (Paul Fell) writes:
> Anyone done this? Any info much appreciated.

Install M$ ODBC driver, configure a data source and check the syntax from forms documentation about how to make forms to bypass sql*net and use ODBC instead. It works. Be prepared to re-write any SQL in your form and possibly not to use base tables in your blocks.

I once made a form (with forms 5.0) that was made to be used with wonderware scada package, they use M$ server as the query tool for their non-rdbms db. It was supposed to be run on two identical machines in the same control room, in the same ethernet segment etc. and I was able to make it work only on one of those boxes and not the another. I still have no clue :-) The wonderware database claimed to be M$ sql server v7.0 or something, not v2000.0.

-- 
Antti Järvinen, costello_at_iki.fi
            "concerto for two faggots and orchestra"