We are trying to set up UniVerse 10.2 to talk directly to a SQL Server
system. After following all of the directions in the UV manuals and the
DataDirect docs we can talk to the SQL Server from Linux using the demo
program that comes with DataDirect but are unable to connect using UV.
As a matter
Thank you Ken and David, you both had the correct answer.
Michael Golden
Information Technology Manager
Unique Fabricating Inc.
Ken Wallis [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/22/2007 07:45 PM
Please respond to
u2-users@listserver.u2ug.org
To
u2-users@listserver.u2ug.org
cc
Hi Jerry,
FusionWare has a bridge product that will run right on Linux. You can call
UV/BASIC subroutines to do the equivalent of READ, WRITE, SELECT, COPY(to and
from SQL) and SQL Passthru to a SQL Server table as though it were a
(single-valued) PICK file. If this would be of interest to
Thanks to all who wrote about this problem. The simplest solution -
that of simply copying the JPG files to one type 19 directory - is
working, to my amazement. There are 171,000 mugshots in one directory
and they are being handled correctly. As far as a solution goes, that's
good enough.
I was under the impression that UniData could handle something like:
OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT File abort. ELSE STOP 201,
'E:\DataShare\Temp'
SELECT TEMP.FV
IF SYSTEM(11) THEN
LOOP
READNEXT ID ELSE EXIT
...do something
REPEAT
END
This worked fine in D3
I've never used drive letters myself, I don't think that will work in
U2.
Is this Windows or Unix?
If it's Unix - Have you tried using the Unix pathname to see if the file
will successfully open?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill
You can look at OSOPEN in UniData. I do not think any flavor of UniData will
support your 201 error code condition, but I may be wrong.
Also, if you want SYSTEM(11) to work, then I do think you will be better off
putting a directory entry into the VOC file and opening with a standard open
Try using the OPENSEQ or an OSOPEN depending on your needs. I can't
remember the difference, but HELP should show you the way.
Tom Dodds
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, August 23, 2007 12:23 PM
To:
I was under the impression that UniData could handle something like:
OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT File
abort. ELSE STOP 201, 'E:\DataShare\Temp'
SELECT TEMP.FV
IF SYSTEM(11) THEN
LOOP
READNEXT ID ELSE EXIT
...do something
REPEAT
END
This
Hi Harold,
The simplest solution - that of simply copying the JPG files to one type
19 directory - is working, to my amazement. There are 171,000 mugshots
in one directory and they are being handled correctly.
Remember that the process of searching an operating system directory is
Hi Bill,
I was under the impression that UniData could handle something like:
OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT File abort. ELSE STOP
201,
'E:\DataShare\Temp'
UV can do this using OPENPATH. I don't think this is supported in Unidata
(I'm not in a position to check right now
Create a DIR pointer that looks like this:
:AE VOC TEMPDIR
001: DIR
002: D:\DataShare\Temp
003: D_VOC
That's the unidata way.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, August 23, 2007 3:23 PM
To:
We want UniVerse to be the client, is that what your product will do? We
don't seem to have any problem getting the data from UniVerse, just
getting the data from SQL Server using UniVerse.
Jerry
-Original Message-
From: Janet Bond [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 23,
You'll need a DIR pointer to access that file, then open the file via the
DIR pointer name.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I can't speak authoritatively for UD on Windows, but if this is a
sequential file, I think you'll have to use OPENSEQ instead of OPEN.
OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT File abort. ELSE STOP
201,
'E:\DataShare\Temp'
Brad
The answer to life, the universe and everything.
sdg
Hi Jerry,
Yes, that is exactly what we do , with our product Universe Basic is the client.
Janet
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Thursday, August 23, 2007 2:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2]
Release notes for 1.2.1 of our Free Editor, Dictionary Editor, Object
Editor, Resize Tool, Installer, and Web Developer tool:
1) Use version format of major.minor.service.
2) Remove unneeded dependencies.
3) Update copyright.
The main change is using 3 levels of version number with each part
At PhotoWorks circa 2003, we had approximately 500,000,000 jpegs of various
sizes sitting in Unix directories on one IBM RS6000.
We got around the OS limitations by storing image 12345678a.jpg as
/12/34/12345678a.jpg, and the top level directories were on 50 different
filesystems as I recall.
Thanks to all who responded.
I wanted to open a directory, not a file. OPENSEQ and OSOPEN, according to the
documentation and my usage experience in the past, allow opening an O/S file
(record
key). I simply wanted to open the directory. UniVerse has the OPENPATH
command and
there doesn't
Sara,
How do I set up the UVCS.LOGIN paragraph? I don't have one on my system
to use as a template. I have searched the UV PDF documentation and
Googled for UVCS.LOGIN but found nothing helpful.
I tried this:
CT VOC UVCS.LOGIN
UVCS.LOGIN
0001 PA
0002 JEFLOGIN
0003 END:
But it didn't run
What do you mean by 50 different filesystems? 50 directory / Type 19 files?
On 8/23/07, Ross Morrissey [EMAIL PROTECTED] wrote:
At PhotoWorks circa 2003, we had approximately 500,000,000 jpegs of
various
sizes sitting in Unix directories on one IBM RS6000.
We got around the OS limitations
Put it in the UV account.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 24 August 2007 2:46 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Sacred Licence Seat - A Challenge
Sara,
How do I set up the UVCS.LOGIN paragraph?
22 matches
Mail list logo