[U2] UniData 7.1 and ODBC
I'm having some basic trouble getting ODBC setup with Unidata. In Developing UniData ODBC Applications under Before You Begin it says: * Make sure the files you want to access in UniData are ODBC/SQL accesible. See Using VSG and the Schema API Yet in Using VSG and the Schema API under Before You Begin it says: * Setup your ODBC server and database information so that the files are accesible to VSG. Here's what I tried and isn't working too well. I edited uci.config file and added the entry testr18 DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = quicksilver.hampshire.edu account = /datatel/coll18/test/apphome When I attempt to run VSG, I see my testr18 definition in the server drop-down, and then enter: Database Name: testr18 User: my_username Password: my_password and get: Died in UCI::SQLConnect() with SQLSTATE 08001, Native error: 0 [IBM][SQL Client][UNIDATA] Database testr18 doesn't exist. Any pointers appreciated. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Job opportunity
Sorry if this is reposted b I could not find my original post in nabble for some reason so am resending to be sure b. Posted on behalf of a friend of mine - if you are interested please email me and I will pass on contact details. PICK/ Universe Analyst Programmer. A financial company in London is looking for a PICK/ Universe Analyst Programmer with good DATABASIC programming skills to support, develop maintain applications and systems. Candidates coming from a financial background will be looked upon favourably. This is a fantastic opportunity for a candidate that is looking to work within the financial sector and be trained within all the latest technology. Must be a good team player and work well on their own and be self motivated. Must be professional in all matters, be prepared to take responsibility in his/her stride and be accountable for their work and efforts. Must be eager to learn, both new technical skills as well as improve their business acumen and inter personnel skills. Salary 28 to 32K plus Benefits. Rgds Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How do you call a Unidata Stored Procedure via ODBC?
I am using SQL Server 2005 and have setup a linked server using UniData
ODBC, Version 3.1.6; Everything works well.
Has anyone sucessfully defined a stored procedure via VSG and call it
from ODBC?
Can it be called via SS2005 using the command
EXEC ('CALL VSG_DEFINED_PROCEDURE(PARAM1,PARAM2)') AT
UNIDATA_LINKED_SERVER
Thanks for your help in advance,
Noah Hart
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Credit Card Processing
Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Processing
Our VAR wrote their interface using the Versign Pay Flow Pro package. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 06, 2007 3:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Processing
Scott, We use Chase Paymentech to process our CC transactions. They are pretty decent to deal with. They are pretty big so having a good acct manager to get what you need makes all the difference. They handle all card brands and multiple currencies (if connecting your web portal). Just a thought as you approach your implementation: You bring a whole new world of data security requirements to bear on your business app if you bring credit card data directly into it. It's a beautiful thing to wed a CC interface right to your application, and we have the upper hand in the MV world, but the Payment Card Industry Data Security Standard is a nasty document that will cost your organization quite a bit to comply, and you get zero ROI (IMHO), except perhaps some clout for your company brand as being PCI compliant. I doubt your store front customers, in a brick and mortar setting, are going to be impressed that your business app is PCI compliant. You might be best served by looking for a POS credit card app on a stand-alone server, that is the system of record for all CC transactions/data and does your data at rest encryption. Then just communicate with that server from UV about whether the CC Auth went through, was deposited, etc. HTH, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 06, 2007 2:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] Credit Card Processing
Check with Total Computing Solutions in Utah (801) 796-7600. They offer a UniVerse based solution. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 06, 2007 3:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] Credit Card Processing
A word of warning, though it may not be a show-stopper. We called Total Computing Solutions lat year with a request to integrate their CC solution into our MV application. After reading their glossy advertisement, we felt it might be the cat's meow. We placed a call to sales. They called back and we talked, then we called and asked and they told us a price and we asked them to come see our situation and propose an implementation schedule and they never called back. We are working on another solution. During this process, they offered me a job, too, for 20K less than I was making at that time, and I make less than the market around here (there's more to a job than the money). Karl quote who=Ray Methvin Check with Total Computing Solutions in Utah (801) 796-7600. They offer a UniVerse based solution. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 06, 2007 3:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] Credit Card Processing
PCI compliance is the bugger here. If your company doesn't have the resources (money) to become compliant you won't get your credit cards processed. The best bet for a company that doesn't have the resources is to send the cards through one of the available credit card processing companies that have become compliant or soon to be compliant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 2:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] Credit Card Processing
Scott, Contact Total Computing Solutions at www.total-computing.com for their credit card processing system, TotaLink, that integrates with most mv databases, including Universe. Dave Taylor CEO Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (F) 310-377-3550 www.sysmarkinfo.com Your Source for Integrated EDI Translation, DataSync Integration and Software Migration Authorized IBM Business Partner - Original Message - From: [EMAIL PROTECTED] To: u2-Users u2-users@listserver.u2ug.org Sent: Monday, August 06, 2007 11:42 AM Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] [UD] Expresion stack underflow
What causes an Expresion stack underflow? (Error #40198) A couple of our developers here are getting this message: In programname at line Expresion stack underflow. I have unconfirmed reports that it happens occasionally when the main program or subroutine is recompiled with minor changes while in use, and the user is at an INPUT prompt in a lower subroutine. I'm not convinced because A) it doesn't happen all the time, and B) a change to the object should not effect a program already in memory. There are no references to that message in the UniData docs, nor any relevant information in the knowledge base. Version 6.1.18 on HP-UX. TIA, Dean Armbruster System Analyst Wolseley North American Division * 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1(757) 989-2839 * F: +1(757)989-2801 * E: [EMAIL PROTECTED] www.wolseley.com Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Processing
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Monday, August 06, 2007 1:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Credit Card Processing Our VAR wrote their interface using the Versign Pay Flow Pro package. We did that as well on our own. It was pretty trivial to implement. If you're comfortable writing the code on the UV side to assemble and parse some XML, that's pretty much all the expertise required. PayPal (formerly Verisign) supplies you with an OS-level executable that passes the data back and forth to their server. You just have to feed it the XML data via a BASIC EXECUTE, then capture the output. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
