RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Nold, Mark
Thursday, March 22, 2001 11:16 PM To: [EMAIL PROTECTED] Subject: RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long] I got it. I had the table name listed as aradmin_eps_service_instructions when in fact it should have been aradmin.eps_service_instructions (with the dot). I d

RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Brian S. Dunworth
At 10:16 AM 3/22/01 -0500, Brooks, Ken wrote: >I got it. ah. :) good >I had the table name listed as aradmin_eps_service_instructions >when in fact it should have been aradmin.eps_service_instructions (with >the dot). > >I did not know this because all of the tables I had seen linked to

RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Brian S. Dunworth
At 09:52 AM 3/22/01 -0500, Brooks, Ken wrote: >Lets start at the basics. > >What is the easiest way to *make sure* that i am connecting to that oracle >db? > >Anyway I can just list the tables, or something. >odbc_tables or something like that?.. To get a list of the tables, you could: SE

RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Brooks, Ken
have priveledge to even view) uses the . Whee! -Original Message- From: Brooks, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 9:52 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long] Lets start at the basics. What is the ea

RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Brooks, Ken
, 2001 9:32 AM To: [EMAIL PROTECTED] Subject: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long] I only mentioned the part about the access, just to prove that I know i have a select statement working with an ODBC source. I know that I am connecting to the Oracle database, because if

[PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Brooks, Ken
riginal Message- From: Greig, Euan [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 9:21 AM To: Brooks, Ken Cc: [EMAIL PROTECTED] Subject: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long] I haven't used Oracle with ODBC, but nothing leaps out at me from your code. S

[PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]

2001-03-22 Thread Greig, Euan
I haven't used Oracle with ODBC, but nothing leaps out at me from your code. Some comments/ideas: The full meaning of error 0972 is that the name of a schema object (table, view, username etc) is too long (longer than 30 characters, maybe more for Oracle 8). The query statement you are using