This shows you the differences between two versions of the page.
|
dev:dbprocs:sqlserver:home [2009/12/07 03:40] tdo created |
dev:dbprocs:sqlserver:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== 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. | ||
| - | <code SQL> | ||
| - | 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 | ||
| - | </code> | ||
| - | A quick test can be run to show that the extended stored procedures were installed successfully. | ||
| - | <code SQL> | ||
| - | begin | ||
| - | declare @version varchar(40) | ||
| - | exec OdxGetVersion @version output | ||
| - | print 'SQL Bridge Version: ' + @version | ||
| - | print ' ' | ||
| - | end | ||
| - | go | ||
| - | </code> | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||