Mobile vs Compact - What changed?

What really changed from SQL Mobile to SQL Compact besides allowing the database to run on any desktop? Is there a document somewhere explaining the differences, I did not see anything?

I just changed my development machine over to SP1 and wondered what code I should be changing.

I am filling the database from my C++ Desktop app using ADO using the OLEDB provider Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 and using System.Data.SqlServerCe in my C# mobile app. Is that OLE provider valid with the new version or should it be *.COMPACT.3.1?

I thought there was now suppose to be some sort of automatic compaction, but I did not notice any new properties.

I would appreciate any insight into the changes.

Thanks,

Juan Foegen

From my understanding, SQL Server Compact edition is an updated version to SQL Server Mobile Edition. You can use the compact edition not only on the mobile devices, but also on various devices like Tablet PC's, desktop computers etc. Also they are trying to include lot of sync features in the future releases, as you can see now they released Sync Services for ADO.NET CTP, the next new sync model like Merge Replication and RDA and in the next version release of SQL Server Compact Framework 3.5 they are trying to include all these features.

You can visit http://blogs.msdn.com/stevelasker/ for more information on these changes.

However, the namespace System.Data.SqlServerCE is going to be same for all the releases as it was same in both SQL Server CE and SQL Server Mobile.

Thanks

Ravi.

|||The OLEDB provider has not changed name, as the 3.1 release mainly concerns lifting the restrictions on supported platforms. For detailed information on the new features and fixes in 3.1 (or 3.0.5300.0) see this kb article: http://support.microsoft.com/Default.aspx?kbid=920700|||

Thanks for all your help and other replies on this forum.

Mobile vs Compact - What changed?

What really changed from SQL Mobile to SQL Compact besides allowing the database to run on any desktop? Is there a document somewhere explaining the differences, I did not see anything?

I just changed my development machine over to SP1 and wondered what code I should be changing.

I am filling the database from my C++ Desktop app using ADO using the OLEDB provider Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 and using System.Data.SqlServerCe in my C# mobile app. Is that OLE provider valid with the new version or should it be *.COMPACT.3.1?

I thought there was now suppose to be some sort of automatic compaction, but I did not notice any new properties.

I would appreciate any insight into the changes.

Thanks,

Juan Foegen

From my understanding, SQL Server Compact edition is an updated version to SQL Server Mobile Edition. You can use the compact edition not only on the mobile devices, but also on various devices like Tablet PC's, desktop computers etc. Also they are trying to include lot of sync features in the future releases, as you can see now they released Sync Services for ADO.NET CTP, the next new sync model like Merge Replication and RDA and in the next version release of SQL Server Compact Framework 3.5 they are trying to include all these features.

You can visit http://blogs.msdn.com/stevelasker/ for more information on these changes.

However, the namespace System.Data.SqlServerCE is going to be same for all the releases as it was same in both SQL Server CE and SQL Server Mobile.

Thanks

Ravi.

|||The OLEDB provider has not changed name, as the 3.1 release mainly concerns lifting the restrictions on supported platforms. For detailed information on the new features and fixes in 3.1 (or 3.0.5300.0) see this kb article: http://support.microsoft.com/Default.aspx?kbid=920700|||

Thanks for all your help and other replies on this forum.

sql

Mobile SQL

