DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended.
Jeremy, Although we aren't using schemas, we too have experienced timing issuues when retrieving data via the UVODBC. We supply our customers with a 3rd party report writer that connects to Universe via the UVODBC driver. Most of the time this works fine, but on some queries we have noticed that the query can either take hours or get in to what appears to be a continous loop. When this occurs the server is normally affected by the CPU running at 100% and all other processes on the server suffer as you would expect. This normally results in us having to dial in to the customer site, kill the process on the Windows side and then log of the Universe user at TCL to free up the server again. Running the same query at TCL level normally returns very quickly. Unfortunately we haven't yet found a cause or fix for this problem and as the report writer is a 3rd party tool IBM support cannot offer any support on this either. Equally the 3rd party report writer supplier will not supply support for the UVODBC side of the process. While this isn't directly related to your problem, I just thought I'd mention it in case anyone has come across this issue either? -----Original Message----- From: Jeremy Woods [mailto:[EMAIL PROTECTED] Sent: 11 August 2004 07:14 To: [EMAIL PROTECTED] Subject: [U2] Universe 10.1.1 ODBC driver Hello group I am trying to access some SQL tables created in universe via ODBC with microsoft access but retreiving the data is very slow - about 2 minuted to retrieve 91 records with approximately 20 columns of data. We have tried running the same query on our HP machine and then a Linux machine - same results. The tables have been setup in a Schema and have been created using the CREATE TABLE keywords. If I do the same select statement at TCL it is very quick to display the data so I assume it is something to do with the universe ODBC driver. Anyone experienced this before ? Regards Jeremy Woods Western QBE Insurance Perth IT (08) 9213 6398 ________________________________________________________________________ IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or copying of this email is unauthorised and strictly prohibited. If you have received this email in error, please promptly inform us by reply email or telephone. You should also delete this email and destroy any hard copies produced. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
