Re: ODBC Universe (Unix) to MS Access
To get BCI working from HP-UX 11.00 we had to use the Easysoft ODBC-ODBC Bridge, as it was too hard finding and compiling all the necessary parts as 64 bit. It's good software from good guys at a good price (~$1500 US), but it might be overkill for your situation. You could also write a client-side program (VB/Java) that reads the Access database through ODBC/JDBC and writes to UV thru UniObjects. (Okay, it could be server-side also, but you'd have to shell execute / cron it.) Best, David Beahm Norman, David (SAAS) wrote: Evening all, I want to be able to write and read an Access database on the LAN, from UniVerse 10.0.16 HP-UX 11i. Ray Daignault's comment about this in the archives (2001) is that a Unix ODBC driver and Driver Manager are required. Does anyone have any opinions on what drivers are better/worse than others ? I am getting info from easysoft and openlink - anyone else worth talking to ? Thanks, David Norman Senior Systems Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 fax +61 8 8271 4844 * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: callFTP?
We use Kermit scripts to allow error trapping of ftp processes. Can't say it's 100% foolproof, but it's a big improvement. For example: #!/bin/kermit + set transfer display crt if \v(argc) 2 exit 1 Usage: \%0 file ftp open dest_computer /user:usernm /password:passwd if fail exit 1 dest_computer: Connection failed if not \v(ftp_loggedin) exit 1 Login failed cd /where/the/local/copy/is if fail exit 1 /where/the/local/copy/is \v(errstring) ftp cd /where/to/put/it if fail exit 1 ftp cd /where/to/put/it \v(ftp_message) ftp put \%1 if fail exit 1 ftp put \%1: \v(ftp_message) ftp bye exit If you log the output, you can quickly see Why did last night's job fail? The exit 1 also sets the @SYSTEM.RETURN.CODE for error trapping. Best, David Beahm Daly, Mark wrote: Anyone know if there's been talk about a callFTP function? That would be nice to have. Currently we're executing unix commands to ftp files around. But parsing the output to determine whether or not the transfer was successful seems a bit hap-hazard to me. If anyone would care to share their ftp tricks and tips, I'd greatly appreciate it. Thanks, Mark. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: We need a web based Forum!
Branching from your idea: Funny thing, last week two of us were discussing what a terrible job our company's spam/virus filter was doing, and concluded it's exactly the kind of thing MV does best, if only there was a true email interface. On top of that, many of us have had to make hacks to execute blat/elm/sendmail (we just redid ours to add support for priority, Cc:, return request, etc.) Native U2 email support (POP and SMTP) would certainly make this a possibility, and (re: the originial issue) the data could also be served up forum-style through UniObjects/UoJ (unless, as you and others suggest, someone went further and made web interfaces as well). Anyway, sounds like adding this would introduce a viable business opportunity - lots of places want small-footprint, low-maintenance email filters. AFAICS each site wouldn't take more than a couple of user licenses as well. Happy musing, David Beahm Tony Gravagno wrote: Two ideas, not entirely original: 1) The techie in me says It would be an interesting project to create the e-mail and web interfaces described in an MV system. (What a concept, a database for massive amounts of structured data...) It wouldn't have the bells and whistles of established e-mail listservers (for a while anyway), nor of established web forums, but it would be possible to store the data in an MV environment which then populates one of the standard web forum software packages through an API, or a web interface can be written. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
Dawn M. Wolthuis wrote: Java Web Start works reasonably well, and I have used it. But I sure don't see how you are locked in to Sun by using it. The Java libraries will be perpetuated with or without Sun. For example, IBM develops with Java, and I'm certain they don't think they are locked into Sun. Locked into Microsoft implies dollars (forever) while locked into Java doesn't feel like as much of a prison at all. Agree? --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. Only if Sun makes Java so it has special enhancements that are solely available on Solaris, a-la J++. David Beahm In a world without walls or fences, who needs Windows or Gates? - unknown -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Installation unirpc
First off, try killing iptables. Even if you tell RH9 that you don't want a firewall, it still installs it and can cause this type of trouble. HTH, David Beahm Christophe Marchal wrote: Hello, I have installed universe 10.0 on a redhat 9. It works well on a telnet, unirpc daemon is running but I could not established an ODBC connection. Some knows what should be configure on the new server to get odbc works ? thanks for help, Christophe -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
First off, what are you planning to do with the data once you have it in Excel? In most cases it won't be useful unless you explode/flatten the data out. We have a few (UniData) solutions for turning LIST/SORT/CT output into symbolic link/html(with or without table view)/csv files, and use SBClient to handle passing the file to the client PC and opening the correct application. Best, David Beahm [EMAIL PROTECTED] wrote: I am hopeful someone can offer me some guidance. I have to move data off of my Universe system and send it to a PC for inclusion in a Excel Spreadsheet. Some background: Source data is alpha/ numeric and contains VM's, SVMs and TM Source data fields are variable lengths Requirements: Output must be fixed length Output must be importable into Excel (column definitions will be based on a fixed length map) My problem: I think Excel will choke on VMs, SVMs and TM characters. Is there a standard , ASCII character that I should use to represent them? To further complicate things, sone of the fields represent data that was input with little (or no restrictions), ie. any character on the keyboard was considered valid. Thanks Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: sbclient can emit an error sound?
p. 279, sbref.pdf EQU BELL TO CHAR(7) CRT BELL o mas facil: PRINT CHAR(7) No hay controles del sonido excepto en Windows - Control Panel. (Fije por favor la fecha de su PC.) Adios, David Beahm Yimi López B wrote: hello I have sbclient 5.2, sbclient can emit an sound . when an error is originated. thanks -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Eclipse
Sorry, I have done embarassingly little towards developing the desired plug-in. I had trouble finding a tutorial that matched what I saw in the current version of Eclipse, and recently have been using NetBeans much more than Eclipse, so have let things slide. Best, David Beahm Stuart Boydell wrote: Just saw a www.ibm.com/developerWorks seminar on web services. They are using Eclipse as their IDE and I was impressed by the sexiness of the tools (We can get to whether they work or not later). There was a thread on here a few months ago about U2 Eclipse and I was wondering if anyone had built or tried building a plug-in for U2 yet. Anyone have any comments about it? Cheers, -- Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SQL Server and Crystal Reports
Recent projects (not related to migrating away from U2, fortunately) have landed two of these on my desk: Mastering Crystal Reports 9 by Cate McCoy and Gord Maric SQL Server 7: A Beginner's Guide by Dusan Petkovic The CR manual is pretty sharp -- I only ran into trouble when trying to develop custom VB and web interfaces, and then only because of some less-documented features that a lot of other people on the community site ran into. If you want things like that solved quickly, be prepared to pay for support. (Note: CR version 10 was released just last month, and this book was published before CR 9 was available.) I can also offer VB source code for a standalone viewer. The SQL manual steps fairly lightly, introducing basics before going into details, and it covers the various parts of SQL Server pretty well. I've had to use trial and error to make some fairly basic relational tables with useful constraints, but having a decent client like SQLExecMS (www.laplas-soft.com) is a tremendous help. You might want another book that focuses on Transact-SQL to flesh this one out. Just an observation: I was really disappointed that with version 9 CR has completely abandoned the standalone report viewer as a means of distribution. I'm sure doing so simplifies their support, shows their ability to support web interfaces, and generates better licensing revenue, but I didn't appreciate all the extra work it took to distribute a few reports to just a handful of users. HTH, David Beahm Mark Johnson wrote: I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniDebugger in SB+
I am having trouble using the step functions. In my scenario, I have a program open for editing: PRINT @TTY = :@TTY FOO = 1 DEBUG PRINT ALL DONE I save it (using the UniObjects option) and select Tools | Compile. I fill in my password and the login script runs: - unix username/password login - exit script menu to unix prompt - stop dual session - start UniData login script - SB username/password login, select Wyse60 terminal type, etc. - drop to : prompt per your suggestion The terminal window shows everything working fine. Pressing F8 once works perfectly -- the yellow arrow points to the first line, the terminal window shows the SETDEBUGLINE and RUN commnads. Pressing F8 again, the output from the first print statement shows but the yellow arrow in the editor disappears. Continuing to press F8 does nothing, however if I switch to Show Dual Session, press Enter, switch back, press F8, switch to Dual Session again, and press Enter again, something unclogs and the debugger commands that hadn't executed before suddenly run ($ and a \FOO for my watch) and the yellow arrow reappears. If I leave the Dual Session up, things continue to work (F8 moves the yellow arrow, etc.). When I press F5 to let the program run (after stepping thru the DEBUG statement) the dual session shows up at line 1 again in debug mode. I can manually type E to finish running the program, but I don't know why it ran again. I can flip back to the regular session and see what was output. Doesn't sound right to me. Is there something I need to do in Dynamic Connect's settings? Thanks, David Beahm [EMAIL PROTECTED] wrote: I don't use the dual session - it seems a little redundant. To do this I change the view to host (so I can see the screen) and hit connect. That gives me the login prompt and I login (don't use a GUI terminal type) and from the menu I enter '0' to get to the UniData TCL prompt (:). If you run F5 the program it will only go into the debugger if you have a debug statement in the code. You can do an F8 to 'step into' the code. Each F8 will execute a line. This will update the edit window. If you change the view to 'debug' there is a watch window that you can add variables to using the 'quick watch' button - which will also allow you to view the values of variables. There are a couple different step buttons to 'run to cursor', 'step over' etc. It seems to work reasonably well (but then I haven't used the VB one much). What exactly were you unable to do? hth -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniDebugger in SB+
Confused is definitely the word for it. I switched to ftp, but no change. Save / Compile / Catalog all work fine, I can see the commands in the host window. My version is 1.2.2, so maybe that's the clue I need. This is from our latest install CD, but maybe I'll grab a new PE version of the client disk. Thanks, David Beahm [EMAIL PROTECTED] wrote: It looks like it is getting a little confused. I've never had to use the dual session option. Pressing F8 steps through the code just fine for me. After you get the host window logged in can you choose compile and have the compile message show? I find it easiest to switch to host view (alt+v 3) so you can read all of the messages. I'm not sure if there is any difference when using uniobjects (as I couldn't get it to work as easily as disk). Perhaps the uniobjects connection is causing the issues with dual session. Can you use ftp? I'm running UniDebugger 1.2.3 hth -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniDebugger in SB+
Javed- afraid CTRL T isn't doing anything for me. Colin- I'm not clear what exactly Dual session is about. I can click Compile, Catalog, or Run, and they work fine. However, the whole point of UniDebugger (from my perspective) is that it gives VB-like control over running code. I made some progress by changing the login script to only get to the unix shell. However, there is still some kind of hiccup where I click Step Into, then I have to click on the Dual Session and press Enter to make things move forward. Is there something I need to set differently? TIA, David Beahm [EMAIL PROTECTED] wrote: David; I use UniDebugger in a UD6/SB5.2/Win2K system. However, I don't use it on the regular SB code as that has to go through our version control s/w. I use it on stand-alone (usually conversion) unibasic routines. I use the host view when connecting/logging in until I get down to the command line in the account I'm working in (not the TCL prompt in SB). I did script part of the login but I move around into various accounts so I didn't do all of it. I've never tried the dual-session mode. I found the easiest way to get into the debugger is to put a debug into the program then compile and run it from the UniDebugger menu. Then it will stop at the debug statement and you can do all of the steps to move around the code, put variables into the watch stack etc. Hopefully, this will get you a little farther... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniDebugger in SB+
I was inspired by a recent post to take another swing at getting UniDebugger to work w/ our UD6/SB+5.2/HPUX system. I have scripted the login, and can open, edit, and compile code. However, when I try to run a program through UniDebugger, the output window shows - logging into Dual debugging session - - login completed - ...and nothing more happens. If I choose Session | Show Dual Session then I see where something tried to execute tty and received Not a verb Also, I've noticed that CTRL C is caught by the UniDebugger (which complains there is nothing selected). How can I interactively tell a program to break? Any suggestions? I'd really love to see this thing work, it would certainly be an asset. TIA, David Beahm -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users