MS SQLCE - dataadapter.update(datatable) gives 80004005 unspecified

Author

dataadapter.update(datatable) gives 80004005 unspecified

Y3PP3R

2006-03-22, 9:28 am

Hey all,
I'm developing in vb.net (v1.1) for ppc 2002, using msde 2000, iis 5.0 from
xp pro and sql ce.

I can pull data from my server to my pcc, and I can query the .sdf, but when
I use a dataadapter to fill a dataset, add a row to the dataset and then try
to update the database, I get this annoying, useless error '80004005,
unspecified, sql server ce 2000' thing.

I appreciate any help, I've had all documentation and resources I could find
and tried the biggest IT bulletinboard of the Netherlands
(gathering.tweakers.net), but no body could help me so far.

Please, tell me what you need to know to help me, because I can start to add
loads of code, but I don't know what you want to see, exactly.

Yours sincerely,
J. Timmer

Wendell A. Clark

2006-03-23, 1:31 pm

Catch the hresult and then run that number through tech-ed it will tell you
what the problem is.

"Y3PP3R" <Y3PP3R@discussions.microsoft.com> wrote in message
news:7805F05D-A438-4B34-A6FF- 57271EEA1D43@microso
ft.com...
> Hey all,
> I'm developing in vb.net (v1.1) for ppc 2002, using msde 2000, iis 5.0
> from
> xp pro and sql ce.
>
> I can pull data from my server to my pcc, and I can query the .sdf, but
> when
> I use a dataadapter to fill a dataset, add a row to the dataset and then
> try
> to update the database, I get this annoying, useless error '80004005,
> unspecified, sql server ce 2000' thing.
>
> I appreciate any help, I've had all documentation and resources I could
> find
> and tried the biggest IT bulletinboard of the Netherlands
> (gathering.tweakers.net), but no body could help me so far.
>
> Please, tell me what you need to know to help me, because I can start to
> add
> loads of code, but I don't know what you want to see, exactly.
>
> Yours sincerely,
> J. Timmer

Y3PP3R

2006-03-24, 3:26 am

I have this as information on the error:

HResult -2147467259 Integer
Message "Unspecified Error" String
NativeError 0 Intege
r
Source "Microsoft SQL Server 2000 Windows CE Edition" String
- NumericErrorParamet
ers & #123;Length=3} Integ
er()
(0) 0 Integer
(1) 0 Integer
(2) 0 Integer

"Wendell A. Clark" schreef:

> Catch the hresult and then run that number through tech-ed it will tell you
> what the problem is.
>
> "Y3PP3R" <Y3PP3R@discussions.microsoft.com> wrote in message
> news:7805F05D-A438-4B34-A6FF- 57271EEA1D43@microso
ft.com...
>
>
>

Wendell A. Clark

2006-03-24, 8:25 pm

http://support.microsoft.com/default.aspx/kb/247968

links back to this page
PRB: Connection to SQL Server from Session_OnEnd() Event May Fail
View products that this article applies to.
Article ID : 247968
Last Review : July 16, 2001
Revision : 1.0

This article was previously published under Q247968
SYMPTOMS
When connecting to a Microsoft SQL Server database from within the Active
Server Pages (ASP) event, Session_OnEnd(), the connection to the SQL Server
computer may fail with one of the following errors:
Error Number: -2147467259 Error Description: [Microsoft][ODBC SQL Server
Driver]Client unable to establish connection
-or-
Error Number: -2147467259 Error Description: [Microsoft][ODBC SQL Server
Driver][Named Pipes]ConnectionOpen
(CreateFile())

The page talks about why and how to fix it -- hope it helps

Wendell A. Clark

--
Wendell A. Clark, BS
Nurses Unlimited, Inc.
432-550-1700 x126
-------------------------------------

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
please notify us by reply e-mail. You are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited.
If you have received this communication in error, please destroy all copies
of this communication and any attachments. Contact the sender if it
continues.

"Y3PP3R" <Y3PP3R@discussions.microsoft.com> wrote in message
news:0C532368-4A03-413F-B9EA- C7E1AAA654E3@microso
ft.com...[color=darkred]
>I have this as information on the error:
>
> HResult -2147467259 Integer
> Message "Unspecified Error" String
> NativeError 0 Integer
> Source "Microsoft SQL Server 2000 Windows CE Edition" String
> - NumericErrorParamete
rs {Length=3} Integer()
> (0) 0 Integer
> (1) 0 Integer
> (2) 0 Integer
>
>
>
> "Wendell A. Clark" schreef:
>

Y3PP3R

2006-03-29, 8:26 pm

sorry, but that isn't it, it has nothing to do with iis and authentication;
it's something internal in the pocketpc application. I think it has to do
with my dataadapter to sqlce, soruce is wrong, or the newrow I'm trying to
add is not correct (dataset is different from db table). I have code here:
http://y3p.pastebin.com

I tried all sorts of things, create seperate connections for all adapters,
use commandbuilder, try to set the GUID columns using "{" & guid.tostring &
"}" (this gives the error on the PK: reg_id is constraint to be unique but
the guid is unique ... ), and more things.

Sponsored Links