Thanks again david I am assuming that uci needs to be restarted for this to take effect and am waiting for the client to do so.
In case anyone is at all interested, it seems that this problem goes away if the NUMERIC column doesn't contain any data values - ie all values are NULL I have asked that the client try to execute the SQL Server command that is hanging me up locally on one of their SQL Server machines to determine if this is something that is particular to my SQL Server machine or to their universe system. No word on this yet. gerry ----- Original Message ----- From: "Hona, David S" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Wednesday, March 10, 2004 2:08 AM Subject: RE: SQL Server , UniOLEDB & subtables > > Gerry, > > Enter the values stated, separated by spaces, I believe. > > We're not having problems with our UCI connections, so have never needed to > debug them. It's a new feature, so perhaps it doesn't actually work as > documented! > > Regards > David > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of gerry simpson > Sent: Tuesday, March 09, 2004 10:52 PM > To: U2 Users Discussion List > Subject: Re: SQL Server , UniOLEDB & subtables > > > Thanks David > > the docs 'explain' how to enable server side uci logging via the > UVHOME/serverdebug file this file doesn not currently exist and no format > beyond 'column' values is given. do you know what the format of this file is > ? what delimits a column , space , comma , tab , colon ? i've tried all 4 > but have yet to see a debug log file appear. do we have to restart uci/uv to > have changes take effect ? > > gerry > > > > > ----- Original Message ----- > > From: "Hona, David S" <[EMAIL PROTECTED]> > > To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> > > Sent: Tuesday, March 09, 2004 2:26 AM > > Subject: RE: SQL Server , UniOLEDB & subtables > > > > > > > > > > I suggest you read-up on how to enable the UCI logging feature. As > > UniOLEDB > > > uses UCI to communicate with UV. > > > > > > See 'Administrative Supplement for Client APIs' pages 3-21 and 3-22. > > > > > > Of course, this will just help with issues at the UV end. > > > > > > Regards > > > David > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > On > > > Behalf Of gerry simpson > > > Sent: Tuesday, March 09, 2004 5:38 AM > > > To: [EMAIL PROTECTED] > > > Subject: SQL Server , UniOLEDB & subtables > > > > > > > > > we have set up universe 10 in SQL Server 2K as a linked database > > > via UniOLEDB. > > > > > > we have a test file set up that consists of 2 single valued fields & > > > 2 > > multi > > > valued fields > > > > > > at the universe command prompt we can access both the table and the > > virtual > > > table for the multi values : SELECT * FROM TEST.TAB ; [snip] > > > > > > any ideas ? > > > > > > does universe keep any type of log for oleDB access - i can't find > > > one > to > > > see if the request is even getting to universe. > > > > > > gerry > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