Hi all,
I wonder if someone can help me with a management request that I have, which
I harldy see the point in asking but as they pay my wages I will. I
currently have both a 2000 & 2005 installations of SQL server running, will
remove 2000 once I have everything transfered and the DTS packs re-written i
s
SSIS, but I have been asked the following question by someone who likes to
use Access, what has been asked for is a way that they can run updates and
select query's etc on a local copy of a database, i.e. one that has been put
on their machine and then for me to sync any changes and run minor updates o
n
the server once the machine is back in the office and on the network....I
have suggested using something like VPN or other such software to connect to
the server remotely but the response wasn't very enthuastic. Any thoughts
about how I can go about this and what software I would need, thanks in
advance.
P.Phil wrote:
> Hi all,
> I wonder if someone can help me with a management request that I have, whi
ch
> I harldy see the point in asking but as they pay my wages I will. I
> currently have both a 2000 & 2005 installations of SQL server running, wil
l
> remove 2000 once I have everything transfered and the DTS packs re-written
is
> SSIS, but I have been asked the following question by someone who likes to
> use Access, what has been asked for is a way that they can run updates and
> select query's etc on a local copy of a database, i.e. one that has been p
ut
> on their machine and then for me to sync any changes and run minor updates
on
> the server once the machine is back in the office and on the network....I
> have suggested using something like VPN or other such software to connect
to
> the server remotely but the response wasn't very enthuastic. Any thoughts
> about how I can go about this and what software I would need, thanks in
> advance.
> P.
Hi Phil
You can try to look at Merge Replication as an "out of the box"
solution. If that can't do the job, I think you're left with a lot of
coding in your application, that can keeps track of all changes
happening both on the server and on each mobile user.
I've worked with a CRM system that used this to keep track on all
changes that was done on main, remote and mobile databases. In general
it worked, but it really required a lot of work to keep all the
databases consistent with the correct data.
You'll also have to think about error handling - i.e. what happens if 2
users have changed the same record to with different data? Which of the
changes are going to "survive"? What if a user deletes a record and
another user has changed this record on his system? Will the record than
has to be inserted again and should user 1 that deleted the record be
notified about that? What if he sees the record is back again and then
just deletes it again. What is then the reaction from user 2 that just
made some changes to that record. Now he suddenly hasn't got the record
any longer...etc...etc...etc. There are just so many scenarions you
have to think through if you wan't to set up this kind of "replication".
Of course it's something that can be done, but it's not as easy as it
sounds.
Regards
Steen|||Hi Steen,
Thanks for all your advice, some of the points that you brought up I had
considered but there were quite a few I hadn't. I think I will have another
go at convincing my employer that this is not the best way to go just for on
e
user to make the odd change to the database, it seems a whole lot of work.
Failing that I will begin coding, if nothing else it will keep me busy for a
while.
Thanks again, P
"Steen Persson (DK)" wrote:

> Phil wrote:
> Hi Phil
> You can try to look at Merge Replication as an "out of the box"
> solution. If that can't do the job, I think you're left with a lot of
> coding in your application, that can keeps track of all changes
> happening both on the server and on each mobile user.
> I've worked with a CRM system that used this to keep track on all
> changes that was done on main, remote and mobile databases. In general
> it worked, but it really required a lot of work to keep all the
> databases consistent with the correct data.
> You'll also have to think about error handling - i.e. what happens if 2
> users have changed the same record to with different data? Which of the
> changes are going to "survive"? What if a user deletes a record and
> another user has changed this record on his system? Will the record than
> has to be inserted again and should user 1 that deleted the record be
> notified about that? What if he sees the record is back again and then
> just deletes it again. What is then the reaction from user 2 that just
> made some changes to that record. Now he suddenly hasn't got the record
> any longer...etc...etc...etc. There are just so many scenarions you
> have to think through if you wan't to set up this kind of "replication".
> Of course it's something that can be done, but it's not as easy as it
> sounds.
> Regards
> Steen
>

Mobile SQL

