Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Wols Lists
On 15/02/14 19:05, Chris Austin wrote: > I guessing could do all that.. OR have excel refresh the tables when u > connect... > > Maintaining separate tables just for ODBC is silly Some of us learnt the *hard* way that it's a GOOD idea to have separate dictionaries. HyperStar wasn't the most bug-

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Buss, Troy (Contractor, Logitek Systems)
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Saturday, February 15, 2014 11:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC - Not finding the MV fields. We have a ton of I descriptors and it's quick when u set the option to refresh in e

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Chris Austin
We have a ton of I descriptors and it's quick when u set the option to refresh in excel.. How many I descriptors do u gave? > From: troy.b...@nordsonasymtek.com > To: u2-users@listserver.u2ug.org > Date: Sat, 15 Feb 2014 13:21:37 -0500 > Subject: Re: [U2] ODBC - Not finding the

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Chris Austin
I guessing could do all that.. OR have excel refresh the tables when u connect... Maintaining separate tables just for ODBC is silly > From: troy.b...@nordsonasymtek.com > To: u2-users@listserver.u2ug.org > Date: Sat, 15 Feb 2014 13:21:37 -0500 > Subject: Re: [U2] ODBC - Not fi

Re: [U2] ODBC - Not finding the MV fields.

2014-02-15 Thread Buss, Troy (Contractor, Logitek Systems)
a few moments to flag the field and subsequently test with MS access. -Troy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, February 14, 2014 12:32 PM To: 'U2 Users List' Subject

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Bill Brutzman
Subject: Re: [U2] ODBC - Not finding the MV fields. Bill, Not sure why you would do those 6 steps, when running HS.UPDATE.FILEINFO from a command line or program will do the same thing (reset the cache w the updated tables). I like to limit the amount of dictionary entries I have. Chris

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Chris Austin
-users@listserver.u2ug.org > Date: Fri, 14 Feb 2014 12:37:29 -0500 > Subject: Re: [U2] ODBC - Not finding the MV fields. > > Chris: > > 1. For things here, I usually create a new DICTionary... copy the old DICT > to the new DICT... and strip out NAME and other DICT columns not needed b

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Bill Brutzman
Chris: 1. For things here, I usually create a new DICTionary... copy the old DICT to the new DICT... and strip out NAME and other DICT columns not needed by ODBC... in the new DICT. 2. A @SELECT of type PH is needed where the Phrase needs to specify the chosen fields... in the new DICT 3. LOGTO H

Re: [U2] ODBC - Not finding the MV fields.

2014-02-14 Thread Chris Austin
I found the answer in case anyone stumbles upon this. In Excel, under "UniVerse ODBC Data Source Setup" there's a radio button that's defaulted to "Fast Connect (Old OTL)". This was the problem.. When you bring MultiValue fields into ODBC it treats them like tables and you need to have refresh

Re: [U2] ODBC Errors 81001/81002

