RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Ray I have used UO.NET for WinForms development and found it to be fast and stable : just as its predecessor (UniObjects) has always been. I used UniObject (uvObjects) since it first came out for all kinds of heavy data applications - from 4GLs to reporting tools - and have never been disappointed in it. It just works - that's always good to say! And for transactional work it is quite simply the quickest route available. But UO was designed for permanent, stateful connections: previously I and other members of this list have written connection pools for stateless environments where needed, before IBM added their own connection pooling facility (and with it, the restriction not to use third party connection pools as part of the product licencing). The problem is that the UO native connection pooling required to run in a stateless and multithreaded environment such as a service or ASP.NET middleware is very new - connection pool licencing is a new feature in UniVerse 10.2 - and so I doubt you will find that anyone has had a chance to really prove that part of it yet. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Methvin Sent: 27 November 2006 18:25 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects for .NET - Reference / Experience / Advice I received the following inquiry from an end user and would like to get the group's feedback. The site is installing a new SQL based case management system and is wanting to bridge between the SQL application and an existing UniVerse application. At this point we are exploring the use of UniObjects as an interfacing mechanism to keep our UniVerse data in synchronization with an external data source. I wonder if any of you could possibly help with a reference - a project you are aware of, at a customer site that would be willing to talk with us about their experience with the UniObjects for .NET SDK. I am looking for a technical or an IT project manager type of contact - someone who could describe real-world pitfalls and gotchas of using UniObjects as middleware running in a Windows Service, or in an ASP.Net application (either UI or Web Service), with an objective to getting a sense of the level of maturity and reliability and most importantly limitations, as we are hoping to leverage this technology for a long-term strategy. Thanks again for any help. Ray --- 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] UniOLEDB hangs
Hi Bill, I am little confused about how to create another data source. Can you give me more detail about it? Do we create another data source by using MS data source application or uni.config configure editor. Where do you choose shared data source? Subject: RE: [U2] OLEDB connection string Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin Network Service UDTelnet Server Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Monday, November 27, 2006 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOLEDB hangs Cody: See if the following thread helps. http://www.nabble.com/OLEDB-connection-string-tf1838501.html#a5019034 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: Monday, November 27, 2006 10:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniOLEDB hangs Hi, I wonder anyone uses UniOLEDB and experience hangs on connection string part. Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- 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] UniObjects for .NET - Reference / Experience / Advice
Brian Leach stated connection pool licensing is a new feature in UniVerse 10.2 - and so I doubt you will find that anyone has had a chance to really prove that part of it yet. The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner (what we used to call VARs) that has approximately 500 end user sites that are up to over 1,000 users at some locations. This particular Partner rewrote their whole front end using UO.NET and the Microsoft development environment for their front end. Back end and processing remains in UniBasic. The UniObjects layer is the same code for both the UO.NET and UOJ (UniObjects for Java). It is so blazing fast that some Partners have written new front end report writers with a GUI look and feel. Some Partners have written the middle layer with the intent of using multiple databases for updating - like updating a U2 Database in addition to writing to an SQL database for Reporting Cubes. Super highly scalable. Extremely fast. Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi You might want to look at an article entitled How to Access U2 Data using ODBC and OleDB in the U2UG Knowledge Base (www.mvopen.org/kb). It is a primer and may help. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: 28 November 2006 12:40 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOLEDB hangs Hi Bill, I am little confused about how to create another data source. Can you give me more detail about it? Do we create another data source by using MS data source application or uni.config configure editor. Where do you choose shared data source? Subject: RE: [U2] OLEDB connection string --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Stephen Thanks. That's good to know. Brian The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner (what we used to call VARs) that has approximately 500 end user sites that are up to over 1,000 users at some locations. This particular Partner rewrote their whole front end using UO.NET and the Microsoft development environment for their front end. Back end and processing remains in UniBasic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Triggers
Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi Brain,
I have setup uci.config and ud_database in Unidata. VSG is working fine,
but when it goes to web asp page, it hangs. I am using the asp example
that provide in Using UNIOLEDB menu. I was able to connect a few time
but not all the time. Can you setup multiply db in ud_database? I am
thinking that I missed something for this ADODB connection test.
DATABASE=cconv
UDTHOME=/usr/ud51
UDTACCT=/datatel/live/collive
TRACE_LEVEL=3
DATABASE=cconvsql
UDTHOME=/usr/ud51
UDTACCT=/datatel/work/cconvsql
TRACE_LEVEL=3
I am testing this on IIS 5.1
Best regards,
Cody Wang
Datatel Programmer Analyst
Ohio Dominican University
1-614-251-4799
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Tuesday, November 28, 2006 10:13 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi
You might want to look at an article entitled How to Access U2 Data
using
ODBC and OleDB in the U2UG Knowledge Base (www.mvopen.org/kb). It is a
primer and may help.
Regards,
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody
Sent: 28 November 2006 12:40
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi Bill,
I am little confused about how to create another data source.
Can you give me more detail about it? Do we create another
data source by using MS data source application or uni.config
configure editor. Where do you choose shared data source?
Subject: RE: [U2] OLEDB connection string
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
%@ Language=VBScript %
% ' VI 6.0 Scripting Object Model Enabled %
!--#include file=_ScriptLibrary/pm.asp--
% if StartPageProcessing() Then Response.End() %
FORM name=thisForm METHOD=post
HTML
HEAD
META NAME=GENERATOR Content=Microsoft Visual Studio 6.0
/HEAD
BODY
script LANGUAGE=JavaScript RUNAT = server
function do_test()
{
// read form fields
var location1 = Request.Form(location);
var datasource1 = Request.Form(datasource);
var username1 = Request.Form(username);
var password1 = Request.Form(password);
var sql1 = Request.Form(sql);
// write back form fields to response page.
Response.Write(INPUTS:BRBR);
Response.Write(Location: + location1 + BR);
Response.Write(Data source: + datasource1 + BR);
Response.Write(Username: + username1 + BR);
Response.Write(Attempting connection...BR);
// create a connection using UniOLEDB Provider
var Conn = Server.CreateObject(ADODB.Connection);
Conn.Provider = IBM.UniOLEDB.1;
var ConStr = DATA SOURCE=+datasource1+;LOCATION=+location1+;USER
ID=+username1+;PASSWORD=+password1+;;
//var ConStr = DATA SOURCE=+datasource1+LOCATION=+location1+USER
ID=+username1+PASSWORD=+password1+;;
Conn.Open(ConStr);
Response.Write(Connect OKBR);
Response.Write(Executing SQL...BR);
// execute SQL Statement
var RecordsAffected = 0;
var Rs = Conn.Execute(sql1);
// write field names to response page
for(i = 0; i Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Name);
Response.Write( );
}
Response.Write(BR);
// write data to response page
while(!Rs.eof)
{
for(i = 0; i Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Value);
Response.Write( );
}
Response.Write(BR);
Rs.MoveNext();
}
// Close record set
Rs.Close();
// Close connection
Conn.Close();
Response.Write(DisConnect OKBR);
}
do_test();
/script
Pnbsp;/P
/BODY
% ' VI 6.0 Scripting Object Model Enabled %
% EndPageProcessing() %
/FORM
/HTML
/*
HTML code below displays a form that collects connection data
from user. When user hits the submit button, the asp page
test1_do.asp is executed to generate a results page from
the query.
*/
// FILE: test1.asp
%@ Language=VBScript %
HTML
HEAD
META NAME=GENERATOR Content=Microsoft Visual Studio 6.0
/HEAD
BODY
FORM action=test1_do.asp id=FORM1 method=post name=FORM1
PFONT color=seagreen face= size=5SQL Execute/FONT/P
P
Location:nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
INPUT id=location name=locationBRData Source:
INPUT id=datasource name=datasourceBRUser Name:nbsp;nbsp;
INPUT id=username
name=usernameBRPassword:nbsp;nbsp;nbsp;nbsp;
INPUT id=password name=password type=passwordBR/P
P
SQL:BR TEXTAREA id=sql name=sql style=HEIGHT: 127px; WIDTH:
470px
/TEXTAREA/P
PINPUT id=Submit name=Submit type=submit value=Submit/P
Pnbsp;/P
P/P
Pnbsp;/P/FORM
/BODY
/HTML
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes you can create triggers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- 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] Triggers
Not sure if this is a question? But yes, Triggers have existed in UV for quite some time. Initially against UV SQL tables, but at release 10.x against UV Files too. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Wednesday, 29 November 2006 7:31 a.m. To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- 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] Triggers
Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- 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] Triggers
Alive and well at 10.?. On 11/28/06, chuchi [EMAIL PROTECTED] wrote: Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yeah, that has always bugged me...there is no real reasons for it as far as I can tell. The reasons often put up are: 1. Not able to control operating system level access...so what, we cannot control people usin cp, rm, or mv either, or for that matter a binary editor of some sort. 2. There is no place to put the sica...yes there is, the .Type1 file, or add in a .Type19 file. The beauty with UV is it is flexible to do things, there are lots of things in UV which you shouldn't do, but if you are aware of the constraints and make an informed decision then you can do some really neat things, one of these would be a trigger on a directory Just my 2c... Cheers, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 29 November 2006 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Taxware
ok Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x and interact on a transactional or batch basis. I saw Epicor listed as one of their partners --- so Anyone use Taxware (first data company)? Setup? How it interacts? Batch or transactional? Problems? Support raves/woes? -- Debster --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
That is correct. The trigger information is stored in the file header in what is called a SICA block. Since type 1 19 files are really directories, they do not have a file header, thus, no place to store the trigger information. BTW, the same goes for transaction logging and directories. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Allen E. Elwood wrote: But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Hm. That seems like a pretty straightforward solution. Did I hear something at the IBM IOD conference in the Futures presentation about adding triggers and/or transaction logging to directories? Or am I mis-remembering things again? :-) Anyone else who attended IOD an may have notes? -- Regards, Clif phil walker wrote: 2. There is no place to put the sica...yes there is, the .Type1 file, or add in a .Type19 file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Just a question. I'm wondering what the IBM UO.Net pooling provides over using MS Enterprise Services pooling with UO.Net? The MS pooling component is built into the Windows OS (Enterprise Services for .Net aka Component Services). The IBM option seems to be expensive as far as licencing goes especially in light that seemingly similar functionality is already available. Can anyone tell me or are there any whitepapers or manuals available on IBM U2 pooling that might describe any benefits it might have that would justify the extra cost? Thanks, Stuart Boydell The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes Triggers work well. You can find the docs in Chapter 5 of the SQL reference manual within UV Docs SQLREF.PDF I have a set of pretty simple set trigger programs that I would share. They are too big to send outside of an attachment. So I will send them to you direct. HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 11:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- 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] Triggers
But would triggers work on a dictionary that was created as a type 18 file? All of our files are created with type 18 dictionaries. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 11/28/2006 04:10:13 PM: That is correct. The trigger information is stored in the file header in what is called a SICA block. Since type 1 19 files are really directories, they do not have a file header, thus, no place to store the trigger information. BTW, the same goes for transaction logging and directories. -- Regards, Clif [SNIP] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Once you see Connection Pooling in action with UO.NET, you wouldn't want to go back! IBM has some examples applications you can download from their website in VB.NET and C#, using connection pooling. Unfortunately, there is a separate license and cost associated with it. But it is worth it, for those that need it. You only need to buy the licenses you require. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen O'Neal Sent: Wednesday, 29 November 2006 1:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects for .NET - Reference / Experience / Advice Brian Leach stated connection pool licensing is a new feature in UniVerse 10.2 - and so I doubt you will find that anyone has had a chance to really prove that part of it yet. The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner (what we used to call VARs) that has approximately 500 end user sites that are up to over 1,000 users at some locations. This particular Partner rewrote their whole front end using UO.NET and the Microsoft development environment for their front end. Back end and processing remains in UniBasic. The UniObjects layer is the same code for both the UO.NET and UOJ (UniObjects for Java). It is so blazing fast that some Partners have written new front end report writers with a GUI look and feel. Some Partners have written the middle layer with the intent of using multiple databases for updating - like updating a U2 Database in addition to writing to an SQL database for Reporting Cubes. Super highly scalable. Extremely fast. Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] verify.sql fatal
I transferred an SQL account to a new server Windows 2003. When I do a VERIFY.SQL I get a fatal with the message ! OS owner does not agree with SICA specified owner. Does anyone know how to resolve this? I have never had this problem before moving files. The only thing is I am moving from a NT4 to Win2003. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Mobile: 0428 669 730 www.dacono.com.au PO Box 909 Lane Cove NSW 2066 Australia Phn: 61 2 9418 8329 Fax: 61 2 9427 2371 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Wednesday, 29 November 2006 9:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects for .NET - Reference / Experience / Advice Once you see Connection Pooling in action with UO.NET, you wouldn't want to go back! IBM has some examples applications you can download from their website in VB.NET and C#, using connection pooling. Unfortunately, there is a separate license and cost associated with it. But it is worth it, for those that need it. You only need to buy the licenses you require. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen O'Neal Sent: Wednesday, 29 November 2006 1:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects for .NET - Reference / Experience / Advice Brian Leach stated connection pool licensing is a new feature in UniVerse 10.2 - and so I doubt you will find that anyone has had a chance to really prove that part of it yet. The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner (what we used to call VARs) that has approximately 500 end user sites that are up to over 1,000 users at some locations. This particular Partner rewrote their whole front end using UO.NET and the Microsoft development environment for their front end. Back end and processing remains in UniBasic. The UniObjects layer is the same code for both the UO.NET and UOJ (UniObjects for Java). It is so blazing fast that some Partners have written new front end report writers with a GUI look and feel. Some Partners have written the middle layer with the intent of using multiple databases for updating - like updating a U2 Database in addition to writing to an SQL database for Reporting Cubes. Super highly scalable. Extremely fast. Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services --- 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] UniObjects for .NET - Reference / Experience / Advice
Hi David, Are there any whitepapers or info about it. I'm assuming now that there is some U2 server-side componentry that might make it faster or have more functionality than pooling thru Ent Services. I'd be interested to compare. We are using Ent Services for our procurement web service and are finding performance is good and reliable. Haven't had to touch it in 2 years and it has handled everything thrown at it with aplomb (and it has been hammered) so I can't see a reason to change and pay for pooling right now. However, if there was significant functionality in the IBM product not in ES it could be worth investigating. Stuart Boydell From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S [EMAIL PROTECTED] Sent: Wednesday, 29 November 2006 09:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects for .NET - Reference / Experience / Advice Once you see Connection Pooling in action with UO.NET, you wouldn't want to go back! IBM has some examples applications you can download from their website in VB.NET and C#, using connection pooling. Unfortunately, there is a separate license and cost associated with it. But it is worth it, for those that need it. You only need to buy the licenses you require. ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Taxware
I integrated Taxware into our business system (Shims - Unidata 6.0). We use the transactional approach for exemption certificates but have developed a c-wrapper (with the help of this list) for the realtime api for the tax calculations. We do not use the client side application for tax exemptions because it is far to limiting (have to download to a local pc and manually enter certificates). If you would like move information, please feel free to contact me offline. Vance [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/28/2006 04:03 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Taxware ok Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x and interact on a transactional or batch basis. I saw Epicor listed as one of their partners --- so Anyone use Taxware (first data company)? Setup? How it interacts? Batch or transactional? Problems? Support raves/woes? -- Debster --- 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] Taxware
I'll bite. How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago along with its step brother, RESULTS. Is it supported or detached like Results? Thanks Mark Johnson. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 28, 2006 10:36 PM Subject: Re: [U2] Taxware I integrated Taxware into our business system (Shims - Unidata 6.0). We use the transactional approach for exemption certificates but have developed a c-wrapper (with the help of this list) for the realtime api for the tax calculations. We do not use the client side application for tax exemptions because it is far to limiting (have to download to a local pc and manually enter certificates). If you would like move information, please feel free to contact me offline. Vance [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/28/2006 04:03 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Taxware ok Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x and interact on a transactional or batch basis. I saw Epicor listed as one of their partners --- so Anyone use Taxware (first data company)? Setup? How it interacts? Batch or transactional? Problems? Support raves/woes? -- Debster --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Taxware
Wellit's kinda funny since this system is a highly evolved ;-) Shims package.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Tuesday, November 28, 2006 11:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Taxware I'll bite. How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago along with its step brother, RESULTS. Is it supported or detached like Results? Thanks Mark Johnson. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 28, 2006 10:36 PM Subject: Re: [U2] Taxware I integrated Taxware into our business system (Shims - Unidata 6.0). We use the transactional approach for exemption certificates but have developed a c-wrapper (with the help of this list) for the realtime api for the tax calculations. We do not use the client side application for tax exemptions because it is far to limiting (have to download to a local pc and manually enter certificates). If you would like move information, please feel free to contact me offline. Vance [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/28/2006 04:03 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Taxware ok Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x and interact on a transactional or batch basis. I saw Epicor listed as one of their partners --- so Anyone use Taxware (first data company)? Setup? How it interacts? Batch or transactional? Problems? Support raves/woes? -- Debster --- 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-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/
