[U2] unsubscribe * [EMAIL PROTECTED]
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [ID] Copying from AIX box to Linux box
NFS can be a good option when I work on our new Windows box. It is just like another hard drive. Best regards, Cody Wang Datatel System Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent: Thursday, July 12, 2007 4:11 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: [ID] Copying from AIX box to Linux box Hi all, We are trying to copy Unidata accounts from our AIX box to our Linux box. We do not have a common tape drive we can use which would seem the ideal way to copy large amounts of stuff. We decided to try using scp (SSH version of cp) and managed to get some small accounts copied over and working. It is a very slow process :-( While trying to use scp on an account with larger files (not huge mind you), the process will stall and then it is disconnected. Does anyone know what would cause scp to stall like that? It does not seem to use up a lot of resources on either box. Any suggestions on what else would work in both a secure and, preferably, a faster manor? Thanks, *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* Colleague 17 Benefactor 5.1 AIX 5.1.3IBM RS6000 F50UniData 6.1.11 *---* Please send ALL answers to questions to the list. List maintenance can be done at discuss.datatel.com with your www.datatel.com login, as well as via email to [EMAIL PROTECTED] Send subscription problems to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniODBC with ASP error
Hi all, I am working on CAS project that has an error I could not figure out. Does anyone experience call Datatel subroutine with error out on asp page? It bomb out on a S.EVALUATE.PROGRAM subroutine in Unibasic program. On my ASP pages it shows Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]Unidata lower level function error with fetch 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/
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] 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/
[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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: Monday, November 27, 2006 10:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Phantom Limits I was under the impression that the number of phantoms is limited to the licensed number of users less the number of users on the system. In other words, each phantom used a license. Am I out incorrect? Tom Dodds [EMAIL PROTECTED] wrote: In my experience, which is at UV 10.0.x some years back, the limit is not system wide, but was imposed at the host process level. The limit I found was 50 phantoms per host process so if you needed to have more than 50 phantoms running you needed to start multiple host process to spawn a set number of processes. I was never able to find a tunable parameter to modify the limit. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Veenhof Sent: Thursday, November 23, 2006 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Phantom Limits Hi, I'm just reading up on phantoms, and saw this little note in the HELP... There is a system-wide limit on the number of processes that you can initiate. If you can start no more processes when you issue a PHANTOM command, the following message appears: NO FREE PHANTOMS You cannot run a phantom process now. Wait a while, then try again. I was wondering if anyone knows off the top of their head, what determines this limit? Is it a static number, if so what, or is it user definable? Thanks Peter --- 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/ - Everyone is raving about the all-new Yahoo! Mail beta. --- 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] UniOLEDB hangs
Hi all, We are trying test connection between PC/server and Unidata that we did not get too much luck for our CAS deployment. I have been used the asp page that provided in UNIOLEDB menu. Sometimes works on my PC but not all the time but not on others, if it is failed, the connection hangs there forever. I use IIS test. I just wonder that does anyone use UNIOLEDB before. The oledb provider testing program shows test successfully every time. Thanks Cody Wang Ohio Dominican University 614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UNIOLEDB sample code error
Hi all, I wonder can anyone share a ASP sample code for connnecting to database. I tried to use teh sample code in Unioledb but got some error message. The first is pm.asp and the 2nd one is % ' VI 6.0 Scripting Object Model Enabled % that I tool out. Now I have /var ConStr = DATA SOURCE=+datasource1+; issue taht I could not figure out. I believe I use the right database source name which I define in uci.config name Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC: database does exist
Hi all, I was trying to use VSG to connect the Unidata database. I was able to connect Unidata demo database, but once I change to our test database that I was not able to connect. I have change ud_database to point to our test database. The error message is database doesn't exist. Did I miss anything? 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/
RE: [U2] ODBC: database does exist
I think so because I am able to connect 'demo' database is on the same box with our test database. Do I have to define database in uci.config? leo DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = leo ACCOUNT = /datatel/live/collive Ud_database DATABASE=cconv UDTHOME=/usr/ud51 UDTACCT=/datatel/live/collive TRACE_LEVEL=3 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 Robert Paterson Sent: Wednesday, November 01, 2006 9:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC: database does exist Have you also set up the UCI.CONFIG file on the client end to match the new ud_databases reference? There is a UCI.CONFIG editor supplied with the latest ODBC installs which should allow you to amend as needed. Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: 01 Nov 2006 12:58 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC: database does exist Hi all, I was trying to use VSG to connect the Unidata database. I was able to connect Unidata demo database, but once I change to our test database that I was not able to connect. I have change ud_database to point to our test database. The error message is database doesn't exist. Did I miss anything? 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/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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/
