| 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
