Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.
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.
>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.
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.
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