On 7/13/07, Jeffrey Butera [EMAIL PROTECTED] wrote:
We may embark down the ODBC connectivity path with Unidata (7.1.8 on solaris
9). My understanding is that I need to get the UniData clients toolkit and,
in particular: UniODBC, the UniDK developer's Toolkit, and the Visual Schema
Generator.
Jeff
Please make sure your DICTionaries are accurate and reflect the date.
All Single values should be described as S, all Multi-Values should be
described as MVs and all sub-values should be described as MS
All associated MV and MS should be in Phrases - ideally all unassociated MVs
should
@listserver.u2ug.org
Subject: RE: [U2] UniData ODBC / Prompt for selection criteria
Do you mean you're trying to do an inline prompt through an ODBC
connection? You're a brave soul.
I would prompt for imput in the 3rd party client and pass the full
string through...
hth
Colin Alfke
-Original
, I get the error. If
I enter 2004 into the selection criteria itself, the query works.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin
Sent: Tuesday, January 18, 2005 9:54 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniData ODBC
Do you mean you're trying to do an inline prompt through an ODBC
connection? You're a brave soul.
I would prompt for imput in the 3rd party client and pass the full string
through...
hth
Colin Alfke
-Original Message-
From: Amy Cook
I know this issue has
fyi - we've encountered some problems with this on NT. If the user is a member
of the administrators group then all members of the administrators group are
deemed to be owners of the view and have full permissions. VSG just takes the
user that you logged in as.
It also appears to change the OS
. But...there's probably an option to do
so?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost
Sent: Tuesday, November 23, 2004 7:01 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Unidata Odbc
Thanks Amy. I was granting Select to Public on the SQL
Hi -- has anybody used a tool called ERWIN against unidata
( using ODBC). This is a database modelling-reverse engineering tool one of
our consultants is using to gain a graphical look at our schema.
The tool doesn't appear to be showing column names for the tables/views ,
although MS access
11:24 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Unidata Odbc
Hi -- has anybody used a tool called ERWIN against unidata
( using ODBC). This is a database modelling-reverse engineering tool one
of
our consultants is using to gain a graphical look at our schema.
The tool doesn't appear
Thanks Amy. I was granting Select to Public on the SQL tables , but not on the
views
maybe that could help. The consultant is pointing his ERWIN tool at MS access
,to show
the columns.
-Original Message-
Steven,
You will have had to first generate schema on your account to create the
SQL system files, views and privileges on them. I believe the import is
looking for objects in the SQLTables table (?) (which is created when
you generate schema).
If you've setup the server side access and
Thanks. All seems OK in VSG -- I can see the list of files and SQL tables
however the SQLTables file in the demo account is empty.
( /usr/ud52/demo)
Eureka... I created a few views from a table and these are now showing !
12 matches
Mail list logo
