Error: -2147217900

[mike]

Howdy People,

If there is a FAQ for this, could someone point me to it, otherwise, here is
my problem.

I'm running an extremely simple (or so I though) vbscript which uses ADO to
update an SQL Server table from a text file. The script reads the file line
by line and for each line it performs a delete on the database with a
statement like the following:

DELETE FROM MyTable WHERE MyField = '3794'

What could be simpler eh? In a table containing over 3000 rows, 8 rows fail
with the following error code:

-2147217900

There is so error source or description. Each time it is the same 8 queries
which fail. The statements which fail can be run just fine using Query
Analyzer.

I'd be grateful for any thoughts.

Mike B

[mountain man]

Re: Error: -2147217900

Perhaps it could that the rows dont exist in the
SQL Server table, or perhaps that you have
duplicate records somewhere.

What results does the following script return:

select myField, count(*)
from mytable
group by myField
having count(*)>1
order by 2 desc



Pete Brown
Falls Creek
Oz



"mike netspace.net.au >" <transam@<REMOV ETHISINCLUDINGB RACKETS> wrote in
message news:400736db$1 @dnews.tpgi.com .au...[color=blue]
> Howdy People,
>
> If there is a FAQ for this, could someone point me to it, otherwise, here[/color]
is[color=blue]
> my problem.
>
> I'm running an extremely simple (or so I though) vbscript which uses ADO[/color]
to[color=blue]
> update an SQL Server table from a text file. The script reads the file[/color]
line[color=blue]
> by line and for each line it performs a delete on the database with a
> statement like the following:
>
> DELETE FROM MyTable WHERE MyField = '3794'
>
> What could be simpler eh? In a table containing over 3000 rows, 8 rows[/color]
fail[color=blue]
> with the following error code:
>
> -2147217900
>
> There is so error source or description. Each time it is the same 8[/color]
queries[color=blue]
> which fail. The statements which fail can be run just fine using Query
> Analyzer.
>
> I'd be grateful for any thoughts.
>
> Mike B
>
>
>
>
>
>
>[/color]