[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    RE: [freetds] ORA-00904: "D_TIME": invalid identifier
From:       =?gb2312?B?p6mn06fWp+Kn1qfTIKejp9qn5KfRp92n2qfbIKeip+Cn4qfap+On4KfTp9o=?= =?gb23
Date:       2005-06-22 6:50:29
Message-ID: 4B1A3038F9F9DF47913BAC08BC087DB502F31C () MUN ! gen
[Download RAW message or body]

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@lists.ibiblio.org [mailto:freetds-bounces@lists.ibiblio.org] On \
                Behalf Of Wei Jiang
Sent: Wednesday, June 22, 2005 5:12 AM
To: freetds@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@lists.ibiblio.org http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]