Re: [U2][UD] ODBC to UniData

2004-09-09 Thread Louis Guillaume
Chauhan, Savita wrote: Hi, I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG, it gives an error message "You don't have permissions to chdir to /datatel/development/coldev" !

RE: [U2] UVODBC first query

2004-09-09 Thread Bob Gerrish
At 01:50 PM 9/9/2004, you wrote: A common cause of long delays when first connecting is reverse dns lookups. On the last project I worked on, we found that using the IP address for the system name eliminated this problem. We found ODBC to be too slow in the long run, though and switched to OleDB

RE: [U2] u2bc - lack of software delivery.

2004-09-09 Thread Ross Ferris
FWIW when Susan Siegesmund was here (Australia) for her "talk to the troops" last month, she mentioned that it would "soon" be possible for electronic order fulfilment --> I think early Nov was the date mentioned, so help may be at hand in the not too distant future Ross Ferris Stamina Softwa

RE: [U2] Job Posting in Austin Texas

2004-09-09 Thread Debster
LOL...I love it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Thursday, September 09, 2004 8:33 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Job Posting in Austin Texas What's the old line? You pay peanuts, you get monkeys. :-) --

Unclassified RE: [U2] How do we identify process running PORT-STATUS?

2004-09-09 Thread HENDERSON MICHAEL MR
David, Maybe ANALYZE.SHM -s will tell you, it has an entry for Port Status Semaphore at the bottom after the File & Group semaphores. So no I don't know for sure, but I do know you can forcibly unlock the PORT.STATUS semaphore with an UNLOCK PSTATLOCK SEMAPHORE. HTH Mike -Original Messag

RE: [U2] How do we identify process running PORT-STATUS?

2004-09-09 Thread Eves, David
Hi Kafsat, Thanks for that. We've now solved the problem - it was a semaphore lock that wasn't cleared. We had already tried ps -ef as per your e-mail and nothing showed up as there was no process still running, just the lock left in place. Cheers, David Eves Database Administrator Hewlett Pa

RE: [U2] Fusetalk

2004-09-09 Thread Tony Gravagno
[EMAIL PROTECTED] wrote: > Has anyone ever considerd moving the users group from e-mail to a web > based forum software like fusetalk? > http://www.fusetalk.com/ Or like this: http://www.u2ug.org/modules.php?op=modload&name=phpBB_14&file=index Or these: http://www.picksource.com/modules.php?name=

Unclassified RE: [U2] Fusetalk

2004-09-09 Thread HENDERSON MICHAEL MR
Yes they did. There were even some web forums set up on u2ug.org And when the previous supplier of this excellent list (bless you, Clif!) proposed to stop the list so we could switch over to the web forums (fora?), the hootin & hollerin & screams of horror were so loud that the e-mail lists were s

RE: [U2] How do we identify process running PORT-STATUS?

