freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] ORA-00904: "D_TIME": invalid identifier
- From: Зверев Виталий Борисович <VZverev AT genesis.spb.ru>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] ORA-00904: "D_TIME": invalid identifier
- Date: Wed, 22 Jun 2005 10:50:29 +0400
Hello Wei Jiang,
1)By default oracle uses upper cased column name notation and it can be a
cornerstone of your problem.
You should try to rewrite select in case-sensitive style:
select "Exact_CoLuMn_NaMe" from record@hscwa
If you doubt in translated HS case-sensitive column names, try this:
select column_name
from dba_tab_columns@hscwa
where lower(table_name) like 'record'
2)set suitable db
The 'record' table should be accessible from database noted in ODBCINI /
HS_FDS_CONNECT_INFO or you should assign it explicitly before select.
DECLARE
val VARCHAR2(100);
c INTEGER;
begin
c:= DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@hscwa('use _bla_bla_bla_');
end;
Sincerely yours.
------------------------------------------------------------
Vitaly Zverev, Oracle Applications DBA,
Genesis Ltd., St.Petersburg, Russia
>>>>>> Tel : +7(812) 329-5689 <<<<<<
>>>>>>>> http://www.gen.ru <<<<<<<<
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Wei Jiang
Sent: Wednesday, June 22, 2005 5:12 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] ORA-00904: "D_TIME": invalid identifier
I has configured oracle HS, unixODBC and freetds, I
can run isql and tsql to test the connection, I can
run "select * from record@hscwa;" to recive each line
in table record with sqlplus, and I know the field
contains "d_time", so I type "select d_time from record@hscwa;", but I got
this error messaes:
"ORA-00904: "D_TIME": invalid identifier".
Could anyone help me?
Thanks
___________________________________________________________
雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱
http://cn.mail.yahoo.com/?id=77071
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org http://lists.ibiblio.org/mailman/listinfo/freetds
-
[freetds] ORA-00904: "D_TIME": invalid identifier,
Wei Jiang, 06/21/2005
- Re: [freetds] ORA-00904: "D_TIME": invalid identifier, Jorge Cordero, 06/21/2005
- <Possible follow-up(s)>
- RE: [freetds] ORA-00904: "D_TIME": invalid identifier, Зверев Виталий Борисович, 06/22/2005
Archive powered by MHonArc 2.6.24.