Hi,
We're trying to setup an OBDC link to Unidata and have done so with some
success. We can get data within SQL Express running the following query:
SELECT * FROM OPENQUERY(UnidataSource, 'SELECT * FROM ODBC_TESTFILE_1')
So we know the file schemas work and the Linked (UnidataSource) server
appears correctly configured.
The problem we are having is calling a Unidata subroutine via a VSG
procedure (TEST_PROC with 1 numeric parameter, nullable) from SQL Express.
Can anyone provide the syntax for performing this within SQL Express?
Probably incorrect but I'm using the following:
EXEC ('CALL TEST_PROC("123")') AT UnidataSource
Within my Unidata test program should open and write "success" to a file,
and does when run direct from TCL so I know the program is fine. However,
when invoking the EXEC statement above, a connection is made (viewable from
Uniadmin/Users) but the subroutine doesn't appear to have been invoked and
no error is returned back.
Can anyone throw some light on this?
We're running Unidata 7.1 btw :)
--
View this message in context:
http://old.nabble.com/how-to-invoke-a-subroutine-remotely-via-ODBC-tp26284422p26284422.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
