Here's my working Greenplum ODBC.ini (modified from the sample one that shipped with DataDirect) - note that I only needed to change 3 parameters:
- Database
- HostName
- PortNumber
[Greenplum]
Driver=/app/Progress/DataDirect/Connect64_for_ODBC_61/lib/ddgplm25.so
Description=DataDirect 6.1 Greenplum Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=gpdemo
DefaultLongDataBuffLen=2048
EnableDescribeParam=0
EncryptionMethod=0
ExtendedColumnMetadata=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
HostName=192.168.1.65
InitializationString=
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Password=
Pooling=0
PortNumber=5432
QueryTimeout=0
ReportCodepageConversionErrors=0
TransactionErrorBehavior=1
XMLDescribeType=-10
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment