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

2012-04-30 Thread yxj

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"  wrote:
>you want psql not isql.

On Mon, Apr 30, 2012 at 3:19 PM, yxj  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")





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

2012-04-30 Thread Chris Curvey
>you want psql not isql.
On Mon, Apr 30, 2012 at 3:19 PM, yxj  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")


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

2012-04-30 Thread yxj
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"  wrote:
>On Mon, Apr 30, 2012 at 12:32 PM, leaf_yxj  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.


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

2012-04-30 Thread Scott Marlowe
On Mon, Apr 30, 2012 at 12:32 PM, leaf_yxj  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.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general