Groups > comp.databases.ms-sqlserver > #1292

Odbc and client library/drivers

Received	by 10.224.52.195 with SMTP id j3mr533085qag.0.1347990510791; Tue, 18 Sep 2012 10:48:30 -0700 (PDT)
Received	by 10.236.173.202 with SMTP id v50mr407204yhl.19.1347990510758; Tue, 18 Sep 2012 10:48:30 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!v8no93959qap.0!news-out.google.com!t12ni13859336qak.0!nntp.google.com!v8no93950qap.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 18 Sep 2012 10:48:30 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=46.195.7.59; posting-account=3_reEwoAAAC163IAIrx427KYmwahFuh9
NNTP-Posting-Host	46.195.7.59
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<94298aed-7cbb-41f8-a155-c4632fc9db35@googlegroups.com> (permalink)
Subject	Odbc and client library/drivers
From	björn lundin <b.f.lundin@gmail.com>
Injection-Date	Tue, 18 Sep 2012 17:48:30 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Lines	29
Xref	csiph.com comp.databases.ms-sqlserver:1292

Show key headers only | View raw

Hi!
I maintain a largish application that was once written for vax/vms and mimer database.
This was then migrated to oracle, and later on, to windows and aix. But still oracle. 
Having that said, there is a large portion of code out at customers, that we do not want to change,
If we migrate them from aix+oracle to windows+sqlserver.

A couple of years ago, I ported the application to use sql-server as db, and we have some 
sites in production now, on sql-server. It runs fairly good overall, but there is one thing
That comes up time after time.
If we 

select * from sometable

And retrive the colunms in another order than the selcect presents them, we get a failure.
I know this is the client lib 'optimising' by dropping data it does think i do not want. 

I wonder if there exists such an odbc client lib other than the one that get installed on the server,
That allows me to retrive values from a resultset in the column order i like?

--
Björn Lundin

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 10:48 -0700
  Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-18 21:57 +0200
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-18 13:24 -0700
      Re: Odbc and client library/drivers George Neuner <gneuner2@comcast.net> - 2012-09-19 11:46 -0400
      Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 21:16 +0200
        Re: Odbc and client library/drivers Gene Wirchenko <genew@ocis.net> - 2012-09-19 13:14 -0700
          Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:41 -0700
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:45 -0700
              Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:56 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 14:00 -0700
        Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-19 13:26 -0700
          Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-19 23:44 +0200
            Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:50 -0700
              Re: Odbc and client library/drivers Erland Sommarskog <esquel@sommarskog.se> - 2012-09-20 23:31 +0200
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 01:18 -0700
                Re: Odbc and client library/drivers bradbury9 <ray.bradbury9@gmail.com> - 2012-09-21 02:57 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:10 -0700
                Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-21 03:14 -0700
  Re: Odbc and client library/drivers rja.carnegie@gmail.com - 2012-09-19 16:57 -0700
    Re: Odbc and client library/drivers björn lundin <b.f.lundin@gmail.com> - 2012-09-20 01:58 -0700

csiph-web