Recordset ignoring first column?

[MarkEmerson]

Hi everyone,

I have a strange problem with sql select statements ignoring the first field in the select statement if joining 2 or more tables when accessing data from ASP pages.

For example

"select c1, c2 from t1"
returns a recordset with 2 columns c1 & c2

"select c1, c2 from t1, t2 Where t1.c1 = t2.x1"
returns a recordset with only 1 column c2

However if I do
""select c1, c1, c2 from t1, t2 Where t1.c1 = t2.x1"
returns a recordset with only 2 columns c1, c2 - obviously whilst this works it is not ideal and also means revisiting hundreds of sql statements

We have had a external guy in the office today who i believe may have upgraded oracle & the drivers used to connect. All of these statements worked fine beforehand. Would anyone have any idea why this is suddenly happening

Any quick help would be greatly appreciated.

M

 

[LKBrwnDBA]

Check that ODBC is using the correct Oracle driver.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[MarkEmerson]

Its using one titled "Oracle in ORACLE9I_HOME"

Looking at its properties -
version 9.02.00.00
Company Oracle Corporation
File sqora32.dll
date 12/03/2002

This is different to the driver i was using before but the old driver no longer works so i assume Oracle has been upgraded.