Thread: server --configure postgresql
Hello Sir, Does your odbc driver support postgres7.0.3? WE use postgre7.0.3 on linux. Could you help me to set uo a sysDSN: DATA SOURCE: hostname database: database name, server: ? username: linux user password: password, I am not sure what server is. Any advice will be appreciated. Regards, Helen. __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com
> -----Original Message----- > From: yanling xu [mailto:helenxyl@yahoo.com] > Sent: 13 November 2001 00:38 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] server --configure postgresql > > > Hello Sir, > > Does your odbc driver support postgres7.0.3? Yes. > WE use postgre7.0.3 on linux. > Could you help me to set uo a sysDSN: > > DATA SOURCE: hostname Actually, datasource can be any name you like. This is just an identifier for the DSN. > database: database name, > server: ? server: hostname or IP address of the linux/postgresql server > username: linux user Only if you chosen authentication scheme is using the linux password database (this is configured in $PGDATA/pg_hba.conf on the linux machine). > password: password, > Hth, regards, Dave.
Hi all,
It seems to me that SQLDescribeCol return the realname of a column.
For example when I run a query like that:
SELECT mycol AS othername FROM mytable;
it returns 'mycol' and not 'othername'. Am I wrong or is there's an
other way to have the alias returned ?
Regards
Gilles Darold
Gilles DAROLD wrote: > > Hi all, > > It seems to me that SQLDescribeCol return the realname of a column. > For example when I run a query like that: > > SELECT mycol AS othername FROM mytable; > > it returns 'mycol' and not 'othername'. Am I wrong or is there's an > other way to have the alias returned ? Aren't you turning on Parse Statement option ? Porbably you can get the alias name by turning off the option. Anyway I would fix it soon. The fix would be included in the next release. Thanks for the report. Hiroshi Inoue
Thanks, Don't know how to turning off Parse Statement, I'd set a Parse option to 'no' in the odbc.ini file but it does nothing. I've seen many thing related to Advanced Driver Options with a MS-Windows Interface but unfortunally I don't use this kind of box and can't find any documentation on how to defined these options by hand. Any idea ? Regards, Hiroshi Inoue wrote: > Gilles DAROLD wrote: > > > > Hi all, > > > > It seems to me that SQLDescribeCol return the realname of a column. > > For example when I run a query like that: > > > > SELECT mycol AS othername FROM mytable; > > > > it returns 'mycol' and not 'othername'. Am I wrong or is there's an > > other way to have the alias returned ? > > Aren't you turning on Parse Statement option ? > Porbably you can get the alias name by turning off the option. > Anyway I would fix it soon. > The fix would be included in the next release. > > Thanks for the report. > Hiroshi Inoue
Gilles DAROLD wrote: > > Thanks, > > Don't know how to turning off Parse Statement, I'd set a Parse option to > 'no' > in the odbc.ini file but it does nothing. I've seen many thing related > to Advanced > Driver Options with a MS-Windows Interface but unfortunally I don't use > this > kind of box and can't find any documentation on how to defined these > options > by hand. Any idea ? Oops I remember you are using libpsqqlodbc on a Linux. Hmm the ParseStatement option is off by default. Don't you have odbcinst.ini file somewhere ? regards, Hiroshi Inoue
Very good memory :-) Then if ParseStatement option is off by default (I have nothing related to this in my odbcinst.ini) and even if I set this option to off in the odbcinst.ini it doesn't work, I already have the realname of the column. But no matter, I have found a workaround until the next version of libpsqlodbc. You certainly also remember that I was working on OpenLDAP/PostgreSQL so the workaround it's just an other patch to openLDAP that may also help with some other ODBC database driver... Regards Gilles DAROLD Hiroshi Inoue wrote: > Gilles DAROLD wrote: > > > > Thanks, > > > > Don't know how to turning off Parse Statement, I'd set a Parse option to > > 'no' > > in the odbc.ini file but it does nothing. I've seen many thing related > > to Advanced > > Driver Options with a MS-Windows Interface but unfortunally I don't use > > this > > kind of box and can't find any documentation on how to defined these > > options > > by hand. Any idea ? > > Oops I remember you are using libpsqqlodbc on a Linux. > Hmm the ParseStatement option is off by default. > Don't you have odbcinst.ini file somewhere ? > > regards, > Hiroshi Inoue > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly