| Re: Dataminer and PostgreSQL [message #35896] |
Wed, 23 July 2003 00:19 |
nricci1
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
Ah! I figured out the problem. IDL ignores the ODBCINI environment
variable (which is supposed to point the the global odbc.ini file) if
there is a .odbc.ini file in ones home directory. In my case, there
happened to be an empty file with that name for some reason (possibly
created as part of the database installation?). For the dataminer to
work, the ODBCINI variable must be set, and you must not have a
.odbc.ini file in one's home directory (assuming you want to use the
system wide config file). I spent most of a day trying to figure that
out :)
Any way, the dataminer seems to be getting along fine with PostgreSQL
now that I've sorted that out *knocks on wood*. Thanks to any one who
gave the problem some consideration :) Hopefully this thread might
save someone some time in the future.
--Nathan Ricci
|
|
|
|
| Re: Dataminer and PostgreSQL [message #35897 is a reply to message #35896] |
Tue, 22 July 2003 18:57  |
tianyf_cn
Messages: 19
Registered: November 2002
|
Junior Member |
|
|
It seems IDL does not support ODBC connections to PostgreSQL.
Tian.
nricci1@ithaca.edu (Nathan Ricci) wrote in message news:<d3e796bd.0307220716.376d6b11@posting.google.com>...
> 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
