RE: [U2] UniData ODBC and Vista
I asked IBM a similar question ... The client tools are certified at the same level as the server, so if the server is certified to run on Vista, so will the tools. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 04 December 2008 16:22 To: u2-users@listserver.u2ug.org Subject: [U2] UniData ODBC and Vista Hi All Does anyone know whether the latest ODBC drivers for UniData will work under Vista? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata ODBC
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 have their own PHrase. Don't have DICTionary entries you don't want (makes both speed and VSG so much easier - "Add All."). I set up a separate account for ODBC access (by group of users) with separate DICTionaries for ODBC accessible files and pointers to the live data level (only) files. Create you DICTionary entries here, not in the live dictionary file (unless you are VERY unusual and only have "clean" dictionaries (I've never seen it). All names should be SQL compatible (no periods or "@"s, etc - VSG will do this for you but again I like to have control). If you change the dictionary drop the schema first and then recreate it afterwards. Save the SQL used to create each schema from VSG - put it in paragraphs in case of need. Create all schemas using a HAT (functional user) not an individual user name. Whoever creates them owns them - and you do not want that user id deleted. Regards JayJay -Original Message- From: Jeffrey Butera 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. Can anyone confirm this, and how/where I obtain these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, -- Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata ODBC
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. Can anyone confirm this, and how/where I obtain these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Hi Jeff, The first place to start would be contact [EMAIL PROTECTED] to submit a product procurement request. This is the same method you'd go through for obtaining the Unidata 7.1.8 server media. I recently submitted an e-mail 2 days ago for the latest Unidata 7.1.8 Client Tools and received an FTP link where I could download the server, docs, and client media ZIP files. :-) Regards, Andy Pflueger Ivy Hill Corp. Louisville, KY --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata ODBC
These are all on the client CD. It is in the trials/demos section but these products are "included" so there is no trial/demo version - it is the full version. Download the clients, they are the same for both UniData and UniVerse (I think it says UniVerse on the download). It is the large one. Hth Colin Alfke Calgary, Canada -Original Message- From: Jeffrey Butera 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. Can anyone confirm this, and how/where I obtain these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, -- Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData ODBC / Prompt for selection criteria
Just to let everyone know, this is a bug. It was reported to IBM back in 2002, and it's still not fixed. They now have a new eCase for it, 7477, which is apparently in 'Advanced Tech Support' awaiting prioritization, etc... If this is something you might like to do (a fairly standard request for a query design), please let IBM or your VAR know--I imagine the more interest that's shown, the more priority that will be placed on the eCase. Thanks, Amy -Original Message- From: Amy Cook Sent: Wednesday, January 19, 2005 7:22 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Sorry, no I mean that I'm prompting from the 3rd party client. (i.e. in MSAccess, the selection criteria is [Please enter the fiscal year] ...or something to that effect... which would bring up the dialog box for the person running the query. In that example, if I enter 2004 in the dialog box, 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 / Prompt for selection criteria Do you mean you're trying to do an <> 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 been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData ODBC / Prompt for selection criteria
Sorry, no I mean that I'm prompting from the 3rd party client. (i.e. in MSAccess, the selection criteria is [Please enter the fiscal year] ...or something to that effect... which would bring up the dialog box for the person running the query. In that example, if I enter 2004 in the dialog box, 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 / Prompt for selection criteria Do you mean you're trying to do an <> 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 been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData ODBC / Prompt for selection criteria
Do you mean you're trying to do an <> 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 been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
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 permissions on the privilege file if another user updates a view. This causes most calls to fail. Colin Alfke In sunny - but still chilly - Calgary >-Original Message- >From: Amy Cook >Sent: Wednesday, November 24, 2004 8:08 AM > > >Yeah...the frustrating part (for me anyways) is managing the >privileges. >Try on the views, hopefully that will doit. >Or...what we've ended up doingis generating the schema as a generic >user (we created a unix account called sqlmgr) then when we deliver an >access database, the password is saved. Anyone creating queries will >login via odbc as sqlmgr. > >Just so you know, if you wish to do that now, I believe you'll need to >cleanup the schema then regenerate as the generic user (so everything's >owned by the same person). I'm not sure how you do that in vsg...i >don't have it loaded right now. But...there's probably an option to do >so? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
Yeah...the frustrating part (for me anyways) is managing the privileges. Try on the views, hopefully that will doit. Or...what we've ended up doingis generating the schema as a generic user (we created a unix account called sqlmgr) then when we deliver an access database, the password is saved. Anyone creating queries will login via odbc as sqlmgr. Just so you know, if you wish to do that now, I believe you'll need to cleanup the schema then regenerate as the generic user (so everything's owned by the same person). I'm not sure how you do that in vsg...i don't have it loaded right now. 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 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- # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
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- # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
Hi Steven, I've never used ERWIN, and we actually generate our schema through our application which calls the schema API that VSG does, so I'm a little sketchy on the exact details as they happen through VSG hopefully you'll get a better answer back from the rest of the group. But...I think when you create the schema through VSG, you're telling the schema API what fields to include in the 'new' SQL table dictionary. Those fields you've chosen to include are placed in a new dictionary with the given table name (let's say you have a file called CUSTMASTER in UniData, and you include F1 - F10 in a SQL table called CUSTOMER). This actually creates a new VOC entry called CUSTOMER, pointing to the original data file CUSTMASTER, and the new dictionary D_CUSTOMER. You then create the view on this table, which you report off of. I believe it's when you create the view(s) that you create the SQLColumns table (happens automatically through VSG), which is probably where ERWIN is looking for it's metadata. (verify that w/ the consultant?) It's either that, or the dictionary items of the tables that come up in SQLTables. (However, if that's the case, it's probably a function of the UniData ODBC driver, so ERWIN shouldn't have to do anything different from the front end then MSAccess is doing.) The other thing I'd check...if you created the schema logged into the database as yourself, then you'd have to grant privilege on any views that you want the consultant to have access to (unless he's logging in as the same user you created the schema as). You do that thru VSG as well. This is SQL privilege, not your unix permissions... HTH, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 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 to be showing column names for the tables/views , although MS access can see the column names. Any thoughts? Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received
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 to be showing column names for the tables/views , although MS access can see the column names. Any thoughts? Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
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 ! # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
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 installed the odbc driver on your workstation, also install Visual Schema Generator (VSG) from the client cd, and connect with that. The VSG pdf will give you a good overview Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/