| Dataminer and PostgreSQL [message #35916] |
Tue, 22 July 2003 08:16 |
nricci1
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
Has any one had any luck connecting the IDL Dataminer to PostgreSQL
(using ODBC)? I've setup the database, and it seems that other
programs can find it using ODBC (open office, random test programs
I've written in other lanagues, etc). I'm running this on Red Hat 9,
using PostgreSQL 7.3.2 and the unixODBC drivers (both supplied with
Red Hat).
Here are some of my results in trying, after creating the object, and
setting the verbose parameters.
IDL> PRINT, DB_EXISTS()
1
IDL> status = DIALOG_DBCONNECT(db)
% DIALOG_DBCONNECT: ODBC SQL Function=SQLDriverConnect,STATE=,CODE=0,
Unknown ODBC system error.
IDL> PRINT, db->GetDataSources()
{ }{ S1000 }{ 00000 }{ %02u.%02u.%02u%02u }{ \ }{ odbccurs.so }{
odbccurs.so }{ ODBC }{ DSN }{ DRIVER }{ UID }{ PWD }{ FILEDSN }{
SAVEFILE }{ APPCODEPAGE }{
CONVERSIONTABLELOCATION }{ \ODBC }{ \Data Sources }{ .dsn }{
SOFTWARE\ODBC\ }{
ODBCINST.HLP }
Also, below is my odbc.ini file:
[ODBC Data Sources]
asteroid_taxonomy = Read/Write Database
[asteroid_taxonomy]
Description = Postgresql Asteroid Taxonomy Data Base
Database = asteroid_taxonomy
ReadOnly = 0
Driver = /usr/lib/libodbcpsql.so
username = nricci1
password =
servername = localhost
Trace = Yes
TraceFile = /var/log/odbc.trace
Debug = Yes
DebugFile = /var/log/odbc.debug
If any one has any suggestions, they would be appreciated.
Thanks,
Nathan Ricci
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
