Re: [AD][U2] and PDF
Or: [AD] use a dedicated tool like mvPDF that offers a page designer... [/AD] If you factor in the time you save in setting up some of these tools the cost disappears pretty quick. Brian On 10/20/07, Hona, David S [EMAIL PROTECTED] wrote: What does 'manage' mean? Do you need barcodes, table of contents, graphics, charts, etc? Do you have a budget? The sky is the limit, of course! Good question. If you are getting into lower level stuff like generating graphs to put in pdf docs as you create them then you may well need to go to a library such as iText. This was originally a java only library but there is now a .net version. I can vouch for the java version, it is fast and solid. Regards, Adrian. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR' would have to use the whole index/selection again. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 11:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing Optimization One of the rules for UniVerse to use an index is that the restriction occurs in the first WITH phrase. The reasoning is that the majority of records to be excluded will have been excluded by the first WITH clause, and that therefore the second WITH clause need only examine the record selected by the first WITH clause. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC error
UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: What are UV server and client releases? Can you get a list of files from the built-in demo accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Saturday, October 20, 2007 12:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC error I'm getting an error message Unable to obtain list of tables from the data source from Excel on a new ODBC implementation for any of the available Universe data sources. Anyone have any ideas on where to look? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RBO properties lose their values (RedBack 4.3)
Laure, We noticed this problem about two years ago. We have a client that uses RedBack exclusively for data entry and reporting for their public storage warehouse. Every now and then we lose data inexplicably. This happens about twice or three times a week. Since we use RedBack for most of our reading and writing, we tried to find it with the logging turned up. All that did was slow down the system on generate a lot of log reading for us. Restarting RedBack does clear up the problem but for an unknown reason. We thought there might be a problem in IIS, but restarting it proved to be inconclusive. With IBM only releasing a new version of RedBack every year and no bug fixes, we wrote our own middleware using UniObjects, open source jsonrpc.org and open source Apache's Tomcat. We converted all of our objects and forms to our new platform. We do not have that problem any more. You can contact me offline for more information. Regards, Doug www.u2logic.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Sunday, October 21, 2007 3:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] RBO properties lose their values (RedBack 4.3) Hello, Starting a few days ago, if user reports are to be trusted, we've been encountering a mysterious on-and-off loss of values in some RBO properties. The issue seems to be, simply, that the GetProperty returns a blank when a value should be gotten. I cannot find evidence of loss of connectivity or other problems in any of the logs. The Redback out logs are seamless as well. It looks however like a restart of the RedBack scheduler fixes the problem, but only for a short period of time, or possibly only for a specific user. This is not happening consistently for everyone, not is it happening consistently for a single user. There have been no changes to any of the code, web form, scripting etc in the application we're having problems with, in about 2 months. There had been no changes to the Universe server or OS either except that I finally installed SP2 (Win2003 server) yesterday - but the first report of the problem came on Friday. The web server is also a Win2003 server (SP2 as well), separate machine. Has anyone come across something like this? Thanks in advance, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Thanks Jeff, I wrote an ftp_get/put as well, but it uses standard AIX programs and works very well. I've used sftp in the past and if that comes up, I'm prepared. It's just that I'm new to the HTTP retrieval world. Just getting it to work at all was exciting for me... Do you know if curl works on AIX? Thanks, Karl quote who=Jeff Schasny Karl, I'll second David's recommendation of CURL. I've used it on Unix/Linux and Win32 system for all sorts of data transfers and its rock solid. I've attached the code I use for HTTP/HTTPS data send and receive. I've got a FTP.SEND and FTP.GET that uses it as well if you're interested. -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Never mind about the AIX question. I installed the Linux Applications CD for AUX and curl is on it. Now for some good, old fashioned elbow grease. This is the exciting part of my job. Karl quote who=[EMAIL PROTECTED] Thanks Jeff, I wrote an ftp_get/put as well, but it uses standard AIX programs and works very well. I've used sftp in the past and if that comes up, I'm prepared. It's just that I'm new to the HTTP retrieval world. Just getting it to work at all was exciting for me... Do you know if curl works on AIX? Thanks, Karl quote who=Jeff Schasny Karl, I'll second David's recommendation of CURL. I've used it on Unix/Linux and Win32 system for all sorts of data transfers and its rock solid. I've attached the code I use for HTTP/HTTPS data send and receive. I've got a FTP.SEND and FTP.GET that uses it as well if you're interested. -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)
Hello Marcos, Please contact me I can connect you with our developers to review this process. Thanks Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, October 20, 2007 1:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? Thanks in advance, Best Regards, Marcos Fogaga. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Okay, I've re-written the application that retrieves product data so it now uses curl, but I'm stumped on the password section. The way the vendor site is written, it doesn't require a password to get search results. If our salesmen are logged in, they get: Retail Price: 2.02 Your Price: 1.21 But, if they aren't logged in, they get: Your Price 2.02 The login screen is embedded in the search screen and every other screen on the site. Help? Thanks! Karl quote who=David Murray Karl, Yes, and it does not actually cost you anything (open source), but it is another 3rd party product. I had a similar problem some years ago. For password handling, which can end up being a cookie issue, I used curl - http://curl.haxx.se/. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 19, 2007 10:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] -UV- HTTP secure logins [skip to paragraph 4 for the question] Our business application is a green screen legacy app. We have no desire to change. It's not broken and doesn't need to be fixed. We enhance it with 2 developers and a consultant, who we bought the system from some decades ago. I've finally figured out that I don't need http:// on the front of the createRequest URL. That was breaking everything for my earlier attempts which were in 2005. Now it's much later than that, and my boss, the C.O.O. asked if I could figure out a way to retrieve some information off our primary vendor's website and put it up on a sales screen. Done and folks are thinking I walk on water. Now for the tough part, which I seem to remember someone mentioning recently, but since it wasn't on my plate yet, I didn't pay much attention... (Isn't that like keeping something for years, then deciding to throw it away, just to need it a few days after?) Is there a way to access a web page that requires a login and password and then retrieve data from another page behind the login page? Please say yes (without lying and without the need for me to purchase a third party product). TIA -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] -UV- HTTP secure logins
Not a trivial subject. You should probably contact the site owner and inquire as to what URL encoded string their login program wants to see as a beginning point. [EMAIL PROTECTED] wrote: Okay, I've re-written the application that retrieves product data so it now uses curl, but I'm stumped on the password section. The way the vendor site is written, it doesn't require a password to get search results. If our salesmen are logged in, they get: Retail Price: 2.02 Your Price: 1.21 But, if they aren't logged in, they get: Your Price 2.02 The login screen is embedded in the search screen and every other screen on the site. Help? Thanks! Karl quote who=David Murray Karl, Yes, and it does not actually cost you anything (open source), but it is another 3rd party product. I had a similar problem some years ago. For password handling, which can end up being a cookie issue, I used curl - http://curl.haxx.se/. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 19, 2007 10:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] -UV- HTTP secure logins [skip to paragraph 4 for the question] Our business application is a green screen legacy app. We have no desire to change. It's not broken and doesn't need to be fixed. We enhance it with 2 developers and a consultant, who we bought the system from some decades ago. I've finally figured out that I don't need http:// on the front of the createRequest URL. That was breaking everything for my earlier attempts which were in 2005. Now it's much later than that, and my boss, the C.O.O. asked if I could figure out a way to retrieve some information off our primary vendor's website and put it up on a sales screen. Done and folks are thinking I walk on water. Now for the tough part, which I seem to remember someone mentioning recently, but since it wasn't on my plate yet, I didn't pay much attention... (Isn't that like keeping something for years, then deciding to throw it away, just to need it a few days after?) Is there a way to access a web page that requires a login and password and then retrieve data from another page behind the login page? Please say yes (without lying and without the need for me to purchase a third party product). TIA -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
The application checks to see if the user has access to the web page. If the user does not it should go to a login page to prompt for username and password. To by pass this, you may be able to call the login page, feed username and password and then call the page you require. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC error
Excel is different. To get a list of tables from Excel you must specify that you want to retrieve system tables. For some arcane reason best known to Microsoft and not revealed to the great unwashed, Excel worksheets are reported to the ODBC driver as system tables (and therefore get their names prefixed with $). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
No, it's true for all cases. UniVerse indexes are only used on restrictions in the first WITH phrase in the query. That's one of the rules. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the restriction is in other than the first WITH clause 4. if there is an OR conjunction with a non-indexed field 5. if will satisfy the restriction (for example a or restriction) and the index is NO.NULLS 6. if the restriction on an indexed field follows a restriction on a non-indexed field in an AND conjunction (this can be re-ordered to get the index used, but is not re-ordered by the query optimizer) An index may also be used if the query is sorted on the indexed field and not constrained. - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexing Optimization Date: Mon, 22 Oct 2007 08:02:37 -0500 Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR' would have to use the whole index/selection again. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
One of our end users started getting the printer on (AccuTerm - this prints everything you do to the printer and keeps it attached to your session so no one else can print) last week. One of our other programs, found the reason was he'd changed some equated statements from having the actual value of the value mark and subvalue mark to @VM and @SVM. Example: EQU VALID.CC.TYPES TO 'A}B}D}M}S}V' was changed to EQU VALID.CC.TYPES TO 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' The locates that previously worked on stopped working on the new equ values causing the whole string that related to that value to be sent back to the user. Somehow this whole string when it was displayed to the screen turned on the printer on function. The other programmer did several example different locate types in a test program and all but one failed on the new value that used the @VM and all worked with the old equate. So, we all said HUH???, he changed it back and the program is now working properly again. Just wanting to know, does anyone have an explanation for this? Brenda Price Affiliated Acceptance Corp Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
From: karlp Okay, I've re-written the application that retrieves product data so it now uses curl... I've used cURL for many years and recommend it highly. It's now in its tenth year as open source with a business-friendly license and exceptional maintenance record. While on-going maintenance is a good thing (I try to not use OSS that hasn't been maintained in over 6 months) the fact that a utility is undergoing a lot of change should compel developers to periodically check the change logs to see if there is something broken/fixed for which they should be aware - that's one of the reasons why we're in this forum, no? For cURL there is a new release every couple months, new bugs and issues reported every single day in the forums, and similar daily changes to CVS. The more you use cURL the more vigilant you should be. Just set a recurring appointment for yourself to check the website. http://curl.haxx.se/changes.html http://curl.haxx.se/auto/cvshistory.html and others Of course, the same applies to all s/w I suppose, but I'll bet most people who use OSS don't subscribe to the mailing lists or check back to the site after it looks like everything is working well. HTH Tony Gravagno Nebula Research and Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
When the new version of the equate was compiled under Information flavor, the compiler warned that it was a Reality style LOCATE. To its credit, the compiler defers the evaluation of the EQU until it is used, at which point, it evaluates it in context, so the compiler is evaluating VALID.CC.TYPES1,1 as A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V'1,1 The vlist output below gives a good hint as to what is going on. Notice that the field,value is being applied to the last value of the EQU string prior to doing the build with the rest of the codes. In the Reality format, it is legitimate to omit the field,value specifier, in which case the program will do a field level search rather than a value level search. This quirk would only show up with the use of an EQUATE rather than a variable assignment. If you feel compelled to use an EQUATE for the codes, you could overcome the issue with a temporary assignment such as EQU VALID.CC.TYPES TO 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' ... CC.TYPES = VALID.CC.TYPES LOCATE X IN CC.TYPES1,1 ... - VLIST of LOCATE on original equate -- 5: LOCATE X IN VALID.CC.TYPES1,1 BY 'AL' SETTING LP THEN Press any key to continue... 5 E : 060 dyn_extractV 1 1 0 = $R0 5 0001A : 03A concat A}B}D}M}S} $R0 = $R1 5 00022 : 0D4 locate X $R1 1 0 0 AL = LP 5 00032 : 0C4 jumpf --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Very oddnot sure why, mass hysteria? ;-) I'll tell you what, this is an easier construct, especially if you have two dozen or so values to stick into an array. TEMP = CHANGE('A.B.D.M.S.V','.',@VM) EQU VALID.CC.TYPES TO TEMP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Monday, October 22, 2007 14:55 To: u2-users@listserver.u2ug.org Subject: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY? One of our end users started getting the printer on (AccuTerm - this prints everything you do to the printer and keeps it attached to your session so no one else can print) last week. One of our other programs, found the reason was he'd changed some equated statements from having the actual value of the value mark and subvalue mark to @VM and @SVM. Example: EQU VALID.CC.TYPES TO 'A}B}D}M}S}V' was changed to EQU VALID.CC.TYPES TO 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' The locates that previously worked on stopped working on the new equ values causing the whole string that related to that value to be sent back to the user. Somehow this whole string when it was displayed to the screen turned on the printer on function. The other programmer did several example different locate types in a test program and all but one failed on the new value that used the @VM and all worked with the old equate. So, we all said HUH???, he changed it back and the program is now working properly again. Just wanting to know, does anyone have an explanation for this? Brenda Price Affiliated Acceptance Corp Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC error
Are you able to successfully complete the ODBC connectivity tests to the demo accounts on your server? If not, fix that first and then if that's not the problem it's probably related to a UV configuration problem. Check your unirpcservices config file and check there is no conflict with any other service on your server. BTW...has it ever worked? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Monday, 22 October 2007 11:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: What are UV server and client releases? Can you get a list of files from the built-in demo accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Thanks Tony. I've subscribed to lists and have used OSS (open source software) since about 1991. There is one thing about this situation and using cURL. I'm on AIX and the Linux Applications are specifically remastered for use on AIX. Frankly, I don't think the vigilance is as necessary as I'm not going to be downloading the next great release, until I upgrade AIX. As for OSS, I'm using it on my desktop at home and work. I've mentioned that recently. I don't have any MS products installed on my computers. My co-workers do, for the most part, and as the I.T. director, I have to deal with them daily. Usually, I just tell them to reboot 8^} . . . Ok, not really. Again, thanks. Karl quote who=Tony G From: karlp Okay, I've re-written the application that retrieves product data so it now uses curl... I've used cURL for many years and recommend it highly. It's now in its tenth year as open source with a business-friendly license and exceptional maintenance record. While on-going maintenance is a good thing (I try to not use OSS that hasn't been maintained in over 6 months) the fact that a utility is undergoing a lot of change should compel developers to periodically check the change logs to see if there is something broken/fixed for which they should be aware - that's one of the reasons why we're in this forum, no? For cURL there is a new release every couple months, new bugs and issues reported every single day in the forums, and similar daily changes to CVS. The more you use cURL the more vigilant you should be. Just set a recurring appointment for yourself to check the website. http://curl.haxx.se/changes.html http://curl.haxx.se/auto/cvshistory.html and others Of course, the same applies to all s/w I suppose, but I'll bet most people who use OSS don't subscribe to the mailing lists or check back to the site after it looks like everything is working well. HTH Tony Gravagno Nebula Research and Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)
Let's start with the basics: 1) What version of the UV/ODBC driver are you using to push the data from SQL Server into UV? 2) UV version and OS platform 3) Not really applicable in this particular issue, but: if on UNIX platform: what ODBC driver manager are using and the version? Have you re-linked UV with the ODBC driver manager? 4) have you ever had this work before? 5) have you successfully connected to UV from SQL server, if so - at what point does it fail? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, 21 October 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
So, Ray, where do I find these rules? Are they written down somewhere that I can get to and acquire a copy? Jef. - Partial Original Message- No, it's true for all cases. UniVerse indexes are only used on restrictions in the first WITH phrase in the query. That's one of the rules. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the restriction is in other than the first WITH clause 4. if there is an OR conjunction with a non-indexed field 5. if will satisfy the restriction (for example a or restriction) and the index is NO.NULLS 6. if the restriction on an indexed field follows a restriction on a non-indexed field in an AND conjunction (this can be re-ordered to get the index used, but is not re-ordered by the query optimizer) An index may also be used if the query is sorted on the indexed field and not constrained. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Richard Nuckolls wrote: the compiler is evaluating VALID.CC.TYPES1,1 as A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V'1,1 The precedence of concatenation is lower than dynamic array extraction. Try placing parenthesis characters around the equate definition. E.g. EQU VALID.CC.TYPES TO ('A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V'). It might be necessary to use the EQUATE LITERALLY form to maintain the parenthesis characters. Best regards, Gyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC error
From: Ray Wurlod For some arcane reason best known to Microsoft and not revealed to the great unwashed... I've blogged some notes on this largely OT subtopic. http:// removepleaseNebula-RnD.com/blog/tech/2007/10/sql-with-excel01.html HTH Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/