SQL CE - 28558 Error Creating Database

[Nathan]

This occurred for a customer on AudioVox 6600.

There wasn't much helpfulness in the exception, but the error code means:

28558: SQL Server CE encountered problems in creating the SQL Server CE
database.

Any idea why this would fail on one device when it seems to have worked with
many others?

Apparently it has worked occassionally on the storage card just after a soft
reset.

This is CF 1.0, SQL CE 2.0.

Nathan

 

[Darren Shaffer]

Please post your SQL CE/SQL Mobile questions at
microsoft.public.sqlserver.ce

I have seen this with one other project where 100 devices,
all identical, run SQL CE with no problems and device
number 101 exhibits strange behavior. If your database
is on a memry card on the one device that's causing you
trouble, try hard resetting the device and placing the
db on main memory. That will tell you if it's a bad card.

If that's not the problem, hard reset, reinstall the SQL CE
CABs and try again.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Nathan]

Please post your SQL CE/SQL Mobile questions at
microsoft.public.sqlserver.ce

I have seen this with one other project where 100 devices,
all identical, run SQL CE with no problems and device
number 101 exhibits strange behavior. If your database
is on a memry card on the one device that's causing you
trouble, try hard resetting the device and placing the
db on main memory. That will tell you if it's a bad card.

If that's not the problem, hard reset, reinstall the SQL CE
CABs and try again.

What server hosts that other newsgroup? It's not on news.microsoft.com.

This isn't very encouraging. I don't normally ask my customers to hard reset
their device several times, but I could ask them to try a database in main
memory.

But I do take from your description that it could be a card that SQL CE
doesn't like (even though other applications may be fine with it.)

Is it more likely to be a finkicky card than a finicky device?

Nathan

 

[Darren Shaffer]

yes, I'd suspect the card before the device.

newgroup: microsoft.public.sqlserver.ce is on
news.microsoft.com

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Nathan]

Ok, I just had to reset my newsreader.

I'll try to get some idea whether this is a storage card issue.

Nathan