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.
Chris:
1
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 finding the MV fields
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 MV fields.
I tend
...@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 excel.. How
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
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
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
@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 by
ODBC... in the new DICT.
2
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
From
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
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
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: [U2]
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
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. After I went through the exercise
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. After I went through
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
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.
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. I
...@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't have any characters that would break SQL.
This can be done by creating
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 ColdFusion
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 27/08/10
,
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
Subject: Re: [U2] ODBC @ID Alias
On 27/08/10 18:35, Bill Brutzman
-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 27/08/10 18:35, Bill Brutzman wrote:
Is there a way
[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 ( like just ID)... dropping
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
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. Thanks Wol
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] ODBC @ID Alias
I'll second
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
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 break
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
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
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
logging in as root and rootuv to no avail either.
Any Help with this would be greatly Appreciated.
Thanks,
John
From: Brian Leach br...@brianleach.co.uk
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, September 15, 2009 2:02:19 PM
Subject: Re: [U2
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
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: Re: [U2] ODBC to UPS
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 doing
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 am
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 am
-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] ODBC to UPS WorldShip
UniVerse
[mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
Sent: Thursday, July 16, 2009 11:20 AM
To: U2 Users List
Subject: Re: [U2] ODBC to UPS WorldShip
UniVerse ODBC Client
Version 4.0.3
Build 7251
February, 2008
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
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 bi...@hkmetalcraft.com
Sent:
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
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
[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 support for
chaptered rowsets - that's
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.
In message
291595756f51e34ea52a45b3a191dae3f5b...@anorpexbe01.auca.corp, Martel,
Henry henry.mar...@wearguard-crest.com 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
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 into a
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,
In message 47c1b98393896f41a7bfe435442394e510f...@gmsdc.gerzio.ca,
u2ug simpson-u...@gerzio.ca 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
: 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 simpson-u...@gerzio.ca writes
We have an account setup to allow odbc access to specific files.
We added access to a new file
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 simpson-u...@gerzio.ca writes
We have an account setup to allow odbc access to specific files.
We added access to a new
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
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 SQL
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
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
? 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
-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 installation
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?
Can
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
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.07.02.7013
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@
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,
@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 Linux. We
: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
, 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 a SQL
]
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 from SQL
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.3
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
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
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]
-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
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
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
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
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 use
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 was
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
.
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 use ODBC
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
[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 UniAdmin to
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
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
Sounds like it to me.
- Original Message -
From: Kevin King [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
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
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]
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/
- 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 [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent
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
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
connect
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/
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
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
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 both
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/
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
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/
I'm running w2kPro SP4 with ODBC driver version 3.01.04.7036 and I can
connect to both UD 6.0.12 and 5.1.27 (both on w2k) with it. I just
tested with Excel, Access, and the ODBC Query tool from
http://gpoulose.home.att.net/.
The only problem I had was my user id did not have write access on the
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/
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
Hi Kathy,
We get the same error if we try to browse
tables/views. I've just been living with it. Haven't
tried conditional queries - my jobs are only data
synchronization tasks.
Cheers!
Rick
--- Vance, Kathy [EMAIL PROTECTED] wrote:
I did the same thing in SQL 2000. I created a linked
1 - 100 of 125 matches
Mail list logo