SQL Server Stored Procedure Interface

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

Installation

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

Top