Hi all,
I wonder if someone can help me with a management request that I have, which
I harldy see the point in asking but as they pay my wages I will. I
currently have both a 2000 & 2005 installations of SQL server running, will
remove 2000 once I have everything transfered and the DTS packs re-written is
SSIS, but I have been asked the following question by someone who likes to
use Access, what has been asked for is a way that they can run updates and
select query's etc on a local copy of a database, i.e. one that has been put
on their machine and then for me to sync any changes and run minor updates on
the server once the machine is back in the office and on the network....I
have suggested using something like VPN or other such software to connect to
the server remotely but the response wasn't very enthuastic. Any thoughts
about how I can go about this and what software I would need, thanks in
advance.
P.
Phil wrote:
> Hi all,
> I wonder if someone can help me with a management request that I have, which
> I harldy see the point in asking but as they pay my wages I will. I
> currently have both a 2000 & 2005 installations of SQL server running, will
> remove 2000 once I have everything transfered and the DTS packs re-written is
> SSIS, but I have been asked the following question by someone who likes to
> use Access, what has been asked for is a way that they can run updates and
> select query's etc on a local copy of a database, i.e. one that has been put
> on their machine and then for me to sync any changes and run minor updates on
> the server once the machine is back in the office and on the network....I
> have suggested using something like VPN or other such software to connect to
> the server remotely but the response wasn't very enthuastic. Any thoughts
> about how I can go about this and what software I would need, thanks in
> advance.
> P.
Hi Phil
You can try to look at Merge Replication as an "out of the box"
solution. If that can't do the job, I think you're left with a lot of
coding in your application, that can keeps track of all changes
happening both on the server and on each mobile user.
I've worked with a CRM system that used this to keep track on all
changes that was done on main, remote and mobile databases. In general
it worked, but it really required a lot of work to keep all the
databases consistent with the correct data.
You'll also have to think about error handling - i.e. what happens if 2
users have changed the same record to with different data? Which of the
changes are going to "survive"? What if a user deletes a record and
another user has changed this record on his system? Will the record than
has to be inserted again and should user 1 that deleted the record be
notified about that? What if he sees the record is back again and then
just deletes it again. What is then the reaction from user 2 that just
made some changes to that record. Now he suddenly hasn't got the record
any longer...etc...etc...etc. There are just so many scenarions you
have to think through if you wan't to set up this kind of "replication".
Of course it's something that can be done, but it's not as easy as it
sounds.
Regards
Steen
|||Hi Steen,
Thanks for all your advice, some of the points that you brought up I had
considered but there were quite a few I hadn't. I think I will have another
go at convincing my employer that this is not the best way to go just for one
user to make the odd change to the database, it seems a whole lot of work.
Failing that I will begin coding, if nothing else it will keep me busy for a
while.
Thanks again, P
"Steen Persson (DK)" wrote:

> Phil wrote:
> Hi Phil
> You can try to look at Merge Replication as an "out of the box"
> solution. If that can't do the job, I think you're left with a lot of
> coding in your application, that can keeps track of all changes
> happening both on the server and on each mobile user.
> I've worked with a CRM system that used this to keep track on all
> changes that was done on main, remote and mobile databases. In general
> it worked, but it really required a lot of work to keep all the
> databases consistent with the correct data.
> You'll also have to think about error handling - i.e. what happens if 2
> users have changed the same record to with different data? Which of the
> changes are going to "survive"? What if a user deletes a record and
> another user has changed this record on his system? Will the record than
> has to be inserted again and should user 1 that deleted the record be
> notified about that? What if he sees the record is back again and then
> just deletes it again. What is then the reaction from user 2 that just
> made some changes to that record. Now he suddenly hasn't got the record
> any longer...etc...etc...etc. There are just so many scenarions you
> have to think through if you wan't to set up this kind of "replication".
> Of course it's something that can be done, but it's not as easy as it
> sounds.
> Regards
> Steen
>

Mobile SQL

