Re: Heterogeneous Services

Beema wrote:

> 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
>
>
> eg.
>
> SQL Table -->
>
> MYTABLE
> ------
> FIRSTCOLUMN int
> SECONDCOLUMN varchar(30)
>
>
> From Oracle....
>
> INSERT INTO MYTABLE_at_hsdef ( FIRSTCOLUMN ) VALUES ( 1 )
> works fine....
>
> INSERT INTO MYTABLE_at_hsdef ( SECONDCOLUMN ) VALUES ( 'TEST' )
> givess error that SECONDCOLUMN does not exist...

Are all column names in upper case?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)