This is an old revision of the document!
The SQL Server Stored Procedure Interface comes in the form of Extended Stored Procedures.
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