Additional column in select query

U

:uno:

Hi!

I use oledb to execute queries and fetching data in my C++ app. If I
connect to local access database each select returns exactely the
number of columns I wrote in that select. But if I connect to remote
database each select returns all columns + one at the beginning with
record id.
Do you know why it happens and how to switch it off?

Example:
select name, surname from names - on local database I get

name, surname
--------------
Daniel Kos
John John
......

if database is on remote machine the same select returns:

(column without name) name, surname
 
Top