PowerHouse and ODBC drivers - case sensitivity

[Ron Olenic]

Hi Bob!

I have been toying with the idea of getting an ODBC driver to access
subfiles on the UNIX machine.  Which of those three (if any) would be your
choice.  On the HP, there were a couple of ODBC drivers that were able to
read the PowerHouse Dictionary.  Have you run across an ODBC driver for UNIX
that could perform that little task?

Ron Olenic
Senior Systems Analyst

-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Thursday, April 12, 2001 3:20 PM
To: 'powerh-l@list.swau.edu'
Subject: PowerHouse and ODBC drivers - case sensitivity


G'day all

We have been wasting our time getting PowerHouse 8.21D4 to work with three
different ODBC drivers in system (Windows NT 4sp6).  The drivers are MS SQL
Server, CONNX 8.01 (RMS) and HitODBC 400 (DB/400).  We eventually got PH to
work ok with all the drivers but we found out these idiosyncrasies:

1. MS SQL Server 7.0 - case of ODBC reference in the PDC must match EXACTLY
with the definition in the ODBC Data Sources and you should have these
sources defined in BOTH the user and system DSN windows.  We found that
sometimes just the system DSN definition would work and sometimes it
wouldn't but the user DSN definition always worked.  Problem is, other
software (e.g. Impromptu) requires the system DSN so you have to have both
definitions.

2. CONNX - case of ODBC reference in the PDC must match EXACTLY with the
definition in the ODBC Data Sources and but you only need these sources
defined the system DSN window.  User DSN won't work.

3. HitODBC - case of ODBC reference in the PDC doesn't matter.  However the
case of the library references does.  Only upper case worked for me.  Like
CONNX the definition in the ODBC Data Sources and but you only need these
sources defined the system DSN window.  User DSN won't work.

I hope my hair grows back soon!

Robert Edis
Manager - Business Intelligence
FleetPride 
520 Lake Cook Rd., Suite 100
Deerfield IL 60015
Tel: 847.572.8039
Fax: 847.444.1096
www.fleetpride.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.