Axiant/Powerhouse on Server2008R2 - ODBC handling

[Robert Thwaites]

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/a734704e/attachment-0001.htm>