2013-03-25 Thread Anthonys Lists
On 25/03/2013 16:47, Kevin King wrote: Please forgive the response to my own post. The problem appears to be the log files that are being created by the UniRPC daemon. The users have a mix of umask settings and this is leaving log files around (millions of 'em) that aren't overwritable due to u

Re: [U2] ODBC Errors 81001/81002

2013-03-25 Thread Kevin King
Please forgive the response to my own post. The problem appears to be the log files that are being created by the UniRPC daemon. The users have a mix of umask settings and this is leaving log files around (millions of 'em) that aren't overwritable due to umask settings. Clearing the log files ap

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Allen Egerton
f the steps (even so far as casing on a windows > box which is normally case insensitive). > > Good luck! > Colin > > -Original Message- > From: Allen Egerton > Sent: March 16, 2012 11:07 AM > To: U2 Users List > Subject: Re: [U2] odbc error "Unable to

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Colin Alfke
ows box which is normally case insensitive). Good luck! Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 11:07 AM To: U2 Users List Subject: Re: [U2] odbc error "Unable to get UCI configuration file from Registry" Hi Colin, Sorry, I wish it was that simple.

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Allen Egerton
Hi Colin, Sorry, I wish it was that simple. After I went through the exercise a couple of times, I got our tech support involved. He's done at least several dozen of these installs, (if not more), and he couldn't resolve it either. We've opened a ticket with Rocket, I figured I'd try here becau

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Colin Alfke
Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI config file editor I have options to "Get Registry" and "Reset Registry" under File. Perhaps that will help hth Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 10:29 AM To: .U2 List Subject: [

Re: [U2] ODBC, record IDs, I- Descriptors, and stuff

2010-12-29 Thread Jeff Schasny
Tried that, didn't work. I get the sales order on the first row of the sub table but all the rest are blank. So... I ended up writing a subroutine which generates an array of MV sales order IDs equal to the number of multivalued sku's in the item and calling that from an I-descriptor. Visual

Re: [U2] ODBC, record IDs, I- Descriptors, and stuff

2010-12-29 Thread Gerd Forthmann
I sometimes use an I-descriptor to create a composite key in a sub-table made up from the Id of the mv-record and the position of the values in the array. i.e 123456*1 for the first set of values and 123456*2 for the second and so on. That way I get a unique key for every row. Or you could of co

Re: [U2] ODBC, record IDs, I- Descriptors, and stuff

2010-12-28 Thread Wols Lists
On 28/12/10 20:27, Jeff Schasny wrote: > I have a sales order file which I am accessing via UniObjects in a MS > Visual Studio application. I would like to populate a data bound > ListView control in the application with the multivalued sku, > description, size and quantity for a given sales order

Re: [U2] ODBC @ID Alias

2010-08-28 Thread Mecki Foerthmann
stserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry > Sent: Friday, August 27, 2010 5:54 PM > To: U2 Users List > Subject: Re: [U2] ODBC @ID Alias > > To use the dictionary in any of the SQL environments you should use a clean > dictionary that doesn

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Wols Lists
On 28/08/10 00:23, Bill Brutzman wrote: > Thanks Jerry... > > I have not tried it yet to see how ODBC, JDBC, SQL handles VM. Advance info > would be appreciated. One other point, I've forgotten what it's called ... what's the new connection technology? It might be OleDB, but anyway, ODBC is now

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Wols Lists
On 27/08/10 23:51, Jeff Schasny wrote: > I like the separate directory thing because then all of your ODBCized > stuff is in the same place and you are not cluttering up your > production dictionaries. I'm pretty sure I have an "A" type to "D" > type conversion program which which cleans up ODBC u

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Bill Brutzman
PM To: U2 Users List Subject: Re: [U2] ODBC @ID Alias To use the dictionary in any of the SQL environments you should use a clean dictionary that doesn't have any characters that would break SQL. This can be done by creating a separate field just used for SQL with no characters that will

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Bill Brutzman
Thanks Jeff -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, August 27, 2010 6:51 PM To: U2 Users List Subject: Re: [U2] ODBC @ID Alias Your basic VOC file pointer Unix world: 001:F 002

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Jeff Schasny
like this separate idea. What would an example pointer thing look like? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, August 27, 2010 6:04 PM To: U2 Users List Subject: Re: [U2] O

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Bill Brutzman
: Re: [U2] ODBC @ID Alias I'll second the recommendation for ODBC only dictionaries. I would even suggest you create a separate account with pointers to the data and keep all your ODBC dictionaries there. Wols Lists wrote: > On 27/08/10 21:55, Bill Brutzman wrote: > >> 1. T

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Bill Brutzman
Thanks Wol... I appreciate it. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, August 27, 2010 5:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC @ID Alias On 27/08/10

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Jeff Schasny
tserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, August 27, 2010 2:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC @ID Alias On 27/08/10 18:35, Bill Brutzman wrote: Is there a way to create an ODBC synonym for "@ID" ( l

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Jerry
dictionary items and replace the dot there with say an underscore? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, August 27, 2010 2:23 PM To: u2-users@listserver.u2ug.org Subject: Re:

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Wols Lists
just clutters your dictionary :-( Cheers, Wol > --Bill > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Friday, August 27, 2010 2:23 PM > To: u2-users@listserver.u2ug.org >

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Bill Brutzman
ce the dot there with say an underscore? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, August 27, 2010 2:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC @ID Alias On

Re: [U2] ODBC @ID Alias

2010-08-27 Thread Wols Lists
On 27/08/10 18:35, Bill Brutzman wrote: > Is there a way to create an ODBC synonym for "@ID" ( like just "ID")... > dropping the "@" character ? Thus, an external an ODBC SELECT statement > would show the column heading as "ID" instead of "@ID". > > The wizard .cfc code generator with the new C

Re: [U2] ODBC Connection Error

2009-09-15 Thread John Castilletti
error message. Also Tried logging in as root and rootuv to no avail either. Any Help with this would be greatly Appreciated. Thanks, John From: Brian Leach To: U2 Users List Sent: Tuesday, September 15, 2009 2:02:19 PM Subject: Re: [U2] ODBC Conn

Re: [U2] ODBC Connection Error

2009-09-15 Thread Brian Leach
Hi John Unfortunately that error just means an RPC connection error, which doesn't give much to go on.. Any context you can provide for this? Brian > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > John Ca

Re: [U2] ODBC to UPS WorldShip

2009-07-17 Thread Support
ypress Business Solutions 678.494.9353 x1410 supp...@cypressesolutions.com www.cypressesolutions.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glen B Sent: Friday, July 17, 2009 10:10 AM To: U2 Users List Subject: R

Re: [U2] ODBC to UPS WorldShip

2009-07-17 Thread Glen B
Tony G wrote: I concur with Glen's assessment that some of these services can be unstable. Not long after writing NebulaShip (nospamNebula-RnD.com/products/ship.htm) I realized that even though the product was stable that we might be getting emergency calls when services were down. I stopped ad

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread Tony G
I concur with Glen's assessment that some of these services can be unstable. Not long after writing NebulaShip (nospamNebula-RnD.com/products/ship.htm) I realized that even though the product was stable that we might be getting emergency calls when services were down. I stopped advertising the pr

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread Glen Batchelor
.com Blog: http://blog.all-spec.com > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill > Sent: Thursday, July 16, 2009 11:20 AM > To: U2 Users List >

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread John Hester
> -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > Brutzman, Bill > Sent: Thursday, July 16, 2009 8:20 AM > To: U2 Users List > Subject: Re: [U2]

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread Garry Smith
16, 2009 8:20 AM To: U2 Users List Subject: Re: [U2] ODBC to UPS WorldShip UniVerse ODBC Client Version 4.0.3 Build 7251 February, 2008 on both PC's We are not SHIMS. We are not Prelude. This may be a lost cause. Perh

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread Steve Romanow
ia an external program talking to the UPS database. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, July 15, 2009 8:29 PM To: U2 Users List Subject: Re: [U2] ODBC to UPS WorldShip I

Re: [U2] ODBC to UPS WorldShip

2009-07-16 Thread Brutzman, Bill
ng to the UPS database. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, July 15, 2009 8:29 PM To: U2 Users List Subject: Re: [U2] ODBC to UPS WorldShip I am in the process of

Re: [U2] ODBC to UPS WorldShip

2009-07-15 Thread Steve Romanow
I am in the process of doing this right now. What version of the ibm odbc driver do you have installed? My var warned me against one version, but they didn't elaborate why. Are you a SHIMS or Prelude shop? -Original Message- From: Brutzman, Bill Sent: Wednesday, July 15, 2009 7:47 PM

RE: [U2] ODBC Connection to Universe on HP-UX

2009-03-06 Thread David Wolverton
-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach > Sent: Friday, March 06, 2009 5:24 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] ODBC Connection to Universe on HP-UX ... Snip... > Ironically one of the additions to OleDB was

RE: [U2] ODBC Connection to Universe on HP-UX

2009-03-06 Thread Brian Leach
Henry Yes, there are! ODBC is slow - designed for compatibility not performance. OleDB is, in theory at least, at little quicker since it is a leaner protocol: ODBC was designed to present a common and highly rigid/specified view of a database, and as a result it is generally considered a little

RE: [U2] ODBC Connection to Universe on HP-UX

2009-03-06 Thread Symeon Breen
You say changing - changing from what ? Personally I would only ever use ODBC if I really had to and then only for reporting. If you want to do anything interactive I would use uniobjects either as .net or for java - or use some intelligence above that layer like the ibm ado providers, U2.NET or

Re: [U2] ODBC Connection to Universe on HP-UX

2009-03-05 Thread Stephen O'Neal
Henry, The ODBC connection is the slowest connection into the U2 product line. If the application will not have a lot of users on it, ODBC will be fine. But, ODBC will not scale if you have numerous connections. Steve O'Neal U2 Lab Services Sales Specialist,IBM Data Management, IB

RE: [U2] ODBC Connection to Universe on HP-UX [ad]

2009-03-05 Thread Tony G
From: Henry.Martel > We are thinking of changing our application connect to > Universe through ODBC connections. Has anyone had > experience doing this? Are there any performance > issues or considerations that we need to be aware of? One of our clients was using ODBC with Universe and got int

Re: [U2] ODBC Connection to Universe on HP-UX

2009-03-05 Thread Anthony W. Youngman
In message <291595756f51e34ea52a45b3a191dae3f5b...@anorpexbe01.auca.corp>, "Martel, Henry" writes We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? OleDB or ODBC? Are there any performance issues or consideration

RE: [U2] ODBC Connection to Universe on HP-UX

2009-03-05 Thread Garry Smith
We have noticed that the first connection of the day takes longer then subsequent reads. We use ODBC for reads only. We created a separate UV account with scaled down dictionaries that have I-descriptors with UV basic code to extract the Multi-value fields and format as need for our application. T

RE: [U2] ODBC setup error

2009-02-27 Thread u2ug
server.u2ug.org] On Behalf Of Anthony W. Youngman > Sent: February 27, 2009 12:07 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] ODBC setup error > > In message <47c1b98393896f41a7bfe435442394e510f...@gmsdc.gerzio.ca>, > u2ug writes > >We have an account setup to

RE: [U2] ODBC setup error

2009-02-27 Thread u2ug
g [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman > Sent: February 27, 2009 12:07 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] ODBC setup error > > In message <47c1b98393896f41a7bfe435442394e510f...@gmsdc.gerzio.ca>, > u2ug writes &g

Re: [U2] ODBC setup error

2009-02-27 Thread Anthony W. Youngman
In message <47c1b98393896f41a7bfe435442394e510f...@gmsdc.gerzio.ca>, u2ug writes We have an account setup to allow odbc access to specific files. We added access to a new file and ran HS.UPDATE.FILEINFO which processed a few files but then aborted the session with that old standard : Abnormal

Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-05 Thread Kevin King
RESOLVED: I turned on tracing in the ud_database file and the problem was immediately obvious. The SQL command being invoked by WorldShip included a field that was calling a BASIC subroutine. This subroutine had been written by the vendor and used a common block of open files that is normally ini

RE: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-04 Thread Anthony Youngman
t: 04 August 2008 15:41 To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch I have no idea what the SQL is being sent from Worldship. That could possibly be valuable

Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-04 Thread Kevin King
I have no idea what the SQL is being sent from Worldship. That could possibly be valuable, but I don't have access to that level of information right now. But an interesting question, no doubt. On Sun, Aug 3, 2008 at 10:14 AM, Anthony W. Youngman < [EMAIL PROTECTED]> wrote: > In my case, the SQ

Re: [U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-03 Thread Anthony W. Youngman
In message <[EMAIL PROTECTED]>, Kevin King <[EMAIL PROTECTED]> writes Any ideas what this message means? ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch S1000 - nasty ... I'm assisting with connecting Uni

Re: [U2] ODBC error

2007-10-23 Thread Jeff Schasny
blish the changes. > > Cheers, > Wol > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny > Sent: 23 October 2007 14:54 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] ODBC error > > The connectivity tests i

RE: [U2] ODBC error

2007-10-23 Thread Mark Eastwood
? HS.UPDATE.FILEINFO -Original Message- If you did that, in that order, then the answer's simple. You need to update the cache AFTER updating HS_FILE_INFO. Can't remember the name of the command, but it's something like you need to run HS.UPDATE in the same account as HS_FILE_INFO in orde

RE: [U2] ODBC error

2007-10-23 Thread Anthony Youngman
s. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: 23 October 2007 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error The connectivity tests in Universe ODBC setup work fine for all data sources. This is a new insta

Re: [U2] ODBC error

2007-10-23 Thread Jeff Schasny
t; server. BTW...has it ever worked? > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny > Sent: Monday, 22 October 2007 11:32 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] ODBC error > > UV 10.0.10 and ODBC drive

