Greenplum ODBC Connection Problem

[mczern]

I have combed the documentation and can't seem to get the Greenplum ODBC connection going.

Running RHEL 64bit version of DataStage 8.501.

I'm getting the ever popular "Specified driver could not be loaded"

Any help would be greatly appreciated.

Below are the setup that needs to be done according to the documentation......

echo $LD_LIBRARY_PATH
/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86_64:/ora01/oracle/product/10.2.0/db_1/lib:/opt/dmexpress/lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/ora01/oracle/product/10.2.0/db_1/lib:/ora01/oracle/product/10.2.0/db_1/lib3


$ODBCINI
echo $ODBCINI
/opt/IBM/InformationServer/Server/DSEngine/.odbc.ini


.odbc.ini

[ODBC Data Sources]
IDS Greenplum=IDS DataDirect 6.0 Greenplum Wire Protocol

[IDS Greenplum]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/ivgplm24.so
Description=DataDirect 6.0 Greenplum Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=cnxonline
EnableDescribeParam=1
ExtendedColumnMetadata=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchRefCursor=1
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
HostName=172.18.9.17
InitializationString=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Password=
Pooling=0
PortNumber=5432
QueryTimeout=0
ReportCodepageConversionErrors=0
TransactionErrorBehavior=1
XMLDescribeType=-10


uvodbc.config (In both DSEngine directory and in individual project directory)

[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<IDS Greenplum>
DBMSTYPE = ODBC

[chulett]

I honestly have no idea but I don't recall having an ODBC name with a space in it, for grins you might want to try a name that doesn't include one.

[mczern]

If anyone is working with Greenplum, please let me know how you're accessing the database.

Additional information
....running the dssh program...
>DS_CONNECT "IDS Greenplum"
Enter username for connecting to 'IDS Greenplum' DBMS [dsadm]: datastage
Enter password for datastage:
SQLConnect error: Status = -1 SQLState = IM003 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Specified driver could not be loaded
Invalid parameter(s) found in configuration file

[mczern]

I now have the ODBC connection to Greenplum up and running..
You just need to ensure you're using the correct Driver library.

Code: Select all

.odbc.ini file... (I used the ip address of the host)

[IDSGreenplum]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMgplm24.so
Description=IDS DataDirect 6.0 Greenplum Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=cnxonline
EnableDescribeParam=1
ExtendedColumnMetadata=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchRefCursor=1
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
HostName=<xxx.xx.xxx.xxx>
InitializationString=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Password=
Pooling=0
PortNumber=5432
QueryTimeout=0
ReportCodepageConversionErrors=0
TransactionErrorBehavior=1
XMLDescribeType=-10

uvconfig.ini

<IDSGreenplum>
DBMSTYPE = ODBC