Hi all,
I wonder if someone can help me with a management request that I have, which
I harldy see the point in asking but as they pay my wages I will. I
currently have both a 2000 & 2005 installations of SQL server running, will
remove 2000 once I have everything transfered and the DTS packs re-written is
SSIS, but I have been asked the following question by someone who likes to
use Access, what has been asked for is a way that they can run updates and
select query's etc on a local copy of a database, i.e. one that has been put
on their machine and then for me to sync any changes and run minor updates on
the server once the machine is back in the office and on the network....I
have suggested using something like VPN or other such software to connect to
the server remotely but the response wasn't very enthuastic. Any thoughts
about how I can go about this and what software I would need, thanks in
advance.
P.Phil wrote:
> Hi all,
> I wonder if someone can help me with a management request that I have, which
> I harldy see the point in asking but as they pay my wages I will. I
> currently have both a 2000 & 2005 installations of SQL server running, will
> remove 2000 once I have everything transfered and the DTS packs re-written is
> SSIS, but I have been asked the following question by someone who likes to
> use Access, what has been asked for is a way that they can run updates and
> select query's etc on a local copy of a database, i.e. one that has been put
> on their machine and then for me to sync any changes and run minor updates on
> the server once the machine is back in the office and on the network....I
> have suggested using something like VPN or other such software to connect to
> the server remotely but the response wasn't very enthuastic. Any thoughts
> about how I can go about this and what software I would need, thanks in
> advance.
> P.
Hi Phil
You can try to look at Merge Replication as an "out of the box"
solution. If that can't do the job, I think you're left with a lot of
coding in your application, that can keeps track of all changes
happening both on the server and on each mobile user.
I've worked with a CRM system that used this to keep track on all
changes that was done on main, remote and mobile databases. In general
it worked, but it really required a lot of work to keep all the
databases consistent with the correct data.
You'll also have to think about error handling - i.e. what happens if 2
users have changed the same record to with different data? Which of the
changes are going to "survive"? What if a user deletes a record and
another user has changed this record on his system? Will the record than
has to be inserted again and should user 1 that deleted the record be
notified about that? What if he sees the record is back again and then
just deletes it again. What is then the reaction from user 2 that just
made some changes to that record. Now he suddenly hasn't got the record
any longer...etc...etc...etc. There are just so many scenarions you
have to think through if you wan't to set up this kind of "replication".
Of course it's something that can be done, but it's not as easy as it
sounds.
Regards
Steen|||Hi Steen,
Thanks for all your advice, some of the points that you brought up I had
considered but there were quite a few I hadn't. I think I will have another
go at convincing my employer that this is not the best way to go just for one
user to make the odd change to the database, it seems a whole lot of work.
Failing that I will begin coding, if nothing else it will keep me busy for a
while.
Thanks again, P
"Steen Persson (DK)" wrote:
> Phil wrote:
> > Hi all,
> >
> > I wonder if someone can help me with a management request that I have, which
> > I harldy see the point in asking but as they pay my wages I will. I
> > currently have both a 2000 & 2005 installations of SQL server running, will
> > remove 2000 once I have everything transfered and the DTS packs re-written is
> > SSIS, but I have been asked the following question by someone who likes to
> > use Access, what has been asked for is a way that they can run updates and
> > select query's etc on a local copy of a database, i.e. one that has been put
> > on their machine and then for me to sync any changes and run minor updates on
> > the server once the machine is back in the office and on the network....I
> > have suggested using something like VPN or other such software to connect to
> > the server remotely but the response wasn't very enthuastic. Any thoughts
> > about how I can go about this and what software I would need, thanks in
> > advance.
> >
> > P.
> Hi Phil
> You can try to look at Merge Replication as an "out of the box"
> solution. If that can't do the job, I think you're left with a lot of
> coding in your application, that can keeps track of all changes
> happening both on the server and on each mobile user.
> I've worked with a CRM system that used this to keep track on all
> changes that was done on main, remote and mobile databases. In general
> it worked, but it really required a lot of work to keep all the
> databases consistent with the correct data.
> You'll also have to think about error handling - i.e. what happens if 2
> users have changed the same record to with different data? Which of the
> changes are going to "survive"? What if a user deletes a record and
> another user has changed this record on his system? Will the record than
> has to be inserted again and should user 1 that deleted the record be
> notified about that? What if he sees the record is back again and then
> just deletes it again. What is then the reaction from user 2 that just
> made some changes to that record. Now he suddenly hasn't got the record
> any longer...etc...etc...etc. There are just so many scenarions you
> have to think through if you wan't to set up this kind of "replication".
> Of course it's something that can be done, but it's not as easy as it
> sounds.
> Regards
> Steen
>

Mobile sdf File created on Server

Hi there,

Background: I've created an application to run on windows mobile 5.0 devices. It replicates to a publication on a server. To do this it goes through ASP.net. This creates the database on the Mobile Devices.

Issue: Problem is the initial download of the database is taking 2hours plus to replicate (create) for the first time. So I'm trying to create the .sdf file on the server, zip it, and send it across to the handheld. All subsequent replications take about 5 minutes.

Question: Does anyone know how, or have examples for creating a Mobile CE database on the server. I need to create it using ASP.net and go through a pre-existing publication where a hostname used for filtering.

http://msdn2.microsoft.com/en-us/library/ms173009.aspx explains how to create this in SQL Server Management Stuidio. How do you do the same thing over ASP?

Can this be done using SMO? How do you create a SQLServerCompactEdition database using normal .NET Framework? Thanks for your help!!

Is it possible to access System.Data.SqlServerCe namespace without using the .NET Compact Framework?

So if I wanted to access the assembly in a VB.NET Windows App inside the .NET Framework, is this possible?

|||

Yes, SQL CE 3.1 allows you to do that. There’s a special version of SQL CE provider for desktop framework.