RE: [U2] ODBC error

2007-10-22 Thread Tony G
From: Ray Wurlod > For some arcane reason best known to Microsoft and not revealed > to the great unwashed... I've blogged some notes on this largely OT subtopic. http:// removepleaseNebula-RnD.com/blog/tech/2007/10/sql-with-excel01.html HTH Tony Gravagno Nebula Research and Development TG@ r

RE: [U2] ODBC error

2007-10-22 Thread Hona, David S
any other service on your server. BTW...has it ever worked? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Monday, 22 October 2007 11:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error UV 10.0.10 and ODBC driver 3.

Re: [U2] ODBC error

2007-10-22 Thread Ray Wurlod
Excel is different. To get a list of tables from Excel you must specify that you want to retrieve system tables. For some arcane reason best known to Microsoft and not revealed to the great unwashed, Excel worksheets are reported to the ODBC driver as system tables (and therefore get their nam

Re: [U2] ODBC error

2007-10-22 Thread Jeff Schasny
UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: > What are UV server and client releases? > > Ca

RE: [U2] ODBC error

2007-10-19 Thread Hona, David S
What are UV server and client releases? Can you get a list of files from the built-in "demo" accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Saturday, O

RE: [U2] ODBC drivers on RedHat Linux [ad]

2007-08-23 Thread Janet Bond
ECTED] Sent: Thursday, August 23, 2007 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux [ad] 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 fro

