Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ODBC to Microsoft SQL

Re: ODBC to Microsoft SQL

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 25 Apr 2006 20:03:05 +0200
Message-ID: <e2lo6b$tph$2@news1.zwoll1.ov.home.nl>


3gemail_at_gmail.com wrote:
> I have the odbc setup in oracle to Microsoft SQL server. When I issue
> a select * from table name it works great, but is I add a where clause
> it indicates invalid column name. I have use just the column name and
> also the microsoft format tablename_t.colum_name and no dice.
>
> Any help is greatly appriciated.
>

Use NO quotes.

You did not? Oh heck, my crystal ball needs cleaning. While I do that, post your query - exactly!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Apr 25 2006 - 13:03:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US