Test ODBC connection failed. Pleae help me to take a look. Thanks.

On Mon, Apr 30, 2012 at 12:32 PM, leaf_yxj <leaf_yxj@163.com> wrote:

These odbc drivers (psqlodbc-08.02.0400  psqlodbc-08.03.0400
psqlodbc-09.00.0200 psqlodbc-08.02.0500  psqlodbc-08.04.0200) were
installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini.
And setup the driver and driver manager environment variables, I still can't
get the isql command. It still give me the error message that the isql
command can't be found. Please help. Thanks. Grace

you want psql not isql.

Hi Scott,

I amn't farmiliar with isql. Why I said isql is because that I did some research. they said something related to isql. No matter it's isql or psql.

1)How can I test the odbc function?
2) what's isql, in which circumstances , we use isql.

Thanks.
Regards.

Grace

At 2012-05-01 03:11:40,"Scott Marlowe" <scott.marlowe@gmail.com> wrote:

you want psql not isql.

On Mon, Apr 30, 2012 at 3:19 PM, yxj <leaf_yxj@163.com> wrote:

Hi Scott,

I amn't farmiliar with isql. Why I said isql is because that I did some
research. they said something related to isql. No matter it's isql or psql.

1)How can I test the odbc function?
2) what's isql, in which circumstances , we use isql.

Thanks.
Regards.

Grace

I think Grace is trying to use the "isql" that comes with unixodbc in order
to test her ODBC connection.

Grace, my isql is in /usr/bin/isql, but I'm on Ubuntu, and i think you're
on CentOS. (try "locate isql")

Hi Chris,

Actually I only want to test ODBC. But I didn't have any idea to test. We have pgsqlodbc installed, but I don't how to test it. Please give me some clue.

Thanks.

Grace

At 2012-05-01 03:54:36,"Chris Curvey" <chris@chriscurvey.com> wrote:

you want psql not isql.

On Mon, Apr 30, 2012 at 3:19 PM, yxj <leaf_yxj@163.com> wrote:

Hi Scott,

I amn't farmiliar with isql. Why I said isql is because that I did some research. they said something related to isql. No matter it's isql or psql.

1)How can I test the odbc function?
2) what's isql, in which circumstances , we use isql.

Thanks.
Regards.

Grace

I think Grace is trying to use the "isql" that comes with unixodbc in order to test her ODBC connection.

Grace, my isql is in /usr/bin/isql, but I'm on Ubuntu, and i think you're on CentOS. (try "locate isql")

Hi Guys:

I installed this odbc driver :psqlodbc-08.02.0400

and datadirect-x_xx. I want to test this two things work or not.

Please give me some idea.

Thanks.
Grace

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Test-ODBC-connection-failed-Pleae-help-me-to-take-a-look-Thanks-tp5676587p5677250.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.