Tillbaka till svenska Fidonet
English   Information   Debug  
OS2BBS   0/787
OS2DOSBBS   0/580
OS2HW   0/42
OS2INET   0/37
OS2LAN   0/134
OS2PROG   0/36
OS2REXX   0/113
OS2USER-L   207
OS2   0/4779
OSDEBATE   0/18996
PASCAL   0/490
PERL   0/457
PHP   0/45
POINTS   0/405
POLITICS   0/29554
POL_INC   0/14731
PSION   103
R20_ADMIN   1117
R20_AMATORRADIO   0/2
R20_BEST_OF_FIDONET   13
R20_CHAT   0/893
R20_DEPP   0/3
R20_DEV   399
R20_ECHO2   1379
R20_ECHOPRES   0/35
R20_ESTAT   0/719
R20_FIDONETPROG...
...RAM.MYPOINT
  0/2
R20_FIDONETPROGRAM   0/22
R20_FIDONET   0/248
R20_FILEFIND   0/24
R20_FILEFOUND   0/22
R20_HIFI   0/3
R20_INFO2   2632
R20_INTERNET   0/12940
R20_INTRESSE   0/60
R20_INTR_KOM   0/99
R20_KANDIDAT.CHAT   42
R20_KANDIDAT   28
R20_KOM_DEV   112
R20_KONTROLL   0/13030
R20_KORSET   0/18
R20_LOKALTRAFIK   0/24
R20_MODERATOR   0/1852
R20_NC   76
R20_NET200   245
R20_NETWORK.OTH...
...ERNETS
  0/13
R20_OPERATIVSYS...
...TEM.LINUX
  0/44
R20_PROGRAMVAROR   0/1
R20_REC2NEC   534
R20_SFOSM   0/340
R20_SF   0/108
R20_SPRAK.ENGLISH   0/1
R20_SQUISH   107
R20_TEST   2
R20_WORST_OF_FIDONET   12
RAR   0/9
RA_MULTI   106
RA_UTIL   0/162
REGCON.EUR   0/2055
REGCON   0/13
SCIENCE   0/1206
SF   0/239
SHAREWARE_SUPPORT   0/5146
SHAREWRE   0/14
SIMPSONS   0/169
STATS_OLD1   0/2539.065
STATS_OLD2   0/2530
STATS_OLD3   0/2395.095
STATS_OLD4   0/1692.25
SURVIVOR   0/495
SYSOPS_CORNER   0/3
SYSOP   0/84
TAGLINES   0/112
TEAMOS2   0/4530
TECH   0/2617
TEST.444   0/105
TRAPDOOR   0/19
TREK   0/755
TUB   0/290
UFO   0/40
UNIX   0/1316
USA_EURLINK   0/102
USR_MODEMS   0/1
VATICAN   0/2740
VIETNAM_VETS   0/14
VIRUS   0/378
VIRUS_INFO   0/201
VISUAL_BASIC   0/473
WHITEHOUSE   0/5187
WIN2000   0/101
WIN32   0/30
WIN95   0/4275
WIN95_OLD1   0/70272
WINDOWS   0/1517
WWB_SYSOP   0/419
WWB_TECH   0/810
ZCC-PUBLIC   0/1
ZEC   4

 
4DOS   0/134
ABORTION   0/7
ALASKA_CHAT   0/506
ALLFIX_FILE   0/1313
ALLFIX_FILE_OLD1   0/7997
ALT_DOS   0/152
AMATEUR_RADIO   0/1039
AMIGASALE   0/14
AMIGA   0/331
AMIGA_INT   0/1
AMIGA_PROG   0/20
AMIGA_SYSOP   0/26
ANIME   0/15
ARGUS   0/924
ASCII_ART   0/340
ASIAN_LINK   0/651
ASTRONOMY   0/417
AUDIO   0/92
AUTOMOBILE_RACING   0/105
BABYLON5   0/17862
BAG   135
BATPOWER   0/361
BBBS.ENGLISH   0/382
BBSLAW   0/109
BBS_ADS   0/5290
BBS_INTERNET   0/507
BIBLE   0/3563
BINKD   0/1119
BINKLEY   0/215
BLUEWAVE   0/2173
CABLE_MODEMS   0/25
CBM   0/46
CDRECORD   0/66
CDROM   0/20
CLASSIC_COMPUTER   0/378
COMICS   0/15
CONSPRCY   0/899
COOKING   27601
COOKING_OLD1   0/24719
COOKING_OLD2   0/40862
COOKING_OLD3   0/37489
COOKING_OLD4   0/35496
COOKING_OLD5   9370
C_ECHO   0/189
C_PLUSPLUS   0/31
DIRTY_DOZEN   0/201
DOORGAMES   0/1974
DOS_INTERNET   0/196
duplikat   5999
ECHOLIST   0/18295
EC_SUPPORT   0/318
ELECTRONICS   0/359
ELEKTRONIK.GER   1534
ENET.LINGUISTIC   0/13
ENET.POLITICS   0/4
ENET.SOFT   0/11701
ENET.SYSOP   33773
ENET.TALKS   0/32
ENGLISH_TUTOR   0/2000
EVOLUTION   0/1335
FDECHO   0/217
FDN_ANNOUNCE   0/7068
FIDONEWS   23435
FIDONEWS_OLD1   0/49742
FIDONEWS_OLD2   0/35949
FIDONEWS_OLD3   0/30874
FIDONEWS_OLD4   0/37224
FIDO_SYSOP   12841
FIDO_UTIL   0/180
FILEFIND   0/209
FILEGATE   0/212
FILM   0/18
FNEWS_PUBLISH   4155
FN_SYSOP   41520
FN_SYSOP_OLD1   71952
FTP_FIDO   0/2
FTSC_PUBLIC   0/13556
FUNNY   0/4886
GENEALOGY.EUR   0/71
GET_INFO   105
GOLDED   0/408
HAM   0/16041
HOLYSMOKE   0/6791
HOT_SITES   0/1
HTMLEDIT   0/71
HUB203   466
HUB_100   264
HUB_400   39
HUMOR   0/29
IC   0/2851
INTERNET   0/424
INTERUSER   0/3
IP_CONNECT   719
JAMNNTPD   0/233
JAMTLAND   0/47
KATTY_KORNER   0/41
LAN   0/16
LINUX-USER   0/19
LINUXHELP   0/1155
LINUX   0/22002
LINUX_BBS   0/957
mail   18.68
mail_fore_ok   249
MENSA   0/341
MODERATOR   0/102
MONTE   0/992
MOSCOW_OKLAHOMA   0/1245
MUFFIN   0/783
MUSIC   0/321
N203_STAT   894
N203_SYSCHAT   313
NET203   321
NET204   69
NET_DEV   0/10
NORD.ADMIN   0/101
NORD.CHAT   0/2572
NORD.FIDONET   189
NORD.HARDWARE   0/28
NORD.KULTUR   0/114
NORD.PROG   0/32
NORD.SOFTWARE   0/88
NORD.TEKNIK   0/58
NORD   0/453
OCCULT_CHAT   0/93
Möte OSDEBATE, 18996 texter
 lista första sista föregående nästa
