Re: Heterogeneous Services

From: Beema <none_at_yahoo.com>
Date: Mon, 23 Feb 2004 16:48:27 -0000
Message-ID: <c1dasp$1gec3e$1@ID-217433.news.uni-berlin.de>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077550856.213168_at_yasure...
> Beema wrote:
>
> >>Are all column names in upper case?
> >>
> > Yes, all columns are in uppercase, but this need not be the case, as the
> > tables onthe MS SQL side can be re-defined.
>
> That is why I asked. Make sure they are all upper case and do not
> contain spaces or other naming conventions not acceptable to Oracle.
>

We're getting some weird results...

I had a sample table in MSSQL with UPPERCASE column names, and an insert from Oracle to MS SQL didn't work. However, when dropping and re-creating the table, with a different column name, same type - the insert did work... neither was a reserved word in Oracle or SQL...

Does the Heterogeneous Services connection cache the MS SQL structure or anything like that? Does it need to get refreshed if I make a change to any table in MS SQL?

It's confusing when something works, then something else doesn't without anything being obviously different!!??

Thanks for your help. Received on Mon Feb 23 2004 - 10:48:27 CST