RE: [U2] ODBC drivers on RedHat Linux [ad]

2007-08-23 Thread Jerry Banker
st 23, 2007 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux [ad] 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

RE: [U2] ODBC drivers on RedHat Linux [ad]

2007-08-23 Thread Janet Bond
:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux 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

RE: [U2] ODBC drivers on RedHat Linux

2007-08-23 Thread Jerry Banker
@listserver.u2ug.org Subject: Re: [U2] ODBC drivers on RedHat Linux Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price <[EMAIL PROTECTED]> wrote: > Does anyone know of an ODBC driver that plays nice with L

Re: [U2] ODBC drivers on RedHat Linux

2007-08-22 Thread Andy Pflueger
Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price <[EMAIL PROTECTED]> wrote: > Does anyone know of an ODBC driver that plays nice with Linux. We > currently have an evaluation copy of DataDirect 5.

RE: [U2] ODBC error via SQLSERVER linked server

2007-07-30 Thread Noah Hart
Permissions are OK, all other selects work fine Runs OK from ECL Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Monday, July 30, 2007 4:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC error via SQLSERVER linked

RE: [U2] ODBC error via SQLSERVER linked server

2007-07-30 Thread John Jenkins
Noah Do you have the right permissions for the User ID you are using? (Check the schema permissions using VSG). Are you able to Insert or Modify? If no updates are possible is it a view or a sub-table? Lastly - log in as the user you are using at ECL and run your statement at ECL from the SQL pr