2004-09-09 Thread kafsat taiyus
In UNIX Try ps -ef | grep PORT.STATUS Or ps -ef | grep POST_STATUS Regards Kafsat -Original Message- From: Eves, David [mailto:[EMAIL PROTECTED] Sent: Friday, 10 September 2004 11:10 AM To: U2-Users List Subject: [U2] How do we identify process running PORT-STATUS? Universe Version

FW: [U2] How do we identify process running PORT-STATUS?

2004-09-09 Thread Eves, David
And the answer to my own question is: UNLOCK PSTATLOCK SEMAPHORE Which clears the semaphore set by PORT.STATUS Cheers, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eves, David Sent: Friday, 10 September 2004 10:40 AM To: U2-Users List Subject:

[U2] How do we identify process running PORT-STATUS?

2004-09-09 Thread Eves, David
Universe Version 10.0.8, Tru64 Unix v.5.1a We are currently experiencing network issues that are causing user sessions to spontaneously disconnect. When using PORT-STATUS in our uv account we get the following message: PORT.STATUS is currently being run by another user, try again later. which i

Re: [U2] Job Posting in Austin Texas

2004-09-09 Thread Clifton Oliver
What's the old line? You pay peanuts, you get monkeys. :-) -- Regards, Clif On Sep 9, 2004, at 12:58, Allen E. Elwood (CA) wrote: Woof! $40 and hour *and* they want the consultant to camp there for 4 months *and* they want an expert? Good Luck indeed! Try $125 to $175 an hour for off-site dev.

[U2] Fusetalk

2004-09-09 Thread Macktruckman
Has anyone ever considerd moving the users group from e-mail to a web based forum software like fusetalk? http://www.fusetalk.com/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [ADM] List server hiccup?

2004-09-09 Thread Rajesh Menon
I am getting all received messages again. At least twice it happened. -Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, September 09, 2004 2:28 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [ADM] List server hiccup? No. Tom

RE: [U2] [ADM] List server hiccup?

2004-09-09 Thread Karl L Pearson
YES!!! Bunches of them. It's was De ja vu all over again, and again... On Thu, 2004-09-09 at 15:27, Tom Dodds wrote: > No. > > Tom Dodds > [EMAIL PROTECTED] > 708-482-4510 Office > 630-235-2975 Cell > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread John Cassidy
I think this is an old problem dating way back to UniData 3. Going through unirpcd, you get your owner rights, but you don't get your group rights. Instead you get the explicit group rights of whoever started unirpcd. Root's group rights are usually implicit, so if unirpcd was started by root you c

RE: [U2] [ADM] List server hiccup?

2004-09-09 Thread Rod Hills
Did you sign up for u2-users-digest? This list sends a bunch at a time... -- Rod Hills -Original Message- From: Gordon Glorfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 1:44 PM To: '[EMAIL PROTECTED]' Subject: [U2] [ADM] List server hiccup? Why did I just get a mas

RE: [U2] [ADM] List server hiccup?

2004-09-09 Thread Tom Dodds
No. Tom Dodds [EMAIL PROTECTED] 708-482-4510 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Thursday, September 09, 2004 3:44 PM To: '[EMAIL PROTECTED]' Subject: [U2] [ADM] List server hiccup? Why did I

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Amy Cook
You know...i just thought of something. Login to unix as the same user you're trying to execute the odbc query from. Then cd over to the unidata account (coldev) & drop to TCL. Type LIST VOC = "DV_]" Choose one of those view names, and then type SQL SELECT * FROM XXX_NF; (Where XXX is one if the

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Amy Cook
What I do rememberis logging in as the person that created the schema, let's call that account 'sqlmgr'. Then, I did a whoami (I think from the directory that had the sticky bit set...like in your case, /datatel/development, and it showed me as root. But, since root didn't have privilege (not

RE: [U2] [ADM] List server hiccup?

2004-09-09 Thread Grant.Boice
Yes, I did! I'm starting to wonder "what's up"? Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] Web:www.bench.com

Re: [U2] uvadmin - accessing files

2004-09-09 Thread Karl-Heinz Winter
I found the solution of the problem by myself: e.g. you have a dynamic hashed file: the data of it resides in a subdirectory, .. data.030 over.030 the name of the file is the name of the subdirectory. BUT... no other files should exist in this subdirectory. If there exist other files, the uvadmin

RE: [U2] UVODBC first query

2004-09-09 Thread Ian McGowan
A common cause of long delays when first connecting is reverse dns lookups. Your PC is 192.168.1.100 and you're telneting to a server. It does a lookup of 192.168.1.100 to record the host name and it can take a while for dns to come back that it doesn't exist. The dns query is cached, so connecti

[U2] [ADM] List server hiccup?

2004-09-09 Thread Gordon Glorfield
Why did I just get a mass dump of all the list messages that I've already received today? Did anyone else get this little present? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or pr

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Alfke, Colin
Sorry, I've only seen this on Windows servers. Usually it's a case of putting a different user in the UCI.config file than the one you're trying to "login" with. The other similar problems I've see were no VOC file in the account, incorrect path/account defined in the UCI.config file, and havin

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Dana Baron
Here's a look at our uci.config file. It doesn't have any database path information, just the four required fields. DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = xxx.xxx.xxx.xxx On our system, the database path information is kept on the Unidata server in a file called /usr/unida

RE: [U2] Job Posting in Austin Texas

2004-09-09 Thread Allen E. Elwood \(CA\)
Woof! $40 and hour *and* they want the consultant to camp there for 4 months *and* they want an expert? Good Luck indeed! Try $125 to $175 an hour for off-site dev. That's the going rate for all the professionals I know. This isn't even in the ball park for someone that has to pay their own he

RE: [U2] Southern California presentation on DesignBais [SHORT]

2004-09-09 Thread Tony Gravagno
Again, I'm not getting into a mud slinging match. For whatever reason, people are excited about DesignBais without the mud. I'm learning as I go why they're getting excited and I'm just trying to share some info. Once people have the info they can do their own feature comparisons and make their

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Davis, Dawn
I DID have the same problem, but can't remember how I fixed it :( I know this may not make a whole heck of alota sense...but for some reason I went into the registry on my local pc, found the reg key for the pathname of the datatel db, and typed in manually the rest of the pathname, as editing the

RE: [U2] UVODBC first query

2004-09-09 Thread Adrian Matthews
Are you sure? Certainly doesn't happen on any of our servers, connection is near enough instant whether via telnet, uniobjects or JDBC. From: [EMAIL PROTECTED] on behalf of Don Verhagen Sent: Thu 09/09/2004 17:52 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC firs

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Craig Peterson
Follow up. Example of a permissions on a record in privilege file. Attribute 4 lists the users ID. I have noticed that by just using 'chmod' at the unix level doesn't always get you what you need. You need to check all instances of the file in question in the privilege file. I've also backe

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Craig Peterson
Don't know if this works, but did you look at the file called privilege? Example.. In Unidata :SORT privilege 101*SQLTEST 103*privilege 111*Address 111*AttorneyMaster 111*AttorneyMaster_base 111*AttorneyMaster_mv_recT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread Craig Peterson
I'm using simple "SSELECT 'dict item(s)' TOXML ELEMENTS WITHDTD TO" 'file' statement to create the XML. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Thursday, September 09, 2004 1:09 PM To: [EMAIL PROTECTED] Subject: RE: [U2] ODBC dri

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
I tried logging in as root to connect. That didn't work either !! I guess the permissions don't apply to root or does it?! Isn't there anyone out there, who had the same problem and remembers how to fix? I guess not, otherwise you would have replied by now. -Original Message- From: [EMAIL

RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread Craig Peterson
As far as the 100mb Limit on XML files into Business Objects Data Integrator, If I have a file that's larger, I just have to split that file up. This is something I had tech support verify as well as an outside "Data Integrator" specialist regarding the use of XML. This works for us, as our file si

RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread Alfke, Colin
>-Original Message- >From: Craig Peterson [mailto:[EMAIL PROTECTED] >Sent: Thursday, September 09, 2004 8:09 AM >To: [EMAIL PROTECTED] >Subject: RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata > > >Unidata Version 6.0 and UniData ODBC, Version 3.1.4. I had some trouble with

RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread Amy Cook
Actually, excel should prove to them it's not the driver that's the problem...the unidata driver supports level 2 API conformance. What exactly is it they're claiming that the odbc driver doesn't support, since it clearly works for other (Microsoft) applications? (but I'm with will...if xml is wor

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Amy Cook
Hmmm...well I wish I could remember exactly how we fixed it, but I have a feeling it's something to do w/ the effective permissions of the person you're logging in as (who I'm assuming is the owner of the schema files...that is, the person who created the schema?) Since the sticky bit can change th

RE: [U2] UVODBC first query

2004-09-09 Thread Don Verhagen
I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense?

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
Forgot to add something: The permissions on the demo database (/usr/ud52/demo) are: usr : drwx r-x r-x ud52: drwx rws --- demo: drwx rws --- The permissions on my test database (/datatel/development/coldev) are: datatel : drwx rwx --- development :

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
Uic config file has only those 4 basic parameters defined. Our unidata runs on AIX. Our unirpcd has -rwxrwx--- permission. Privilege has the same -rwxrwx--- permission. VOC has the same again -rwxrwx---. There is no sticky bit set on any of these. So, like you said, I guess $UDTBIN or rpc stuff

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
All the directories have rwx for 'owner' and 'group'. Do I need to have it for 'others' too? The permissions are like this: drwx rwx --- for datatel and coldev. The sticky bit is set on development though as drwx rws --- . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Jim Bullock
If I remember correctly, you have to have rwx permission on every directory in the path, i.e. rwx permission on /datatel, on datatel/development, and on datatel/development/coldev Jim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita >

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Amy Cook
Hm...ok, shot in the dark here.. What does your uci config file look like on your machine? Do you have any parameter defined besides the 4 basics? (like perhaps an account name?) DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = x Second, I seem to remember (this was a while

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
It says permission. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Thursday, September 09, 2004 10:27 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Does it say permissions or privilege? -Original Message- From:

RE: [U2] UVODBC first query

2004-09-09 Thread GarryS
We are using UVODBC to connect our web site to our production UV database and we also experience a FIRST CONNECT lag time. Subsequent queries are processed almost immediately. We have considered creating a routine on the server to periodically query UV so that any user would hopefully be the SECOND

RE: [U2][UD] ODBC to UniData

2004-09-09 Thread Amy Cook
Does it say permissions or privilege? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: [U2][UD] ODBC to UniData Hi, I have been trying to connect to our UniData se

[U2][UD] ODBC to UniData

2004-09-09 Thread Chauhan, Savita
Hi, I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG, it gives an error message "You don't have permissions to chdir to /datatel/development/coldev" !! I create files usin

Re: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread FFT2001
In a message dated 9/9/2004 7:19:49 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > Business Objects Data Integrator is an ETL tool. It has the ability to > Use XML file formats on import, which has been working fine with file > sizes under 100 Megabytes. I've been using XML, but thought I

RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata

2004-09-09 Thread Craig Peterson
Unidata Version 6.0 and UniData ODBC, Version 3.1.4. I can connect using Excel, haven't tried Access or others but will try them in order to plead my case. Business Objects Data Integrator is an ETL tool. It has the ability to Use XML file formats on import, which has been working fine with file

RE: [U2] u2bc - lack of software delivery.

2004-09-09 Thread uniVerse mailing list
I originally ordered the cd and was told yesterday that the version I wanted was now superseded and I'd have to request it again - so this time I've done the new version with ftp access. Problem is I wanted this software at the beginning of August - not the end of september. Not sure why it takes

Re: [U2] Southern California presentation on DesignBais

2004-09-09 Thread FFT2001
In a message dated 9/7/2004 3:46:57 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: > The pricing model is also very attractive for sites that want to get up and > going quickly. $1000US for a developer license and end-user seats are $100 > per year for license and support. See imho this i

[U2] Job Posting in Austin Texas

2004-09-09 Thread Ray Gilliam
I got this yesterday and wanted to pass it along. As much as I would love to move back to Austin, I am not looking for contract work. Feel free to let Chrissy know you heard about this from me. I heard a little about this company, nothing bad. About two or three years ago they were looking for a

RE: [U2] Southern California presentation on DesignBais [LONG]

2004-09-09 Thread Ross Ferris
Tony (and Sean), I can't let this "challenge" go unanswered, and whilst I know you don't want to get into a feature for feature slugging match . sorry folks, please switch channels now, cause this could be a long one (and I also appreciate that there are other products in this space as well

[U2] UVODBC first query

2004-09-09 Thread Andy Moore
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee tha

[U2] [UD] Why Unidata's SQL engine / ODBC doesn't perform

2004-09-09 Thread James.E.Hogan
I thought users of Unidata SQL / ODBC would be interested in understanding why the engine appears to be slow. The engine works well if only one table is being access. However when a table join is attempted things slow down considerably. This can be explained by a single sentence contained in a

RE: [U2] Anyone have experience "mirroring" a HDD over a WAN

2004-09-09 Thread Dennis Bartlett
What's funny about this is that the latest on our score is that it's a possible AIX (ie IBM) contention - if you're having it all over, then, whenever the problem is solved, we should have the double benefit of having a faster IBM box AND having a faster IBM software... woohoo! -Original Messa

RE: [U2] Anyone have experience "mirroring" a HDD over a WAN

2004-09-09 Thread Dennis Bartlett
Progress report: It seems part of our trigger slowdown (hoedown?) is due to a problem we had back in June with the machine repeatedly hanging... at the time we were advised that the hangs came about as a result of Universe not enjoying the company of AIX 5.1, and a 64 bit thang. - result? 64 bit t