SQL Server Stored Procedure Interface

The SQL Server Stored Procedure Interface comes in the form of Extended Stored Procedures.

• SQL Server Stored Procedure Example

With the SQL Server Stored Procedure Interface dll, odxplssv.dll, in place in the OMNIDEX_HOME/bin directory, the following SQL script can be run in SQL Query Analyzer to install the extended stored procedures in the Master database.

EXEC sp_addextendedproc 'OdxConnectEnv', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxIsConnected', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxDisconnectEnv', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxOpenCursor', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxIsOpened', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxCloseCursor', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxParseSql', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxSetVariable', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxSetColumnType', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxExecuteSql', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetRow', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetColumn', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetLastRowCount', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetVersion', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetErrorMessage', 'odxplssv.dll'
EXEC sp_addextendedproc 'OdxGetPrimaryKeys', 'odxplssv.dll'
GO

A quick test can be run to show that the extended stored procedures were installed successfully.

BEGIN
DECLARE @version VARCHAR(40)
EXEC OdxGetVersion @version output
print 'SQL Bridge Version: ' + @version
print ' '
END
GO