RE: [U2] ODBC: database does exist

2006-11-01 Thread Wang, Cody
: 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 ---

RE: [U2] ODBC: database does exist

2006-11-01 Thread Robert Paterson
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]

RE: [U2] ODBC Error {Unclassified}

2006-07-18 Thread HENDERSON MIKE, MR
Al, For what it's worth ... >CT SYS.MESSAGE 081001 081001 0001 unirpc: Bad Connection 0002 > Not very helpful, I'm afraid Mike > -Original Message- > From: [EMAIL PROTECTED] On Behalf Of Al DeWitt > Sent: Wednesday, 19 July

RE: [U2] ODBC Error

2006-07-18 Thread Amy Cook
Al, Is it possible that you lost network connectivity between the client executing the query, and the unidata server, during the query? I'm responding from memory, so I could be off, but I'm thinking this might be the culprit. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

RE: [U2] ODBC to Open Office

2006-07-13 Thread John Jenkins
Albert I believe OpenOffice uses JDBC for this. I had a play with it a while back (well over a year) but didn't really get anywhere as I was not familiar enough with OpenOffice configuration in this area and found the OpenOffice documentation at the time poor at best. If I find some time I'll ta

RE: [U2] ODBC question [ad]

2006-06-12 Thread Tony Gravagno
Angelo Collazo wrote: > After researching the data extraction from an SQL database via > UniData/BCI running on AIX I have realized that a third party ODBC > driver is needed for UNIX to behave like a client. An install > document called "How to set up the Easysoft ODBC-ODBC Bridge with > UniData w

