[U2] Accessing UV Data from Microsoft SSIS in SQL Server 2005
Hi All, I would like to use Microsoft SQL Server Integration Services to access data in UniVerse. Do any of you have advice on accessing UV data from SSIS? Also, I have found several references to VSG (Visual Schema Generator), but I cannot locate this application anywhere. Is it of value in preparing for ODBC/OLEDB access? What product includes VSG? Thanks for help, Bill Hazard --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Citrix with Universe
Hi Mike, Given that you're running a custom VB app, the question you pose is a bit more about citrix/mac than it is about universe. Citrix will provide remote access to any app from the citrix client. Your VB app will run on a windows box with citrix server software. Citrix does have mac clients (9 and 10), so what you suggest is certainly feasible. Issues related to running any app under citrix include running multiple client instances (can your app run multiple instances on one windows box?), scale (each citrix server will run multiple instances of your app -- how many will you need to provide adequate performance?), security (your users will have a citrix logon and an application logon unless you take steps to merge 'em) and access to local resources (e.g., your app running on a central citrix server may want to try to print to a local printer -- citrix helps here, but can be tricky). VNC is another option, depending on needs. Much less ability (but hence, simpler ...). I've run citrix farms supporting 100s of concurrent users accessing an app from 50-100 locations over a WAN on various platforms. I'm not a big fan of Citrix, but it is definately a best-of-class solution to a set of problems (I try to avoid having this particular set of problems, but sometimes can't be avoided!). Hope this helps and I'm sure others out there will have thoughts as well. Bill -Original Message- From: Mike Pflugfelder [EMAIL PROTECTED] Sent: May 12, 2006 2:48 PM To: u2-users u2-users@listserver.u2ug.org Subject: [U2] Citrix with Universe Does anyone out here have experience with Citrix as it pertains to Universe? We have some customers / prospects that use Macs as their desktop computer and would like to connect to our app. Our front-end is written in Visual Basic and doesn't run on the Mac. Someone from sales just mentioned that we might be able to use Citrix to get the app to a Mac. So, does Citrix have a Mac client? Does anyone have any war stories from an implementation or anything like that? Thanks, -Mike Pflugfelder --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Bill Hazard email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] xls to text
Running under what OS? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 5:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] xls to text quote who=Cooper, Rudy Hello List, Does anyone know where I can get FREE software that will convert Excel files to text files in command line mode ? How about trying openoffice.org? I'm not sure if it has commandline options, but it does everything else... Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- 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/
[U2] Denver Sys Admin Course
Hi all, I'm a newbie to Universe (but did some PI programming in 1987). I will be attending the Universe sys admin course in denver starting may 16. love to hook up with anyone who is attending the course or who is in the denver area. Bill Bill Hazard email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Escaping the '' in Windows XP from Universe
I'm a U2 newbie, so can't test (EXECUTE is not in my VOC, sadly), but as an XP guy, I have a couple of thoughts: a) two parsers are involved (UV and XP), and the second one (XP) needs to see the quote -- suggest using or even (i.e., escape the quote itself to be sure it gets through to XP) b) use ECHO in front of DIR to have XP print what it thinks it is about to execute. So run: EXECUTE DOS /C ECHO DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv Should report (somewhere!): DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv c) if none of this helps, under xp, cmd /? provides some insight to quote handling Bill -Original Message- From: Roger Glenfield [EMAIL PROTECTED] Sent: Apr 28, 2006 1:41 PM To: Eric Armstrong [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], U2Users u2-users@listserver.u2ug.org Subject: Re: [U2] Escaping the '' in Windows XP from Universe How about EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv So that it's all one command? And your fall back could always be to move the HOLD record into another file without the s and Execute against it. Rog Eric Armstrong wrote: Does anyone know how to escape the in the following Basic EXECUTE statement? EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv CAPTURING msg RETURNING err Windows is choking on the . It thinks HOLD is a file in the LFC directory. I tried the following- EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv EXECUTE DOS /C DIR 'UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv' EXECUTE DOS /C DIR UVUSR\LFC\HOLD\INSRECAP\SutherlandIssues200604.csv and a few other things, but no go. We are on Universe 10.1.10 Windows XP 2002 Thanks in advance. Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax --- 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/ Bill Hazard email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
