Database type odbc....

[Mike Godsey]

We did ODBC for a while. There are lots of small details that must be working perfectly for the stars to align. Think of this as a two step process: PH to ODBC and then ODBC to the database. I recommend looking for an ODBC driver that works with Postgresql. The PH to ODBC should be standard interface. However, there my be unique data types available in the database that the ODBC driver cannot translate properly and thus you may have problems. It took me a lot of experimentation to get everything working well. 

Good Luck!
Mike Godsey 

Sent from Mail for Windows

From: Robert Deskin
Sent: Thursday, June 15, 2023 3:04 PM
To: Pierre Bouthillette
Cc: PowerHouse List
Subject: Re: Database type odbc....

Don’t know if this went through the first time.


On Jun 15, 2023, at 2:50 PM, Robert Deskin <bob.deskin at me.com> wrote:

I honestly don’t know. It’s been a very long time. Checking the supported environment document from 2012 says that ODBC is DataDirect 5.2 to MS SQL Server with additional support for DataDirect 5.3, 6.0, and 6.1 also to MS SQL Server.

I don’t recall whether anything else was ever tested nor whether any customers tried anything else. I also don’t know if the DataDirect driver is compiled in or can be changed, but I doubt it.

Maybe someone out there can provide a better answer.

Bob


On Jun 15, 2023, at 2:34 PM, Pierre Bouthillette <pierre.bouthillette at gmail.com> wrote:

Hi Bob

we have powerhouse on solaris
works fine with oracle
my client is looking to access database postgresql

i have a question about odbc type...
doc says odbc is working with ms sql server 
can we use another odbc driver instead ?
is powerhouse looking for a specific driver?

Thanks
Pierre


Virus-free.www.avast.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230615/5913dabc/attachment.html>