RE: [U2] ODBC question

2006-06-12 Thread Angelo Collazo
't re-installed correctly. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, June 08, 2006 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Do

RE: [U2] ODBC question

2006-06-08 Thread colin.alfke
What version of UD are you running? Does version show it as licensed? Try a new password, I've had trouble with passwords that "unusual" characters, including basic punctuation marks. A long time ago, I also needed to get an updated .dll from IBM. That was early in the 5? Days. Hopefully, your sy

RE: [U2] ODBC question

2006-06-08 Thread Dana Baron
correctly. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, June 08, 2006 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Do you have a license to us

RE: [U2] ODBC question

2006-06-08 Thread Marc Harbeson
Do you have a license to use ODBC? Or Is your UniData licensed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Thursday, June 08, 2006 8:11 AM To: U2-Users Subject: [U2] ODBC question Hi, While we're talking Unidata ODBC... I'm havi

Re: [U2] ODBC UniAdmin UniData - "No RPC connection active."

2006-03-22 Thread u2
[EMAIL PROTECTED] wrote: > Morning, > > I am trying to connect to a Unix server through ODBC. When I start up UniAdmin > I get a message that "No RPC connection active." > > Does anyone know what I need to do to correct this? > You haven't been "clever" and changed the install location for UniAd

Re: [U2] odbc

2006-03-10 Thread John Hester
Bob Witney wrote: In Universe 10.1.14 it isn't :CONNECT sql2 Enter username for connecting to 'sql2' DBMS [root]: tlogtest Enter password for tlogtest: SQLConnect error: Status = -1 SQLState = IM976 Natcode = -1

Re: [U2] ODBC Redux

2006-01-17 Thread Don Kibbey
Sir, I'm shocked you've managed to keep a windoze machine running for so long! On 1/16/06, Ray Wurlod <[EMAIL PROTECTED]> wrote: > Get some time up! My Registry also has HKLM\VMARK (for HyperSTAR) and > HKLM\Ardent. I'll clean it out one day! > --- > u2-users mailing list > u2-users@listser

