Axiant/Powerhouse on Server2008R2 - ODBC handling

Fri Nov 28 21:14:34 CST 2014

Are you able to connect to the ODBC connection using MS Access as an eternal
table?  That's the first test I do on Windows to see if the connection is
good. 

Here is an article that discusses this approach.

http://www.mcpressonline.com/application-software/microsoft/microsoft-comput
ing-accessing-iseries-data-with-odbc.html

Charles Finley

(619) 795-0720

From: powerh-l-bounces+cfinley=xformix.com at lists.sowder.com
[mailto:powerh-l-bounces+cfinley=xformix.com at lists.sowder.com] On Behalf Of
Bob Deskin
Sent: Friday, November 28, 2014 3:05 PM
To: Robert Thwaites; powerh-l at lists.sowder.com
Subject: RE: Axiant/Powerhouse on Server2008R2 - ODBC handling

Could this be a permissions issue? Something more subtle than simply a user
creating a user DSN? I have no idea where you would look, but Windows has
picked up more and more permission and security nuances over the years.

Is this a centralized database or a database local to his machine?

Bob Deskin
PowerHouse Consultant
UNICOM Global
bob.deskin at unicomglobal.com
(973) 526-3856

This message (including any attachments) contains confidential information
that is PRIVILEGED, CONFIDENTIAL and/or ATTORNEY WORK PRODUCT and is
intended only for the individual(s) named herein. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this email is strictly prohibited. If you have
received this message in error, please notify the UNICOM Systems, Inc.
Postmaster (postmaster at unicomsi.com) of the error immediately, do not read
or use the email and any attachments in any manner, destroy all copies, and
delete it from your system if the communication was sent via email. UNICOM
Systems, Inc. (818) 838-0606 Fax: (818) 838-0776

-----Original Message-----
From: Robert Thwaites [mailto:robert.thwaites at sewardconsulting.com]
Sent: Fri 11/28/2014 5:58 PM
To: Bob Deskin; powerh-l at lists.sowder.com
Subject: RE: Axiant/Powerhouse on Server2008R2 - ODBC handling

I am not surprised you don't recall, since it has been more than 2 years
since we last talked.  Back in February of 2012 I had a series of IBM PMR's
with you where I first indicated that we use System DSN's at our customer's
site to avoid the need to setup and maintain multiple User DSN's - one for
each end user.

On my development server, I had my developer create a User DSN for himself.
I then dropped the System one (visible to anyone on the box).  When he ran
our application, it could no longer see the database.

Robert Thwaites

Seward Consulting

(780) 426-4876

Mobile (780) 231-0067

 <mailto:robert.thwaites at sewardconsulting.com>
robert.thwaites at sewardconsulting.com

From: Bob Deskin [mailto:bob.deskin at unicomglobal.com]
Sent: Friday, November 28, 2014 3:25 PM
To: Robert Thwaites; powerh-l at lists.sowder.com
Subject: RE: Axiant/Powerhouse on Server2008R2 - ODBC handling

I'm using a User DSN for SQL Server. My user is an  Administrator. I've
never heard of the type of DSN being stored but I'm not an expert on all the
internals. A user DSN should be visible to the user who created it on the
machine where it was created.

Bob

Bob Deskin

PowerHouse Consultant

UNICOM Global

bob.deskin at unicomglobal.com

(973) 526-3856

This message (including any attachments) contains confidential information
that is PRIVILEGED, CONFIDENTIAL and/or ATTORNEY WORK PRODUCT and is
intended only for the individual(s) named herein. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this email is strictly prohibited. If you have
received this message in error, please notify the UNICOM Systems, Inc.
Postmaster (postmaster at unicomsi.com) of the error immediately, do not read
or use the email and any attachments in any manner, destroy all copies, and
delete it from your system if the communication was sent via email. UNICOM
Systems, Inc. (818) 838-0606 Fax: (818) 838-0776

From: powerh-l-bounces+bob.deskin=unicomglobal.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=unicomglobal.com at lists.sowder.com] On
Behalf Of Robert Thwaites
Sent: Friday, November 28, 2014 5:11 PM
To: powerh-l at lists.sowder.com
Subject: Axiant/Powerhouse on Server2008R2 - ODBC handling

Axiant/Powerhouse Handling for ODBC entries:
I recently tried changing from System DSN to User DSN and once I removed the
obsoleted System DSN I ended up with programs not seeing the database.
Do the compiled programs end up containing an indication of which type of
DSN is being used?
The dictionary itself doesn't appear to provide any syntax for picking what
type of DSN is being used, it just contains the name of the ODBC entry.

Robert Thwaites

Seward Consulting

 <mailto:robert.thwaites at sewardconsulting.com>
robert.thwaites at sewardconsulting.com

This e-mail message has been scanned and cleared by Postini / Google Message
Security and the UNICOM Global security systems. This message is for the
named person's use only. If you receive this message in error, please delete
it and notify the sender.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20141128/8bfa30ec/attachment-0001.htm>