SQL Mobile Resource Dll

[Mark Dykun]

With Version 2.0 of SQL CE there was a seperate DLL that could be installed,
providing the verbose error messages for the engine. I cannot seem to find
the same thing for SQL Mobile 3.0. When we first execute a query through it
an first chance exception is thrown and when I get the stack trace the
following details are displayed. As such it looks as if SQL Mobile is
looking for that dll and throwing this exception. It is not causing any
operational problems as it seem to be handled internally but from a
performance point of view any thrown exceptions slows down the application
on a PPC. Understanding that this would be a common situation as most end
users would not have this dll it is unfortunate that the initial file check
was not done and gracefully handled. Anyways does anyone know where this dll
would be located?

Thanks in advance,
Mark

System.IO.FileNotFoundException occurred
Message="FileNotFoundException"
StackTrace:
at System.Reflection.Assembly.InternalGetSatelliteAssembly()
at System.Reflection.Assembly.GetSatelliteAssembly()
at System.Resources.ResourceManager.InternalGetResourceSet()
at System.Resources.ResourceManager.InternalGetResourceSet()
at System.Resources.ResourceManager.GetString()
at System.Resources.ResourceManager.GetString()
at System.SRSupport.HasString()
at System.SRSupport.HasString()
at System.Data.Res.HasString()
at System.Data.SqlTypes.SQLResource..cctor()
at System.Data.SqlServerCe.SqlMetaData..cctor()
at System.Data.SqlServerCe.MetaData..ctor()
at System.Data.SqlServerCe.SqlCeDataReader.PopulateMetaData()
at System.Data.SqlServerCe.SqlCeDataReader.FillMetaData()
at System.Data.SqlServerCe.SqlCeDataReader.FillMetaData()
at System.Data.SqlServerCe.SqlCeCommand.InitializeDataReader()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar()
at Corum.Mobile.Database.SQLCEDatabase.ExecuteSQLReturnScalar()
at Corum.Mobile.Database.SQLCEDatabase.CheckVersion()
at Corum.Mobile.Database.ClientSQLCEDatabase.Open()

 

[Darren Shaffer]

Mark,

Did you install both the SQL Mobile engine *and* dev tools on your device or
emulator?

You will find the dev tools CAB at:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v3.0\wce400\armv4
or
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v3.0\wce500\armv4i

it has *.dev.* in the CAB name and contains the DLL you need for verbose
error messages.


Here is a quick guide to the SQL Mobile DLLs and what they do:

- SQLCESE30.DLL - Storage Engine

- SQLCEQP30.DLL - Query Processor

- SQLCECA30.DLL - Client Agent

- SQLCESA30.DLL - Server Agent

- SQLCERP30.DLL - Replication Provider

- SQLCEME30.DLL - Managed Extensions

- SQLCEOLEDB30.DLL - OLE-DB Provider

- SQLCEER30xx.DLL - Error Strings Localized in locale 'xx' Where xx
belongs to {EN, TW, CN, DE, ES, FR, IT, JA, KO}

Finally, there is a forum dedicated to questions on SQL CE and SQL Mobile
which I moderate over at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

The CF Forum is not usually the best place for advanced questions about SQL
Mobile.

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