RE: [U2] ODBC Redux

2006-01-16 Thread Kevin King
The driver is from the Udt6 clients download (from about a year ago). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Horwitz Sent: Monday, January 16, 2006 1:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Redux What Client CD did

Re: [U2] ODBC Redux

2006-01-16 Thread Ray Wurlod
- Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC Redux Date: Mon, 16 Jan 2006 13:41:32 -0600 > > Sounds like it to me. > > - Original Message - From: "Kevin King" <

Re: [U2] ODBC Redux

2006-01-16 Thread Ray Wurlod
Get some time up! My Registry also has HKLM\VMARK (for HyperSTAR) and HKLM\Ardent. I'll clean it out one day! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Redux

2006-01-16 Thread Steven Horwitz
What Client CD did you get your ODBC driver from? IBM UniData driver 3.01.05.7073 from the UniData Client 6b CD is okay. Steven Horwitz Pelican Professional Services (626) 675-8459 www.pelicansvcs.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [U2] ODBC Redux

2006-01-16 Thread Jerry Banker
Sounds like it to me. - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> To: Sent: Monday, January 16, 2006 12:27 PM Subject: [U2] ODBC Redux Pursuant to my ODBC issues of last week, I installed regmon on one of the machines with the problem and wouldn't you know it: The cu

RE: [U2] ODBC Difficulties

2006-01-12 Thread Kevin King
BRILLIANT! Thanks Simon (for regmon)! This should be very useful. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] ODBC Difficulties

2006-01-12 Thread Simon Lewington
"Kevin King"... > I am having some difficulties getting the Unidata ODBC driver to work > properly. ... > I have verified the registry settings per the > ODBC documentation, verified the location and contents of uci.config, > and verified the ODBC configuration settings. Still, when trying to > co

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
Thanks for the heads up, I do appreciate all the different ideas about this ODBC problem, but the uid and pw are both letters and numbers, no symbols. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Difficulties

2006-01-11 Thread colin.alfke
That's right - I also had a problem with a user that had a password with a symbol in it. I don't recall which - I think it was just the "$". Colin >-Original Message- >From: robert dunnmiller > >I encountered an issue with ODBC connectivity, very similar to >what you are reporting. The

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
Thanks Robert. The user ID is currently 4 characters and the password is currently 7. -k --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Difficulties

2006-01-11 Thread [EMAIL PROTECTED]
issues were resolved. Just my $.02. Regards, Robert Original Message: - From: Kevin King [EMAIL PROTECTED] Date: Wed, 11 Jan 2006 06:25:17 -0700 To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Difficulties I forgot to mention that I'm using the same user ID on

RE: [U2] ODBC Difficulties

2006-01-11 Thread colin.alfke
Rats, that was my best guess - unless it's some kind of "domain" type issue. (I don't give up easy do I?) Which version of the driver are you using? There were different drivers with the 6.0a and 6.0b client CD's, I might have even gotten a patched one from IBM. I always use the System DSN. I thi

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
I forgot to mention that I'm using the same user ID on both systems, so it would seem that it's not the privilege file. Also, the fact that the errors get returned immediately - as if it doesn't even make an effort to connect - makes me think something is amiss with the driver. There should be no

RE: [U2] ODBC Difficulties

2006-01-10 Thread colin.alfke
Could be. I've had some strange experiences with some of the ODBC clients. Like it working for Excel but not Access. I'd also check the privilege file. It seems that sometimes VSG (I'm guessing - but it's the only thing that seems remotely reasonable) changes the OS permissions on the file. Not sur

RE: [U2] ODBC Difficulties

2006-01-10 Thread Kevin King
Yeah, Colin... I have the ODBC working here with my XP client (over VPN) with no difficulties whatsoever, which is why the whole thing seems like a version conflict. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

  1   2   >