Re: Heterogeneous Services

From: Beema <none_at_yahoo.com>
Date: Mon, 23 Feb 2004 15:09:10 -0000
Message-ID: <c1d52k$1gm43s$1@ID-217433.news.uni-berlin.de>

> > Hi, I am setting up a connection via Heterogeneous Servies to a MS SQL
> > Server database, this is for sending data from Oracle to MS SQL.
> >
> > Upon attempting a basic insert, we are getting an error saying that the
> > column name is not correct. Whereas the column name is indeed correct.
> >
> > This occurs only when the destination column is a char/varchar type...??
> >
> > Has anyone had experience in sending data to MS SQL Server via HS?
> > Any help would be much appreciated!!
> >
> > BM
> >
>
> 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.

The MS SQL database is not case sensitive though. Received on Mon Feb 23 2004 - 09:09:10 CST