Database connection to PostgreSQL problem [message #92098] |
Tue, 13 October 2015 18:29 |
huangsu
Messages: 10 Registered: November 2014
|
Junior Member |
|
|
I am using IDL8.4 with DataMiner on Linux Debian Wheezy. I tried to connect my IDL to PostgreSQL 9.4 but encountered following errors:
IDL> objdb = OBJ_NEW('IDLdbDatabase')
% Loaded DLM: DATAMINER.
IDL> sources = objdb->GetDatasources()
IDL> sources
[
{
"DATASOURCE": "DB2WireProtocol",
"DESCRIPTION": "DataDirect7.1DB2WireProtocol"
},
{
"DATASOURCE": "SybaseWireProtocol",
"DESCRIPTION": "DataDirect7.1SybaseWireProtocol"
},
{
"DATASOURCE": "OracleWireProtocol",
"DESCRIPTION": "DataDirect7.1OracleWireProtocol"
},
{
"DATASOURCE": "MySQLWireProtocol",
"DESCRIPTION": "DataDirect7.1MySQLWireProtocol"
},
{
"DATASOURCE": "InformixWireProtocol",
"DESCRIPTION": "DataDirect7.1InformixWireProtocol"
},
{
"DATASOURCE": "PostgreSQLWireProtocol",
"DESCRIPTION": "DataDirect7.1PostgreSQLWireProtocol"
},
{
"DATASOURCE": "SQLServerWireProtocol",
"DESCRIPTION": "DataDirect7.1SQLServerWireProtocol"
}
]
IDL> mysrc = sources[5].datasource
IDL> objdb->connect, datasource = mysrc
% IDLDBDATABASE::CONNECT: ODBC [Exelis VIS][ODBC PostgreSQL Wire Protocol driver]Insufficient information to connect to the data source.
% Execution halted at: $MAIN$
IDL>
Anyone has idea how to solve this problem or get more detail information on this?
Regards,
|
|
|