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

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

From
leaf_yxj
Date:
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


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

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

From
Scott Marlowe
Date:
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: >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.



网易Lofter,专注兴趣,分享创作!

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

From
Chris Curvey
Date:
>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")





网易Lofter,专注兴趣,分享创作!
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.