Skip site navigation (1) Skip section navigation (2)

[HELP] can't get Unixiodbc to connect to SQL

From: lchan <lchan(at)mail(dot)arc(dot)nasa(dot)gov>
To: pgsql-odbc(at)postgresql(dot)org
Subject: [HELP] can't get Unixiodbc to connect to SQL
Date: 2004-09-02 21:09:27
Message-ID: 6.1.0.6.0.20040902140714.025e61f8@mail.arc.nasa.gov (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
I'm new to postgresql Unix iodbc.  I am trying to test my unixodbc 
connection to a local Postgres DB via the provided "iodbctest" program and 
have been unsuccessful in getting a "SQL>" prompt.  Instead, it prints out 
a "Have nice day" message.   Been working on this problem for a week now 
and have not come up with anything close at all.
Searched the web and this forum for any "ideas" as to what is wrong and 
can't find anything.  Any input or help in pointing me to the right 
direction is highly appreciated and invaluable.

Thank you in advance for any help on this!

Pasted below is what is currently downloaded and running:
1) Postgres 7.4.3 installed and have created several databases.
2) Downloaded IODBC Driver Manager: 03.51.0002.0224
3) $ODBCINI = /u7/uav/pgsql_odbc/.odbc.ini ; 
LD__LIBRARY_PATH=/u7/uav/pgsql/lib:/u7/uav/libiodbc/lib/:/u7/uav/pgsql_odbc/lib:....
4) .odbc.ini file content below

[ODBC Data Sources]
postsql1=PostgreSQL ODBC Drive


[postsql1]
Driver=/u7/uav/pgsql_odbc/lib/psqlodbc.so
Host=localhost
ServerType=Postgres
Database=testdb
Username=dbadm
ReadOnly=no
FetchBufferSize = 60
Port=5432


[ODBC]
Trace=1
TraceFile=/u7/uav/odbc.trace
Debug=1
DebugFile=/u7/uav/odbc.log
------------------------------------

5) odbcinist.ini file content

[PostgresSQL1]
Description=ODBC for PostgreSQL
Driver=/u7/uav/pgsql_odbc/lib/psqlodbc.so

[PostgresSQL]
Description=ODBC for PostgreSQL
Driver=/u7/uav/pgsql_odbc/lib/psqlodbc.so
FileUsage = 1

[ODBC]
Trace = 1
Pooling = No
FileUsage =1
CommLog =1
Debug = 1


6) output :
aloe 92% ./iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.51.0002.0224

Enter ODBC connect string (? shows list): ?

DSN | Description
---------------------------------------------------------------
postsql | PostgreSQL
postsql1 | PostgreSQL ODBC Drive

Enter ODBC connect string (? shows list)SN= postsql

Have a nice day.aloe 93%

pgsql-odbc by date

Next:From: Deepa RamamurthyDate: 2004-09-02 21:10:21
Subject:
Previous:From: Raymond O'DonnellDate: 2004-09-02 10:46:02
Subject: Re: odbc/ado problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group