random error occuring - cannot find dbnetlib.dll

[Milsnips]

Hi there,

i have a random error that occurs when trying to connect to a remote
database, i think on initialization of the SQLConnection object via my
device, it randomly returns the error "cannot find "dbnetlib.bll", i cant
quite replicate when it occurs but my solution is to soft reset the device
(iMate JAMin) and wait 1-2mins for it to reboot which is a pain.

I have everything installed the latest version (sql server 2005 compact
edition: following cab files):

1. sql.dev.ENU.ppc.wce5.armv4i.CAB
2. sql.ppc.wce5.armv4i.CAB
3. sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
4. sqlce30.ppc.wce5.armv4i.CAB
5. sqlce30.repl.ppc.wce5.armv4i.CAB

I think that i could say i never had this problem until i put on the new
version of sql server compact edition 2005 files, so im wondering if this
may be some bug somewhere?

Any help appreciated,
thanks,
Paul

 

[Ginny Caughey [MVP]]

Paul,

I haven't encountered your specific problem, but I have had issues in the
past when the error message indicated that it couldn't find a dll when in
fact there just wasn't enough memory to load it. I was able to work around
the issue by making sure those dlls were loaded early in my app's execution
by referencing a type that required them.

 

[Milsnips]

Hi Ginny,

Ok, i reference SQLConnection in 2 places, so i'll create the object at the
beginning of the app, then just open it and close it where needed.

I dont think memory is a problem, as i have nothing else installed on the
PDA except for NETCF2.0, sql files, and my app which is in total 1MB inc.
database SDF file.

regards,
Paul.

 

[Ginny Caughey [MVP]]

Paul,

Please let me know if this helps. I'm interested in this issue.

 

[Ilya Tumanov [MS]]

It does not matter if you have something installed or not as it's virtual
memory which gets low, not storage memory.


--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Milsnips]

Ok, i'll give it a try and re-code the connection to just initialize at the
start of my application, then open/close the connection as needed later on,
to see if the problem still occurs.

thanks,
Paul.