Text 3649, 172 rader
Skriven 2005-04-13 17:34:36 av Mike '/m' (1:379/45)
   Kommentar till text 3639 av Robert Comer (1:379/45)
Ärende: Re: MS Access ODBC bug yields wrong data
================================================
From: Mike '/m' <mike@barkto.com>

> It shouldn't do that. ;-)

I know.  Our accounting department was less than happy about this. Seems they
want things involving money to be deterministic.

Go figure.

 /m


On Tue, 12 Apr 2005 21:03:04 -0400, "Robert Comer"
<bobcomer@mindspring.com> wrote:

>> Yup.  Just instilling some levity here.  You need a sense of humor when
>> working with MS Access, I'm finding out.
>
>That can be applied to computers in general!
>
>> When we run it in MS Access, the result set contains records of
>> employees whose employee ID is not 94.  It contains the correct number
>> of records, but wrong records.
>
>It shouldn't do that. ;-)   That's a lot of parentheses, but that shouldn't
>make a diff.
>
>> While I agree with that, the problem here appears to be in the manner
>> that MS Access is using ODBC.  It is using the wrong API to obtain the
>> primary index, and therefore has to guess which index is the primary
>> index.
>
>Probably so, but at least you can force it to use the proper index.
>
>- Bob Comer
>
>
>Doe it retrieve just random employee #'s?
>"Mike '/m'" <mike@barkto.com> wrote in message
>news:l6ko5198b6p58pss1kif6ftevn9nig1ka3@4ax.com...
>> >You know what I meant. <g>
>>
>> Yup.  Just instilling some levity here.  You need a sense of humor when
>> working with MS Access, I'm finding out.
>>
>> btw, take this SQL statement [please!]
>>
>> SELECT DA_PROD_ORDERS.ORDERNUMBER, DA_PROD_ORDERS.ORDERID,
>> DA_PROD_ORDERS.PDEMPLOYEEID
>> FROM DA_PROD_ORDERS
>> WHERE (((DA_PROD_ORDERS.PDEMPLOYEEID)=94));
>>
>> When we run it in MS Access, the result set contains records of
>> employees whose employee ID is not 94.  It contains the correct number
>> of records, but wrong records.
>>
>> When we run that same SQL statement via Oracle's PC client software, the
>> result set is correct.
>>
>> When we change the name of the primary indices according to the KB
>> article, the result set that MS Access returns is correct.
>>
>>>ODBC's a strange beast at times -- MS isn't the only one that doesn't do
>>>it
>>>right all the time. :(
>>
>> While I agree with that, the problem here appears to be in the manner
>> that MS Access is using ODBC.  It is using the wrong API to obtain the
>> primary index, and therefore has to guess which index is the primary
>> index.
>>
>>  /m
>>
>>
>>
>> On Mon, 11 Apr 2005 20:12:29 -0400, "Robert Comer"
>> <bobcomer@mindspring.com> wrote:
>>
>>>> It's not my problem, it is Microsoft's problem.  I am just the unlucky
>>>> person who is suffering because of it.  ;-)
>>>
>>>You know what I meant. <g>
>>>
>>>> If MS Access used this call, we wouldn't be having this conversation.
>>>> The MSDN page says that API call was present since ODBC v1.0.
>>>
>>>ODBC's a strange beast at times -- MS isn't the only one that doesn't do
>>>it
>>>right all the time. :(
>>>
>>>- Bob Comer
>>>
>>>
>>>"Mike '/m'" <mike@barkto.com> wrote in message
>>>news:h7sl519gq6u2rne02i1tq6jq32tbf8e1d3@4ax.com...
>>>> >so I doubt I would see Mike's problem.
>>>>
>>>> It's not my problem, it is Microsoft's problem.  I am just the unlucky
>>>> person who is suffering because of it.  ;-)
>>>>
>>>> btw,
>>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/
odbcsqlprimarykeys.asp
>>>>
>>>> If MS Access used this call, we wouldn't be having this conversation.
>>>> The MSDN page says that API call was present since ODBC v1.0.
>>>>
>>>> /m
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, 11 Apr 2005 11:33:44 -0400, "Robert Comer"
>>>> <bobcomer_removeme@mindspring.com> wrote:
>>>>
>>>>>>   And another person who didn't read the article.  The ODBC API
>>>>>> doesn't
>>>>>> identify the primary index.<
>>>>>
>>>>>No Rich, I read this one, and I knew it didn't provide that info before
>>>>>anyway, I use ODBC a **LOT**.
>>>>>
>>>>>I was just curious why the difference (if there is one).  I tend to make
>>>>>logicals (Views, I guess, you would call them in SQL speak) on the
>>>>>AS/400
>>>>>for performance, access, so I doubt I would see Mike's problem.
>>>>>
>>>>>- Bob Comer
>>>>>
>>>>>
>>>>>"Rich" <@> wrote in message news:425a933c@w3.nls.net...
>>>>>   And another person who didn't read the article.  The ODBC API doesn't
>>>>>identify the primary index.
>>>>>
>>>>>Rich
>>>>>
>>>>>  "Robert Comer" <bobcomer_removeme@mindspring.com> wrote in message
>>>>>news:425a752b$1@w3.nls.net...
>>>>>  I'm wondering why Access doesn't ask what the primary key is when
>>>>> linking
>>>>>a
>>>>>  table -- it does with the AS/400 DB2 driver I use.
>>>>>
>>>>>  - Bob Comer
>>>>>
>>>>>
>>>>>  "Mike N." <mike@u-spam-u-die.net> wrote in message
>>>>>  news:tprk51dp17eh1b9ngfg016v34ve7mokpb0@4ax.com...
>>>>>  > On Sun, 10 Apr 2005 20:39:25 -0400, Mike '/m' <mike@barkto.com>
>>>>> wrote:
>>>>>  >
>>>>>  >>Note that the KB article says that "Microsoft Access may select the
>>>>>  >>wrong index..."  As much as you would like it to be the case, the
>>>>>  >>problem has nothing to do with Oracle.
>>>>>  >
>>>>>  >   Is there a product that competes with Microsoft Access that when
>>>>> given
>>>>>  > the same query of the same ODBC connection and faced with the 2
>>>>> indexes,
>>>>>  > DOES pick the correct index for the right reason - not just luck?
>>>>>  >
>>>>>
>>>>>
>>>>
>>>
>>
>

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)