|||You can run code like in this sample (http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcereplication.synchronize.aspx

on your web server. create the file to the local file system and zip it. Then give the device the URL to the .zip file and your .NET Compact Framework app can the download the .zip file using HttpWebRequest class and unzip.

|||

So the problem i was having was in using an assembly that came with the compact framework. The System.Data.SqlServerCE.dll file is located in at least two places on my machine. One in the CE and one in the Common folder...both have the same name and version number.

I changed the reference from pointing at the CE version to the normal version and it cleared up the problem. Thanks for the responses, I'm still not sure what the differences in the assemblies are.

Mobile sdf File created on Server

Hi there,

Background: I've created an application to run on windows mobile 5.0 devices. It replicates to a publication on a server. To do this it goes through ASP.net. This creates the database on the Mobile Devices.

Issue: Problem is the initial download of the database is taking 2hours plus to replicate (create) for the first time. So I'm trying to create the .sdf file on the server, zip it, and send it across to the handheld. All subsequent replications take about 5 minutes.

Question: Does anyone know how, or have examples for creating a Mobile CE database on the server. I need to create it using ASP.net and go through a pre-existing publication where a hostname used for filtering.

http://msdn2.microsoft.com/en-us/library/ms173009.aspx explains how to create this in SQL Server Management Stuidio. How do you do the same thing over ASP?

Can this be done using SMO? How do you create a SQLServerCompactEdition database using normal .NET Framework? Thanks for your help!!

Is it possible to access System.Data.SqlServerCe namespace without using the .NET Compact Framework?

So if I wanted to access the assembly in a VB.NET Windows App inside the .NET Framework, is this possible?

|||

Yes, SQL CE 3.1 allows you to do that. There’s a special version of SQL CE provider for desktop framework.

|||You can run code like in this sample (http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcereplication.synchronize.aspx

on your web server. create the file to the local file system and zip it. Then give the device the URL to the .zip file and your .NET Compact Framework app can the download the .zip file using HttpWebRequest class and unzip.

|||

So the problem i was having was in using an assembly that came with the compact framework. The System.Data.SqlServerCE.dll file is located in at least two places on my machine. One in the CE and one in the Common folder...both have the same name and version number.

I changed the reference from pointing at the CE version to the normal version and it cleared up the problem. Thanks for the responses, I'm still not sure what the differences in the assemblies are.

sql

Mobile Replication

Dear All,

I need to make Sql Server Mobile replication with Sql Server 2005, could any body tell where can I find step by step procedure to make this?

Thanks and Regards

This article will get you started with using replication with SQL Server Mobile

http://msdn2.microsoft.com/en-us/library/ms171801.aspx

Using Merge Replication with SQL Mobile

http://msdn2.microsoft.com/en-us/library/ms172407.aspx

|||

Hi,

I follow the steps mentioned in http://msdn2.microsoft.com/en-us/library/ms171908.aspx

but when I try to run the replication agent I get the following error:

Executed as user: cat-10g\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.

any advise?

Thank s and regards

|||

hi

it worked only after adding the snapshot_agent user to administrators group.

thanks

|||Hi,

I'm a newbe SQL Server developer and had been facing the exact same problem for few days. I could finally start the agent. Thanks ataha.

In addition, I also tried if other user group would work since I didn't want to give full administrator rights to the snapshot_agent. Then I found several SQL Server 2005 related groups are added after SQL Server 2005 was installed. I put snapshot_agent to SQLServer2005SQLAgentUser$computername$instancename and it worked. It's still administrator but I think it's somewhat better than it.

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Thanks again.

Mobile Replication

Dear All,

I need to make Sql Server Mobile replication with Sql Server 2005, could any body tell where can I find step by step procedure to make this?

Thanks and Regards

This article will get you started with using replication with SQL Server Mobile

http://msdn2.microsoft.com/en-us/library/ms171801.aspx

Using Merge Replication with SQL Mobile

http://msdn2.microsoft.com/en-us/library/ms172407.aspx

|||

Hi,

I follow the steps mentioned in http://msdn2.microsoft.com/en-us/library/ms171908.aspx

but when I try to run the replication agent I get the following error:

Executed as user: cat-10g\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.

any advise?

Thank s and regards

|||

hi

it worked only after adding the snapshot_agent user to administrators group.

thanks

|||Hi,

I'm a newbe SQL Server developer and had been facing the exact same problem for few days. I could finally start the agent. Thanks ataha.

In addition, I also tried if other user group would work since I didn't want to give full administrator rights to the snapshot_agent. Then I found several SQL Server 2005 related groups are added after SQL Server 2005 was installed. I put snapshot_agent to SQLServer2005SQLAgentUser$computername$instancename and it worked. It's still administrator but I think it's somewhat better than it.

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Thanks again.

Mobile replication

I have the following setup

Server 1: Windows 2003 inc IIS. Also on this server is SQL Server Web sync web service and it has an external IP address for internet connectivity

Server 2: Windows 2003 inc SQL Server 2005. This server has a database setup with replication so the a Window Mobile 5 device can do a merge replication.

My problem is that the replication fails when trying to send the snap shot from Server 2 to the mobile device. The device seems to get through to the replication agent, as entries in the Replication monitor are logged (see below).

I have checked all the permissions on the relevant shares required for replication (basically set "Everyone" with full access).

My initial question would be.... When the snapshot is been sent to the mobile device, does the SQL Server try to send it directly to the internet or does it go through "SQL Server Mobile Server Agent 3.0".

Please can someone help, as this is causing me some REAL problems.

Error messages:
The schema script '\\ukrt1-sql902\SQLRepl\unc\UKRT1-SQL902_EXEL_DAMAGECODESEXEL\20060810142533\DamageAction_2.sch'
could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147023570)
Get help: http://help/MSSQL_REPL-2147023570

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization,
the merge process may have been unable to create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and specify an output file to which to write.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001

I fixed this issue....

The snapshot directory on the datbase server didnt have the correct permissions. This is because the SQL Agent on the IIS server was setup with the default user... The IIS default...

mobile phone and databases

Can you please tell me what are the risks of customers using a mobile phone to send a request of information which will be automatically responded to as an entry is made into the database.

How do I ensure that the data intergrity is maintained, as this 'Table' in the database will take in many request a day and repond based on what the customer has type in on the text message.

I did not get your point. What are you trying to do ? Sending a message to a Service, processing it in the database and sending the processed data, evtl. with a customized text back to the caller ? Data integrity should be maintained either through constraint rules (Whatever rules you have) or your logic you are trying to implement in the midtier or the database level.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Mobile Only? Why?

I've just finished installing the workstation tools from the SQL Server 2005
DVD (No database engine).
I've also installed Visual Studio 2005, with just the VB option and the
other standard stuff.
When I start the Management Studio, connect to a server (doesn't matter what
version), then open a new query, the query is disconnected and the only
connection option is for SQL Server Mobile.
Anyone have any ideas?
I've installed (and repaired) the native client. I can browse servers and
see objects, etc., just no queries. I've installed/uninstalled three times.
Thanks all.
Am I correct that you are talking about the New Query dialog box in
Management Studio? On the File menu, point to New, do you see Database
Engine Query as one of the choices?
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
> I've just finished installing the workstation tools from the SQL Server
> 2005 DVD (No database engine).
> I've also installed Visual Studio 2005, with just the VB option and the
> other standard stuff.
> When I start the Management Studio, connect to a server (doesn't matter
> what version), then open a new query, the query is disconnected and the
> only connection option is for SQL Server Mobile.
> Anyone have any ideas?
> I've installed (and repaired) the native client. I can browse servers and
> see objects, etc., just no queries. I've installed/uninstalled three
> times.
> Thanks all.
>
|||Yes, the dropdown (to select a provider) is disabled with SQL Server Mobile
being the selected item.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Am I correct that you are talking about the New Query dialog box in
> Management Studio? On the File menu, point to New, do you see Database
> Engine Query as one of the choices?
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:u3yzF5H7FHA.1020@.TK2MSFTNGP15.phx.gbl...
>
|||I've shopped your e-mail around Microsoft a bit, and we can't think of any
reasonable way you could get into that condition. The obvious but cop-out
answer is that either Management Studio or the underlying Visual Studio is
somehow damaged. It's less likely to be related to the SQL Native Client.
Some more questions:
Are you using the RTM version of SQL Server Management Studio?
How consistent is this problem? That is, there are several ways to open the
Connect to Server dialog box in Management Studio:
- On the File menu, point to New, and then click Database Engine Query
- On the Standard toolbar, click New Query
- On the Standard toolbar, click Database Engine Query
- On the Object Explorer toolbar, click Connect, and then click Database
Engine
Do you only get SQL Server Mobile with any of those ways?
What about registering servers? On the View menu click Register Servers. In
the Registered Servers window toolbar, click Database Engine. Now can you
register a Database Engine by right-clicking Database Engine, point to New,
and then click Server Registration? Now is the Server type listed as
"Database Engine"?
Can you connect to the Database Engine from the Server Explorer of Visual
Studio?
(I'm interested in assisting you but I will not be available again until
Monday. Sorry. Holiday plans.)
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
> Yes, the dropdown (to select a provider) is disabled with SQL Server
> Mobile being the selected item.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23WgVl5s7FHA.1420@.TK2MSFTNGP09.phx.gbl...
>
|||Yes, I'm using the version handed out in Vegas at the launch.
I have tried all the connection methods detailed below with the same
results. I am able to register, and connect to a database server and browse
objects, etc.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
> I've shopped your e-mail around Microsoft a bit, and we can't think of any
> reasonable way you could get into that condition. The obvious but cop-out
> answer is that either Management Studio or the underlying Visual Studio is
> somehow damaged. It's less likely to be related to the SQL Native Client.
> Some more questions:
> Are you using the RTM version of SQL Server Management Studio?
> How consistent is this problem? That is, there are several ways to open
> the Connect to Server dialog box in Management Studio:
> - On the File menu, point to New, and then click Database Engine Query
> - On the Standard toolbar, click New Query
> - On the Standard toolbar, click Database Engine Query
> - On the Object Explorer toolbar, click Connect, and then click Database
> Engine
> Do you only get SQL Server Mobile with any of those ways?
> What about registering servers? On the View menu click Register Servers.
> In the Registered Servers window toolbar, click Database Engine. Now can
> you register a Database Engine by right-clicking Database Engine, point to
> New, and then click Server Registration? Now is the Server type listed as
> "Database Engine"?
> Can you connect to the Database Engine from the Server Explorer of Visual
> Studio?
> (I'm interested in assisting you but I will not be available again until
> Monday. Sorry. Holiday plans.)
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:%235DXeAt7FHA.2816@.tk2msftngp13.phx.gbl...
>
|||If you can browse objects, I presume that means you can connect with Object
Explorer. What happens in Object Explorer if you right-click a database, and
then click New Query? You should get a Database Engine query window. Does
that work? This will tell us if the Query Editor is working properly.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
> Yes, I'm using the version handed out in Vegas at the launch.
> I have tried all the connection methods detailed below with the same
> results. I am able to register, and connect to a database server and
> browse objects, etc.
>
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:%23Ukue367FHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||It comes up as a disconnected query. When I right-click in the query window
and select connect, the connection dialog appears.
In this dialog, the dropdown (to select a provider) is disabled and SQL
Server Mobile is the selected item.
Thanks.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
> If you can browse objects, I presume that means you can connect with
> Object Explorer. What happens in Object Explorer if you right-click a
> database, and then click New Query? You should get a Database Engine query
> window. Does that work? This will tell us if the Query Editor is working
> properly.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OVXgegF9FHA.808@.TK2MSFTNGP09.phx.gbl...
>
|||I sorry. I know this must be frustrating for you, but I can think of no
reason for this. Since you have already uninstalled and reinstalled that
should have fixed any damaged binaries or registry entries. I'm out of
ideas. I guess that means you need a call to product support.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
> It comes up as a disconnected query. When I right-click in the query
> window and select connect, the connection dialog appears.
> In this dialog, the dropdown (to select a provider) is disabled and SQL
> Server Mobile is the selected item.
> Thanks.
> "Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
> news:O5X4uld9FHA.3360@.TK2MSFTNGP11.phx.gbl...
>
|||Thanks for trying, anyway.
I'm out of ideas, also. I have successfully installed it on a second
workstation and laptop, both more or less identically configured.
It's probably about time I rebuilt this one anyway, it's been five years...
Thanks again.
Dave
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:eyd$Pyp9FHA.952@.TK2MSFTNGP12.phx.gbl...
>I sorry. I know this must be frustrating for you, but I can think of no
>reason for this. Since you have already uninstalled and reinstalled that
>should have fixed any damaged binaries or registry entries. I'm out of
>ideas. I guess that means you need a call to product support.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "David Pendleton" <qnircra@.gpd.arg> wrote in message
> news:OYVPHzo9FHA.500@.TK2MSFTNGP15.phx.gbl...
>
sql

mobile friendly report

Is there anyway to have the scheduled report feature send a report that is
formated more for a mobile screen like a blackberry screen. I know it can
send an attachment as a spreadsheet or html to open up in the blackberry
screen, but, I was hoping if there was a way to setup the report to display
in simple text and not as an attachment. I hope this makes sense.
Thanks for your help in advance.
MArcI have the same problem. I have tried to deliver email messages with MHTML
content, but it is not displaying appropiately. I'm wondering about a
possibility to send plain text messages, but up to know I did not find this
possibility.
Another solution would be having the possibility to manage the HTML
generated, but I don't know whether this is possible.
Any help?
Thanks
Baldi
"Bed Guy" wrote:
> Is there anyway to have the scheduled report feature send a report that is
> formated more for a mobile screen like a blackberry screen. I know it can
> send an attachment as a spreadsheet or html to open up in the blackberry
> screen, but, I was hoping if there was a way to setup the report to display
> in simple text and not as an attachment. I hope this makes sense.
> Thanks for your help in advance.
> MArc

Mobile Device Database Develpment Problems

Hi, Guys

I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.

The following is my development enviroment

Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2

First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.

Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.

I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.

I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.

Can someone help me out?

Thanks.

That usually means SQL Server database is setup with collation not supported on your device. E.g. you have English device and database uses Chinese collation. There are two ways to fix it:

1. Change collation of the database to whatever device supports.

2. Get device which supports collation of the database.

Another possible reason for that issues might be what some dependencies are missing in the OS image. You should contact device OEM in that case.

|||

it is working, after Change collation of the database to Latin1.....

Thanks a lot

Mobile Database Security

i research about mobile database security. please link all resources about this issue. thank you.WHat do you want to achieve or what is problem with that ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||i want resources about algorithms, protocols and all rules for secure mobile database. i google but few and poor content is listed. i want references for this issue.|||

You might look into the latest BOoks online update for SQL Server 2005, it has various options and information on the aspect of security.

http://msdn2.microsoft.com/en-us/library/ms171955.aspx

http://support.microsoft.com/kb/314783

http://vyaskn.tripod.com/sql_server_security_distilled.htm

sql

Mobile Application Enquiry

Hi,

I've found guides on creating a mobile application but everything is on 1 computer.

What i'd like to do is to seperate into 3 parts for added security.

One is used to store the Database.

One is used as an IIS Server (Web Server).

One is used as a Deployment Server.

Is there a step-by-step guide to this setup?

Though there is no step-by-step guide separately for multi-machine or multi-box scenario the same step-by-step guide @. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp can be taken for configuring the merge replication. Please note that you can not use the default anonymous account with IIS in multi-box mode as default anonymous account in IIS is IUSR_MachineName which is a local user and is not understandable by other boxes in the infrastructure.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

Thx.
Its a good guide but still there are certain areas which i'm not sure where i should be working on for the split server configuration. Might i suggest for a guide to be done?

Also is there a step-by-step guide for Data Retrieval on Smartphones using Visual Basic.NET?

Thanks again.

|||

May be this thread @. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=213973&SiteID=1 can help you!

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.
phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2M
SFTNGP02.phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

MissingMethodException

I am getting a missing method exception when I call any SqlCE method on my Windows Mobile 5, Pocket PC.

This works fine using the emulator through Visual Studio 2005, but not on the actual device. Programs run fine on the device when they are not using SqlCe.

My question is what do I need to sort this problem, as I am guessing I am missing a CAB file.

I have manually installed:
sql.dev.ENU.wce5.armv4i.CAB
sql.wce5.armv4i.CAB
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.wce5.arm4vi.CAB
sqlce30.repl.wce5.armv4i.CAB

Query Analyser is working on the device, I have created a database, with one table and a row of data with no problem.

Any suggestions would be much appreciated.

Thanks.
(I think) i have a similar problem...i use sqlce to access a database and it works fine, but when i change the query i some simple math functions (+,*,-), it works using the emulator, but not in the device...

thank you.