SQL Interface and Datasets (OpenInsight Specific)
At 10 OCT 2000 12:23:08PM Sedick Cloete wrote:
I am in the process of developing interface facilities between my LH database and a SQL database. When creating my dataset in client/server workspace and I click on the USE TABLE button to import the columns for me, I get an error message :
Could not find stored procedure 'sp_xo_objects.'
Please help. Am I missing some system procedures from my OI App or is this a known problem.
Thanks
Sedick
At 10 OCT 2000 01:19PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Checkout MS6Batch.txt…
/* MS6BATCH.TXT © 1995-1998 Revelation Software */
/* */
/* Product : OpenInsight for Workgroups */
/* Version : 3.62 */
/* Date : 07/08/98 */
/* */
/* Description: Microsoft SQL Server 6 (and later) specific. */
/* A set of Transact-SQL statements that create */
/* the SQL Server objects used to list tables */
/* and columns in a standard format for the */
/* SQL Server Connection Object. */
/* */
/* Why to use : These commands should be run on each SQL */
/* Server that will be accessed using the SQL */
/* Server Connection Object. They are */
/* necessary for the Query methods */
/* QRY_LISTTABLES$ and QRY_LISTCOLUMNS$ and the */
/* Connection properties XO_TABLELIST$ and */
/* XO_TABLEDESCRIPT$. */
/* */
/* When to use: After installing OpenInsight, before using */
/* the SQL Server Connection Object to access */
/* a particular SQL Server. */
/* */
/* How to use : This set of scripts is formatted to be run */
/* using ISQL. The administrator (sa login) */
/* should run this script because this script */
/* creates objects in the master database. For */
/* help with ISQL, consult your SQL Server */
/* documentation. To execute these scripts */
/* from a SQL Server tool other than ISQL, you */
/* should execute each script individually. */
/* Each script ends with "go". Most tools */
/* other than ISQL do not support the "go" */
/* keyword; in those cases, remove the "go" */
/* from the end of each script before */
/* execution. */
/* */
World Leaders in all things RevSoft
