Re: error message "column "oid" doesn"t exist"

am 02.01.2007 19:00:09 von Erika Marlow

This is a multi-part message in MIME format.

------_=_NextPart_001_01C72E97.D7B7E85B
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C72E97.D7B7E85B"

------_=_NextPart_002_01C72E97.D7B7E85B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We are recieving the error message "column "oid" doesn't exist" from a
series of ODBC calls via ADO in a Visual Basic application. The SQL
statements are all "SELECT * FROM

" where

refers to
several different tables. No tables were created with OIDs, because we
don't use them. So, the statement in the error is true, but we've been
using the same application without issues for quite some time.
=20
We're still using the 8.01.0200 drivers, UNICODE in this particular
case, and if necessary can upgrade (but it's a painful process).
=20
Any suggestions for resolving the issue without updating to the latest
drivers?
=20
If updating is the only option, do the new installation packages for the
driver take care of any ANSI/UNICODE differences? What are the rules
for moving from one to the other? =20
=20
Thanks,
=20
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
**Email: erika.marlow@nisc.coop =20
**Phone: 866.WWW.NISC (866.999.6472)
**Direct: 636.755.2519 =09
=20

------_=_NextPart_002_01C72E97.D7B7E85B
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

charset=3Dus-ascii">

We are =
recieving the=20
error message "column "oid" doesn't exist" from a series of ODBC calls =
via ADO=20
in a Visual Basic application. The SQL statements are all "SELECT =
* FROM=20
<table>" where <table> refers to several different =
tables. No=20
tables were created with OIDs, because we don't use them. =
So, the=20
statement in the error is true, but we've been using the same =
application=20
without issues for quite some time.

size=3D2>

We're =
still using=20
the 8.01.0200 drivers, UNICODE in this particular case, and if necessary =
can=20
upgrade (but it's a painful process).

size=3D2>

Any =
suggestions for=20
resolving the issue without updating to the latest =
drivers?

size=3D2>

If =
updating is the=20
only option, do the new installation packages for the driver take care =
of any=20
ANSI/UNICODE differences? What are the rules for moving from one =
to the=20
other?

size=3D2>

class=3D985254317-02012007>Thanks, class=3D985254317-02012007>

title=3D"NISC Homepage - www.nisc.coop" =
src=3D"cid:985254317@02012007-3060"=20
border=3D0>

Erika=20
Marlow___________________
size=3D1>Senior=20
Software Specialist
National Information Solutions =
Cooperative
One=20
Innovation Circle
Lake St. Louis, MO 63367
color=3D#e70042> face=3Dwingdings>+ Email: href=3D"mailto:erika.marlow@nisc.coop" color=3D"#999999"=20
erika.marlow@nisc.coop
color=3D#e70042> face=3Dwingdings>( Phone: color=3D#999999>866.WWW.NISC=20
(866.999.6472)
face=3Dwingdings>( Direct: color=3D#999999>636.755.2519=20
=

------_=_NextPart_002_01C72E97.D7B7E85B--

------_=_NextPart_001_01C72E97.D7B7E85B
Content-Type: image/gif;
name="nisc.gif"
Content-Transfer-Encoding: base64
Content-ID: <985254317@02012007-3060>
Content-Description: nisc.gif
Content-Location: nisc.gif

R0lGODlhfgBbAOYAANmvrMU1TDAwLMlFU9zb28zLy769vLS0tJ1rb/DOx6kC OfT09PHx8Z2dne/v
7+ezqcPDwpKSkujBu5ACMLwDQaKioklJRIuLioGBgODg4KuqqoaFfE84N3V0 dGJkWvv7+1MCGHJy
avr6+ubm5nt7e2tra+np6ZOSiWJiYtXV1ayMi9JoZ3cCJlxcW/j4+NDQ0KOi mltcU1RUVOSlmm9R
Ubazrdh6dlNTTd2LgkVDPm1tY52blNjGxMF5guGaj/fp535+dNuDfMMkRqqp pYuKgN6TiMxUW7q5
uNmUlV5GRUADErCvrcaal7ZCXfn089VxbL8JQ14rMdWno+DQzY+PjvLk4vjx 78jIx/Pc2KempBwc
GZeXlc5gZIaGhkQgIqMwTXkcMn5hYSYnI9jU1OPj4/39/WEDHfv4+Ozr6tPS 0tjY2MCWjv///9Fv
ek5OSv7+/mZoYV9gVldYUzs8Nnd3bXcxPff3982hoOrq6MuJiuzs7KURQNfW 0vn5+d+goMAURSH5
BAAAAAAALAAAAAB+AFsAAAf/gGyCg4SFhoeIiYVvjB8fIn0udgsLDJaXDpkO l5aUC3YufY4fjG+K
p6ipqquJpY59VlUJEg8zPkVBQTa7vLtBOEh+DxJTIyZ4epuUdqIfZYys0dLT h4xlH30/CbVFOLm8
T08r4+TjXOfo5yttSABTZMbJDJ/NpdT3+NVv11ZY3DjebIg7Z8TIgIMDAgRI qBDhwYIQIXKxIWVK
BnholLlwZC+fx2jWnPi7FfAJF4MJhaj8AwUKBQouYcZs+eePSiENHyLkkocH gQzGNDqD9rFoqzcf
fkiYUQSXjRUGA6iM+bKq1atYYcpUmROhkZ5qgOJx8EkEKVNG07KxNtIHjqcG /4WwpJq1rl2sUGzi
VKiQy50xP0fomSfqGVq196xVqeUjyJO4f17SvUs5qwIKCi5fhrlX6oA8L1IQ IINm3sZniKnt+8E4
CFSpkyvLxpx5gu3buG1nfnkzQA8eaUbjIXw29SpGThLYwvE4AMvZ0GvbZsHC jBkQ2LODsG6GOgvd
FPT2KBCcNAM7Zokab1XGH9Pmz6FXrk39upL7Srx44ZAkR5IbSQSYBAdRWEfd BLvlxQR5BAh23lDr
IfLGGco1xgVs8lFGn3337ZeDG3LI0QIKI8JRwokhdKCiimHQUMeBmzUBQAEp AEWWKOpFyAhr7w0g
RGwZWqXAdCB0yIEFbsggIv8KKJyoIgkkYCBlF1RWaSUCLyKoABQ9XPHCaIPZ AaGOb7gXxIWRBVnX
kBOYgZ8XFiApw4glpBhlFxdEsMUWDTRQwZ9/9tnAnlvouQUCYCBIQRMG0JiB CTcWlxoj2/hggxE/
qmnZBNUZ6cYNczYZwp1U8FmBBksccMARBrTqqgFHqLqEBhoEWsEJX2QGBRNX BDcCWRvlWNQ+2xTx
hI9ABplZp/nlICedHWCQp58arAoBBFcU8EIaKXTrbQovvFDAFdfGesCsQ6iQ qwJdfkmGHgsEe9hH
xDK1gnOaXlWbm81aACoKcHRAQhdUNJDFEqxmm4YaP100gjEmRPzwCGRkQAD/ AeCOC4EBqh6gwh4K
GOElmAycNi8+xD5QxL1p5vvSkCwUud+zdZJwwRanHmCAlwzDY4I883gidCUM OICGCRVj/AK5rR6B
gAJNaEuyyR7Vu3IAycq3LL8cfDhnwDbjjDAEL/T8c9ChmOVIGWyzPYoIklRi 9AgWZ3ztHXt8QSOY
8UqaWLH3Zh0dpx3GGWoJYVewxM7lnR2vWYadbIgr2EziAB50q5HG0lc08UXZ NvYtLCtlqhy4y7S1
eZ+zILZQQgddRKB4o6KNUNrjZ0meijUfuFCJHhRjnEYBPTQh2qPzpKcaaz48 ga/LyxZuQajRFrz4
FTU6yMxQukvTiAh2FI00/wFqpMBED2E5KK/3TixlwwAtazok13I2GfYQR0Dg a5jpdY8yUuATX9IA
cIeLDAc9qAGJcoLgI9QNSWbO+loIMCC7A5CNZOjx26QAGD49IC0D7xjBWBaA I5BgYQY4GEBMNsPC
l7kQMy5cFgST5DrYbUEDR8BeBg7YvwgRYh+9+50JHua4YJHuB80TAptyw8Qm 4oZ+SbJfwSz4pV+R
UIM+FEQjglg0Pchje6NrBQ4CoIDqcOeMaEwjGoukBK+1IGCxy0IOU2AeqmVR QtfowyQqQQkX9FAV
P2hDDxCAgDC0iAYC4oAiF8nIRjLyBi2gU9gWV4AGRSqMdxzEFiMBCj+OSf8V SFmAHghwhQNUgAoY
6MCJVsnKVroSRVGy3gVNcB4RJDCTiuDdKNaGyWqUwQUMGIEaSlmBLVxASshM pjKhxEwoTalUB2sU
30xWCl3u8prOiJw+rInNXUauFG2rJiixIUoypOAKR9DAoCLAzj0J6p2DKlQE qEAFdh5MA0NA1RKG
kAU6Dqdvb4sbJTjBCU+AgpfVvAbc9kg0gnZiGZ7kXkdU4YAjDGEHJzjBnk6w AQ/grAJZQNWqjpA/
i2L0BECIgwf8lAUD1AAGGSVCCCAZnEeRZQEmUEMBXLoEGPj0p0MYwhJqkD8C IMM0a3MEGgjwAggc
oQZZ+KlPs5BPnZHtUV//LIz/WkGAI2ThBEQIKxE2MFM4hBRhO9OWuLwKViDE YA5mrdYQtgCEEIQA
Dm4QAAmyVaMMXAGqMNjBFmIq1rFuYKx0iEEOthCYMC2ADH+NqmAJG9YNWFas G6BDHNzQgNFASnTS
KAMEloBSOpiWDiHwgBvmsIWD5fBLFzEAaVH7Vi10IWdE0EEMbnCDvGqhAasq wGiHAFMiAEEHcYhB
iJYbA5V64AZzEMBr1QCPF9SAuBg17l2TG6IbhKi5HtCBDuQQ3SMwyIoi2Go1 8PBSIMDBA/CF72bn
gILWHkCHmGsvHOJgATEIQE8VOEANBLyEr6rST6x6KUdDwN/oiuHBDxaA/4Tn MAcxaCEEqTKAuGrQ
0y0YFw5ysEB0BQBhEktYAHPIQQ4EoIUSjO1LtHRBGUCSBtKmNr7xvUEO5tCF GxogDe9Sw2w9QF4t
3EBarY3VXDsqgBIU7KkwyKxuLUBiNzSpTnZVZQv6+1+Dteq6HKXDcyusBS0I wA1vxHKKSoCCG7BY
DLKrFgSo6wAxqbcQIjBAFjaw3xj4Ob4xEDEcugDcKxgVAkPI7XNZjAKBCXas QDhuXqUl1Cjr4L1y
2HEzMYCnC9CTnZ6OAHBdCgMi0AEOin3zDaLF6U7Ts57sjAAJOmAqCwK5zh8g HRpqsAMgENkNn4oD
HPYL3Rx04AIV+DEZ9P/L3wc36dhZsKpFu3DsC/j0BHeFbwzcYIFVjorT9SSU OzXg0l6nVrEWNvaT
7hRqcbu7AXKmowNkTLoaYzvQc3BDcy/tgUALAAUk2MISvLSELYi5yHMYUQgE fq6vwmEOcqCSh48b
3zjI4QYxWHO0pvWnLHh8CLCCAcU3y+IbeDtKeeKTx2nF8pVXS5ojYEAf7kyI PO95vBWWAQo8EAId
eGC+Fjh2shGtaDcbeURUkC0MBksHN4ghBHjawrnB+3OV6oAOGNhAqaiVKlU5 dQgb4HeRc8AkE1XP
YKli1bWu9aprFYC68CLFcXbda9WyuAVyuHq2Mz2HEmBgC1B2b7PF8DX//H01 szGQMJVuRoTeAtu7
MfAAHEJAh0hHegMRSLsBrlXwU8PX6HN6Y7Rkdz1tdUsNqO9WGrjVs8EYEZQv sDF/zYz3DgCBDj7f
9hxkcOwjLGEHYq5twl3H4RPgPg45MLKUblaBBjw8xayTg7Apf9rUEkHtRyi1 z3/udAHIQOd+j4Ac
sRcYiEVsiBMzQUZAu4oP6DnsY48kCiKdbR13GwM10AC2F310FHRBv/zXaGFz MAfQAB2wWhT2IZEH
B+IlXs8VAqzye2EnX3klAN4VMFTQUpXkIEFjBww1NJ7US5NDd75mdPI3aLeX e9wmMD0VdoP3NYpj
cD/XX2JwIgPTAGjl/3sNcAEdgALcdgOS917Dtlk5cAE9hVLbN2b55joYAFyV xENr0zbXcE3adBz2
xmAWoAViwCSN1gUbUFfEdgMhsAFZQFeoNgdaMHwlcF2Kplhp+GzIZkEFIFym ZExSUle4B2hU1gJb
sANfmIR8h2ZQl2wpEHO2tFUTFQ1l8H44pwVkJ0W9lodxEAchcAELxn9ohgL4 J3LvZXRohoEamAKa
cwWylQUNEAE3Q1bvRWQVlgN/Z1pJGAc3YAEiAm0QUIgLcIjVtA/hlIjHwV51 Z3RywCSwg4MYAIbw
dXVgOHgiAgcxeGqb9WBzUgIEQ25fcjEpIFyxgipDYHzvtW0sZmxSsv+KgHZx cDAwFXAEL5AB8NJJ
LiAJmeCBocA93sMHskeDTII4EYBDIud5kidewyZ8IuJiiZZ7yed9fHhRMCCH qScuTPNSuWVxVFZm
MvA6XaBbfuZcPxdeQCBw+vMTSZMGBnACcJACXjQPGURzhbCIewZiaEhfTdKE FgQBKYhj8mV006OJ
AAhdWpCT+cdRh0UEGrUDRLkDPrUFfCYHq2VhPSkHcBQBIfB4GNdcDFh5hzWU grUnQKCUFwMUYSJ3
pDMCWUAEINZfWjCMjXYBLRUaDXBuvPWWPCkGIAIHWxBlRKZjFgYqF+CHl6YD IWB5gHl8OkZmZjY9
rkMCBVMBF6BjzoL/JBgneZQXmKeWV3KQLe4CL30wY6RzBG61Y2+WjwF3Xz9R ALK4YxR2mhbmfU1i
cHxHZgKgcKq1YyoWJ8AWJ6ZJYmUmBrsnf4hzAfCmKkPQBeSFYqfZmHFiAbdZ Zh1gLVVUMpq5Cn1A
BA2GmzngJMimbEO0AZ5JYhBWZmjmd3SQaRL2YFpgZedIAgzGbSMGYRGWYpC0 Iqt0dtdDLqZEBT3o
BtsZYRM2B9MDB6SXQ3RGb6xQBg4gTBBQgF3ATD02cAQAKXrgVwiqSkwSSSZi M9QyBKeYSh3wbaKW
T6a4BVRQJRfgafQ0ol2AAczEaRVENt2yNBbVAKjUTM7kap+mchYk/28Cehx9 wADmBAHqRAWe5mO3
Rgl4QAAFYEoRkKCzJjAE85uwcgBleExRpziyUivrFGux9mojGm6/CQF7Qz5N lU6DcgEnqkwiOqKi
Fm1zFnM5Cko7agJGmk6AsjhfggfxAkzChE7qJE96gnabNy4cY6XUYlUb43u1 Eijw5Cd/cgQAIAWO
6qgAEKmS+qh3cAdMcKlrkKmaugYqMEjsBG/m1aC5qJKa9AHlpFOFunkwVjKO YAcFaqROdS5LoHk8
g3pL41Qk9aehsTlMYy4d86skxQNMIRDhUKzGeqzIGg5QQQETUAcFo6ZApgd2 BhK9wwB6QAbCExo/
QUtiwjYisAAFmv8BmiMuc2h6IEkxdRMuodEzZJA041qu4wKvL8ADD2ApJxER +Jqv+kpGLKAEJCBq
OFRJtJSZpLoWHCQ+FOMz/GMYj9BBQ1QxGRCxCrsJDuBBCTuxmaAHR4OuEdux ErsUzZMSNzGyJFuy
N8GsbkIDsYODGsaOCwCWqVAFuqRHA3UJ9AAhvBM3lqAJDyWPe0RQECUJP1s0 mpAJi2EvDQQ9bhIF
G4eDt0gGzkmqEpAAb9MHVtsHIqA2CPVDQOQIWfu13fQ2WptNbbNLWRsJLjAS Z4I1DtSvXoACo+Kb
A6cGJjCqAyoMCwUK9SCCPlQK7WMLl5Ip0NOvSmBlr+ObB1BJcUf/qoxwBjaA BJPQgVqFS5PTHrWA
AyuALA40AUXCAV9jM+n4AmQwbzCLCo3gBFzQBlXgRUKBRVnECFYAskFgBM8D PZyrBEcCSX7nkXSb
i7e0O9jwAwYhAUQ0GH3zu2RCIZd7LIJruzKDJHKAOBmobKRbsGtROVVwITYA kmeTktYLEkjhHkVw
KbXrvPkBvWkZui5buqBUBgFkAhcyAFLAvZvgvYjRCEfbGJnbvOYLJ1F0bE5o VL77vY3gO8CTBzhh
BABgNvX7R/lgDSKQv67hI/GTLzJ0vv9LaKIZY+x7HI9QCSaQAXdgEwPABQBw MfBgvNQ0Da4gEvXa
GPAhONFRRvdx/yQg0oWFpgZs2sHHgRS+E6480AQUsBBGcAdTEBgjtD25cwrg 9AFnUAUgiwuvER+o
gxmqg7tIMiLFuARr+iDfuwg+XE4Y0wNbshAD0AYVERgZgZIRRbZu47V9IBJR /BaZ6xwyPMMx0y/T
CMAWpMO4xre7cw3AdK0EkAZHkCtD/BDs4A7tqn6bEDRDswBogAW0cAvdIBCQ cceDQ7he4Ea9GWBX
4Md29sW+VK2EnAZX8DGXIQQDIBErEARIIAXDQAwSUMsP8AB+0A0A8Q1QkRKa vMlsFEHDOEEVFMq/
MsppUcBijMoGgADgQcRGoA7jEA690AsDQbsYUsVCwin84r973P9j+LOBXkzK uRTGr8rMNeDM4IET
D1EQ6XCvByEVP/LLWmMb3ew1w9ibLLuqyLxB5OQAIZyNB6oBiHIbu6EXJTsX 2mwZMHPP05PPsLOi
NTIc66Mj19BB2BqmBYYl36Ebu7HQGsImedwswBZJr4MB1tMocHdFgEwvSNEH 4Eo32QgrtXICYQAG
B+LRmwHStCHS/ILBSvJsSDYEtoY8CETOqnHR1joChUyKUDooG0ADOJ3TOr3T M5wZPv3TnZwkS3LS
N6Oml3m8SJ0YB4sGGU2KBXaKxxQGdQAG3eEdTITVci3XuVEf2NEhnQwqXf1t 0KQzb4c8uei6lNsI
MM0AeICtzHz/AHtKprMWBklQINzhHZI92QZiHXdtJBzwKUsiKtGysnLmKFZk R5SLR1xk1hijjWlt
TEqqSnGASFEQBV7ARvgx2/qxH7mrJPJ3ZQIjLaKmOPnz16FNj6Ndznn0O3RT yKhtpah4okvKSnDA
hdA9ItDtbU8CbqaSYTxjU2Uh2MMtIRwErpgjrsOzMedipYVCpmXKTCuy3gKT oovXpzmTPzzjWcDC
EWOdSTkrN0OUrsL1pLOSBc0XT1g64IbSJyAlUmqnLWajwsLd3aqxRb5TNGiA ruSzOcK1MU/aMbO6
4V2nKrl6LV6yMNyrwpDT0g6+O5sUuRX7sBZTPuASLvAa42q1Ui2ieK4/oxEl ft8n7t1TSLNyowd4
gH7t6rFEfhHwYAzIoAzxsrc6vuMojhSvIFANtbM8C7SfkDb23eRO/uDc5LVf m7XYxDa+uOVkXuZm
fuZnHggAOw==

------_=_NextPart_001_01C72E97.D7B7E85B--