Re: Can Oracle Forms talk to SQL Server 2000?

I have the form returning records back from a table. Thanks

Next question. Is it possible to have a button on a form that executes a SQL Server 2000 Stored Procedure? For the WHEN-BUTTON_PRESSED Trigger I tried the following :

exec my_proc('test','test','test);

I get an error message when trying to compile 'syntax error near my_proc'

The SP works OK in SQL Server.

Paul

costello_at_iki.fi (Antti Järvinen wrote in message news:<m3heon6bll.fsf_at_muikku.baana.suomi.net>...
> 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.
Received on Wed Feb 20 2002 - 02:34:37 CET