[freetds] column and tablename case translation between oracle and sql server over freetds

Dan Zemke jdzemke at yahoo.com
Fri Mar 24 09:47:28 EST 2006


Anyone - When I create a table in oracle over a
database link in oracle using freetds and connecting
to a sql server database, the table name and columns
names are brought over in lower case.  Therefore, when
I select a column from the newly created table in
oracle I have to put quotes around the column names.

For example,
create table xxempi.xxbi_invoice_fact as select * from
invoice_fact at edev2_to_sqltest01;

In the example, above the create table statement is
run in oracle and selects from a table in sql server
over a database link (the database link uses freetds).

However, the newly create table definition,
specifically the columns, will be forced in lower
case.

CREATE TABLE "xxbi_invoice_fact"
(
  "invoice_pk"            NUMBER(18)    NOT NULL,
  "invoice_id"            VARCHAR2(15 BYTE) NOT NULL,
  "primary_claim_code"  VARCHAR2(15 BYTE) NOT NULL,
...............

Is there a parameter to fix this or a workaround
someone could share?  Thanks.

Dan


  
--- baeck1957 <baeck1957 at hotmail.com> wrote:

> freddy77 -- Thank you for 64RC1 and the patch.  
> Everything is in working order now.
> 
> Brent
> 
> ----- Original Message ----- 
> From: "ZIGLIO, Frediano, VF-IT"
> <Frediano.Ziglio at vodafone.com>
> To: "FreeTDS Development Group"
> <freetds at lists.ibiblio.org>
> Sent: Thursday, March 23, 2006 9:28 AM
> Subject: Re: [freetds] Problem with RPC against SQL
> server 2005
> 
> 
> >> 
> >> I apologize for being such a newbie.  I tried
> applying the patch
> >> that freddy77 provided but I'm sure I botched it.
>  I'm just a
> >> lowly applications DBA.
> >> 
> >> Here are the steps I took--
> >> 
> >>   1.. Copied vedi.diff.gz to the source directory
> 
> >> (/oracle/GPD/opt/freetds).
> >>   2.. gunzip vedi.diff.gz
> >>   3.. patch -b -i vedi.diff
> >> Results of the patch command:
> >> Looks like a unified context diff.
> >> 
> >>   The next patch looks like a unified context
> diff.
> >> 
> >>   The next patch looks like a unified context
> diff.
> >> 
> >> Hunk #2 failed at line 1529.
> >> 
> >> Hunk #3 succeeded at line 1715 (offset 1 line)
> >> 
> >> Hunk #4 failed at line 2197.
> >> 
> >> Hunk #5 failed at line 2281.
> >> 
> >> 3 out of 5 hunks failed: saving rejects to
> src/tds/query.c.rej
> >> 
> >> done
> >> 
> >> 
> >> 4. Performed ./configure again with the
> appropriate parameters.
> >> 5. make
> >> 6. make install
> >> 
> >> When I did a test with tsql after attempting the
> patch, I 
> >> received some
> >> errors I hadn't seen before.  So deleted the
> target directories and 
> >> re-created the
> >> unixODBC and freetds objects (using the current
> distribution from the 
> >> freetds
> >> web site -- freetds-0.65.dev.20060317). 
> Everything is back 
> >> to where it was
> >> before I attempted the patch (even the RPC / Data
> Type error 
> >> in Oracle).
> >> 
> >> freddy77 -- how should the patch be applied?
> >> 
> >> Brent
> >> 
> > 
> > No, patch was again 0.64...
> > 
> > I finally got a machine to install sql express
> ("free" version of mssql
> > 2005), I just committed a patch that should work
> (only odbc tables test
> > fails but is useful for Jdbc). You can find patch
> at
> > http://freetds.sourceforge.net/post64rc1.diff.gz,
> 0.64rc1 at
> >
>
http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/release_candidates/fre
> > etds-0.64RC1.tar.gz
> > 
> > freddy77
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the FreeTDS mailing list