has anyone else experienced this where you have areas on BIDS set to auto
hide (like dataset or solution or properties) and they DONT autohide always
... I end up having to toggle autohide off and on again to make it hide ...
this is getting really annoying.I have it all the time. I have come across some really bad bugs in this
version. Auto-hide not working being one of them. Seems small at first, but
when you have to do it about 100 times a day, it becomes very frustrating.
They need to get this fixed. I don't remember having it in VS2003.
"MJT" wrote:
> has anyone else experienced this where you have areas on BIDS set to auto
> hide (like dataset or solution or properties) and they DONT autohide always
> ... I end up having to toggle autohide off and on again to make it hide ...
> this is getting really annoying.|||I havent even mentioned how many times I have received the message that
visual studio cannot close because there is a modal dialog active ... when I
have closed absolutely EVERY WINDOW in the tool ... there is nothing but a
SHELL left... so I end up having to force the task to end with task manager
... not a good thing. I am talking about the scaled down version of VS2005
that comes with reporting services ... not the full-blown install of VS2005.
Seems it should be addressed and fixed.
"bsod55" wrote:
> I have it all the time. I have come across some really bad bugs in this
> version. Auto-hide not working being one of them. Seems small at first, but
> when you have to do it about 100 times a day, it becomes very frustrating.
> They need to get this fixed. I don't remember having it in VS2003.
> "MJT" wrote:
> > has anyone else experienced this where you have areas on BIDS set to auto
> > hide (like dataset or solution or properties) and they DONT autohide always
> > ... I end up having to toggle autohide off and on again to make it hide ...
> > this is getting really annoying.
Showing posts with label experienced. Show all posts
Showing posts with label experienced. Show all posts
Monday, March 19, 2012
BIDS abort
On several occasions I have experienced crashes while running an SSIS package in debug mode. It happens when I start process on Control Flow table and click on Data Flow tab to monitor progress. I have forwarded the error reports and have searched the boards for similar references. Is this problem going to be fixed?
SSIS Data Sources
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
-
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Visiual Studio 2005 Professional SP1 SP.050727-7600
.NET Framework 2.0.50727
Any specific error? That might help us.Thursday, February 16, 2012
best way to learn SQL Server
I am an experienced database developer who has worked primarily with
Unidata (a multi-value database). I wish to learn SQL Server, but will
need to do this at home on my own. The only machine I have available is
my laptop running Win XP sp2. I know I can download the SQL Server
2005 trial version or Express Edition, but I need to know if it's
possible to install either of these as a standalone on my laptop. (i.e.
my laptop would be both the server and client.)
If it is possible to run as a standalone? Do I need to install .net and
IIS? Has anyone successfully done this that can give me some pointers
or refer me to some good documentation on how to do this?
Thanks in advance!!
Tim> The only machine I have available
> is my laptop running Win XP sp2.
It could be good. How much RAM?
> I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop.
> (i.e. my laptop would be both the server and client.)
Yes, you can. I did too.
> If it is possible to run as a standalone?
What do you mean? SQL Server installs as a system service, so you need a
client application to use it.
If you intend "may I have the server and the client on the same phisical
pc?", then that's ok.
> Do I need to install .net
Yes, version 2.0.
> and IIS?
This is necessary only if you want to install "SQL Server 2005 Express with
Advanced Services" and want to use Interation Services (e.g. Reporting Services).
> Has anyone successfully done this that can give me some
> pointers or refer me to some good documentation on how to do this?
I have few problems.
First, install .NET framework 2.0.
Then, install SQL Server 2005 Express (or Express with Advanced Services).
I suppose you will have few problems, even if you'll follow setup wizards.
If you need more infos, post again :-)
--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution|||Hi
You can install SQL Server (excluding Enterprise Edition) without issue on
Windows XP SP2. SQL Express is free to install does not come with all the
tools you would get with the other versions. You can also download SQL
Express Manager to manage your SQL Express instance. SQL Express can also be
installed as part of Visual Studio 2005.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx shows
which features are supported by which edition. Developer edition has all the
features of Enterprise Edition, but is not licenced for a production system.
This is only $50. System requirements can be found at
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx or
http://www.microsoft.com/sql/editions/express/sysreqs.mspx
You will need to install .NET framework during or before (Express edition)
installing SQL Server if this is not already on your system.
John
"tmags23@.gmail.com" wrote:
> I am an experienced database developer who has worked primarily with
> Unidata (a multi-value database). I wish to learn SQL Server, but will
> need to do this at home on my own. The only machine I have available is
> my laptop running Win XP sp2. I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop. (i.e.
> my laptop would be both the server and client.)
> If it is possible to run as a standalone? Do I need to install .net and
> IIS? Has anyone successfully done this that can give me some pointers
> or refer me to some good documentation on how to do this?
> Thanks in advance!!
> Tim
>|||Hi
I forgot to add, the virtual labs and webcasts on MSDN and Technet are
excellent sources of information for someone wishing to learn SQL Server.
John
"John Bell" wrote:
> Hi
> You can install SQL Server (excluding Enterprise Edition) without issue on
> Windows XP SP2. SQL Express is free to install does not come with all the
> tools you would get with the other versions. You can also download SQL
> Express Manager to manage your SQL Express instance. SQL Express can also be
> installed as part of Visual Studio 2005.
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx shows
> which features are supported by which edition. Developer edition has all the
> features of Enterprise Edition, but is not licenced for a production system.
> This is only $50. System requirements can be found at
> http://www.microsoft.com/sql/editions/developer/sysreqs.mspx or
> http://www.microsoft.com/sql/editions/express/sysreqs.mspx
> You will need to install .NET framework during or before (Express edition)
> installing SQL Server if this is not already on your system.
> John
> "tmags23@.gmail.com" wrote:
> > I am an experienced database developer who has worked primarily with
> > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > need to do this at home on my own. The only machine I have available is
> > my laptop running Win XP sp2. I know I can download the SQL Server
> > 2005 trial version or Express Edition, but I need to know if it's
> > possible to install either of these as a standalone on my laptop. (i.e.
> > my laptop would be both the server and client.)
> >
> > If it is possible to run as a standalone? Do I need to install .net and
> > IIS? Has anyone successfully done this that can give me some pointers
> > or refer me to some good documentation on how to do this?
> >
> > Thanks in advance!!
> >
> > Tim
> >
> >|||Take a look into the below URL:-
http://msdn2.microsoft.com/en-us/library/ms143516.aspx
Thanks
Hari
<tmags23@.gmail.com> wrote in message
news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
>I am an experienced database developer who has worked primarily with
> Unidata (a multi-value database). I wish to learn SQL Server, but will
> need to do this at home on my own. The only machine I have available is
> my laptop running Win XP sp2. I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop. (i.e.
> my laptop would be both the server and client.)
> If it is possible to run as a standalone? Do I need to install .net and
> IIS? Has anyone successfully done this that can give me some pointers
> or refer me to some good documentation on how to do this?
> Thanks in advance!!
> Tim
>|||Thanks all for the great info. Sounds like I'm in business.
My laptop has 512MB of RAM, so that shouldn't be an issue. I downloaded
the .net framework and the Express edition. But I forgot to look for
the version with Advanced Services so I'll look for that instead.
Thanks also for the reminder about Express Manager. I'll grab that too.
One final question. Apparently IIS isn't supported in XP Home. Could I
still install it? (By the time I get to Reporting Services and need IIS
I'll probably have another box up and running with Windows 2000, but I
still would like to know if it's possible.)
Also I read there are some potential conflicts with Windows Firewall
blocking the port that SQL server listens on, but if I havve the server
and client on the same physical box that shoudn't be a problem, should
it?
Thanks again, and happy holidays!
Tim
Hari Prasad wrote:
> Take a look into the below URL:-
> http://msdn2.microsoft.com/en-us/library/ms143516.aspx
> Thanks
> Hari
> <tmags23@.gmail.com> wrote in message
> news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
> >I am an experienced database developer who has worked primarily with
> > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > need to do this at home on my own. The only machine I have available is
> > my laptop running Win XP sp2. I know I can download the SQL Server
> > 2005 trial version or Express Edition, but I need to know if it's
> > possible to install either of these as a standalone on my laptop. (i.e.
> > my laptop would be both the server and client.)
> >
> > If it is possible to run as a standalone? Do I need to install .net and
> > IIS? Has anyone successfully done this that can give me some pointers
> > or refer me to some good documentation on how to do this?
> >
> > Thanks in advance!!
> >
> > Tim
> >|||Hi Tim
If you are just working on the laptop as a standalone system then you should
have no problems with the firewall. If you wish to connect to the machine
from external machines then you will need specify the
DISABLENETWORKPROTOCOLS=0 on the command prompt for the installation see
http://msdn2.microsoft.com/en-us/library/ms143446.aspx SQLExpress with
Advanced Services only supports a subset of reporting services, so you will
be better trying that on different version.
Merry Christmas
John
"tmags" wrote:
> Thanks all for the great info. Sounds like I'm in business.
> My laptop has 512MB of RAM, so that shouldn't be an issue. I downloaded
> the .net framework and the Express edition. But I forgot to look for
> the version with Advanced Services so I'll look for that instead.
> Thanks also for the reminder about Express Manager. I'll grab that too.
> One final question. Apparently IIS isn't supported in XP Home. Could I
> still install it? (By the time I get to Reporting Services and need IIS
> I'll probably have another box up and running with Windows 2000, but I
> still would like to know if it's possible.)
> Also I read there are some potential conflicts with Windows Firewall
> blocking the port that SQL server listens on, but if I havve the server
> and client on the same physical box that shoudn't be a problem, should
> it?
> Thanks again, and happy holidays!
> Tim
> Hari Prasad wrote:
> > Take a look into the below URL:-
> >
> > http://msdn2.microsoft.com/en-us/library/ms143516.aspx
> >
> > Thanks
> > Hari
> >
> > <tmags23@.gmail.com> wrote in message
> > news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
> > >I am an experienced database developer who has worked primarily with
> > > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > > need to do this at home on my own. The only machine I have available is
> > > my laptop running Win XP sp2. I know I can download the SQL Server
> > > 2005 trial version or Express Edition, but I need to know if it's
> > > possible to install either of these as a standalone on my laptop. (i.e.
> > > my laptop would be both the server and client.)
> > >
> > > If it is possible to run as a standalone? Do I need to install .net and
> > > IIS? Has anyone successfully done this that can give me some pointers
> > > or refer me to some good documentation on how to do this?
> > >
> > > Thanks in advance!!
> > >
> > > Tim
> > >
>
Unidata (a multi-value database). I wish to learn SQL Server, but will
need to do this at home on my own. The only machine I have available is
my laptop running Win XP sp2. I know I can download the SQL Server
2005 trial version or Express Edition, but I need to know if it's
possible to install either of these as a standalone on my laptop. (i.e.
my laptop would be both the server and client.)
If it is possible to run as a standalone? Do I need to install .net and
IIS? Has anyone successfully done this that can give me some pointers
or refer me to some good documentation on how to do this?
Thanks in advance!!
Tim> The only machine I have available
> is my laptop running Win XP sp2.
It could be good. How much RAM?
> I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop.
> (i.e. my laptop would be both the server and client.)
Yes, you can. I did too.
> If it is possible to run as a standalone?
What do you mean? SQL Server installs as a system service, so you need a
client application to use it.
If you intend "may I have the server and the client on the same phisical
pc?", then that's ok.
> Do I need to install .net
Yes, version 2.0.
> and IIS?
This is necessary only if you want to install "SQL Server 2005 Express with
Advanced Services" and want to use Interation Services (e.g. Reporting Services).
> Has anyone successfully done this that can give me some
> pointers or refer me to some good documentation on how to do this?
I have few problems.
First, install .NET framework 2.0.
Then, install SQL Server 2005 Express (or Express with Advanced Services).
I suppose you will have few problems, even if you'll follow setup wizards.
If you need more infos, post again :-)
--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution|||Hi
You can install SQL Server (excluding Enterprise Edition) without issue on
Windows XP SP2. SQL Express is free to install does not come with all the
tools you would get with the other versions. You can also download SQL
Express Manager to manage your SQL Express instance. SQL Express can also be
installed as part of Visual Studio 2005.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx shows
which features are supported by which edition. Developer edition has all the
features of Enterprise Edition, but is not licenced for a production system.
This is only $50. System requirements can be found at
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx or
http://www.microsoft.com/sql/editions/express/sysreqs.mspx
You will need to install .NET framework during or before (Express edition)
installing SQL Server if this is not already on your system.
John
"tmags23@.gmail.com" wrote:
> I am an experienced database developer who has worked primarily with
> Unidata (a multi-value database). I wish to learn SQL Server, but will
> need to do this at home on my own. The only machine I have available is
> my laptop running Win XP sp2. I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop. (i.e.
> my laptop would be both the server and client.)
> If it is possible to run as a standalone? Do I need to install .net and
> IIS? Has anyone successfully done this that can give me some pointers
> or refer me to some good documentation on how to do this?
> Thanks in advance!!
> Tim
>|||Hi
I forgot to add, the virtual labs and webcasts on MSDN and Technet are
excellent sources of information for someone wishing to learn SQL Server.
John
"John Bell" wrote:
> Hi
> You can install SQL Server (excluding Enterprise Edition) without issue on
> Windows XP SP2. SQL Express is free to install does not come with all the
> tools you would get with the other versions. You can also download SQL
> Express Manager to manage your SQL Express instance. SQL Express can also be
> installed as part of Visual Studio 2005.
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx shows
> which features are supported by which edition. Developer edition has all the
> features of Enterprise Edition, but is not licenced for a production system.
> This is only $50. System requirements can be found at
> http://www.microsoft.com/sql/editions/developer/sysreqs.mspx or
> http://www.microsoft.com/sql/editions/express/sysreqs.mspx
> You will need to install .NET framework during or before (Express edition)
> installing SQL Server if this is not already on your system.
> John
> "tmags23@.gmail.com" wrote:
> > I am an experienced database developer who has worked primarily with
> > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > need to do this at home on my own. The only machine I have available is
> > my laptop running Win XP sp2. I know I can download the SQL Server
> > 2005 trial version or Express Edition, but I need to know if it's
> > possible to install either of these as a standalone on my laptop. (i.e.
> > my laptop would be both the server and client.)
> >
> > If it is possible to run as a standalone? Do I need to install .net and
> > IIS? Has anyone successfully done this that can give me some pointers
> > or refer me to some good documentation on how to do this?
> >
> > Thanks in advance!!
> >
> > Tim
> >
> >|||Take a look into the below URL:-
http://msdn2.microsoft.com/en-us/library/ms143516.aspx
Thanks
Hari
<tmags23@.gmail.com> wrote in message
news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
>I am an experienced database developer who has worked primarily with
> Unidata (a multi-value database). I wish to learn SQL Server, but will
> need to do this at home on my own. The only machine I have available is
> my laptop running Win XP sp2. I know I can download the SQL Server
> 2005 trial version or Express Edition, but I need to know if it's
> possible to install either of these as a standalone on my laptop. (i.e.
> my laptop would be both the server and client.)
> If it is possible to run as a standalone? Do I need to install .net and
> IIS? Has anyone successfully done this that can give me some pointers
> or refer me to some good documentation on how to do this?
> Thanks in advance!!
> Tim
>|||Thanks all for the great info. Sounds like I'm in business.
My laptop has 512MB of RAM, so that shouldn't be an issue. I downloaded
the .net framework and the Express edition. But I forgot to look for
the version with Advanced Services so I'll look for that instead.
Thanks also for the reminder about Express Manager. I'll grab that too.
One final question. Apparently IIS isn't supported in XP Home. Could I
still install it? (By the time I get to Reporting Services and need IIS
I'll probably have another box up and running with Windows 2000, but I
still would like to know if it's possible.)
Also I read there are some potential conflicts with Windows Firewall
blocking the port that SQL server listens on, but if I havve the server
and client on the same physical box that shoudn't be a problem, should
it?
Thanks again, and happy holidays!
Tim
Hari Prasad wrote:
> Take a look into the below URL:-
> http://msdn2.microsoft.com/en-us/library/ms143516.aspx
> Thanks
> Hari
> <tmags23@.gmail.com> wrote in message
> news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
> >I am an experienced database developer who has worked primarily with
> > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > need to do this at home on my own. The only machine I have available is
> > my laptop running Win XP sp2. I know I can download the SQL Server
> > 2005 trial version or Express Edition, but I need to know if it's
> > possible to install either of these as a standalone on my laptop. (i.e.
> > my laptop would be both the server and client.)
> >
> > If it is possible to run as a standalone? Do I need to install .net and
> > IIS? Has anyone successfully done this that can give me some pointers
> > or refer me to some good documentation on how to do this?
> >
> > Thanks in advance!!
> >
> > Tim
> >|||Hi Tim
If you are just working on the laptop as a standalone system then you should
have no problems with the firewall. If you wish to connect to the machine
from external machines then you will need specify the
DISABLENETWORKPROTOCOLS=0 on the command prompt for the installation see
http://msdn2.microsoft.com/en-us/library/ms143446.aspx SQLExpress with
Advanced Services only supports a subset of reporting services, so you will
be better trying that on different version.
Merry Christmas
John
"tmags" wrote:
> Thanks all for the great info. Sounds like I'm in business.
> My laptop has 512MB of RAM, so that shouldn't be an issue. I downloaded
> the .net framework and the Express edition. But I forgot to look for
> the version with Advanced Services so I'll look for that instead.
> Thanks also for the reminder about Express Manager. I'll grab that too.
> One final question. Apparently IIS isn't supported in XP Home. Could I
> still install it? (By the time I get to Reporting Services and need IIS
> I'll probably have another box up and running with Windows 2000, but I
> still would like to know if it's possible.)
> Also I read there are some potential conflicts with Windows Firewall
> blocking the port that SQL server listens on, but if I havve the server
> and client on the same physical box that shoudn't be a problem, should
> it?
> Thanks again, and happy holidays!
> Tim
> Hari Prasad wrote:
> > Take a look into the below URL:-
> >
> > http://msdn2.microsoft.com/en-us/library/ms143516.aspx
> >
> > Thanks
> > Hari
> >
> > <tmags23@.gmail.com> wrote in message
> > news:1166949097.123669.302670@.n51g2000cwc.googlegroups.com...
> > >I am an experienced database developer who has worked primarily with
> > > Unidata (a multi-value database). I wish to learn SQL Server, but will
> > > need to do this at home on my own. The only machine I have available is
> > > my laptop running Win XP sp2. I know I can download the SQL Server
> > > 2005 trial version or Express Edition, but I need to know if it's
> > > possible to install either of these as a standalone on my laptop. (i.e.
> > > my laptop would be both the server and client.)
> > >
> > > If it is possible to run as a standalone? Do I need to install .net and
> > > IIS? Has anyone successfully done this that can give me some pointers
> > > or refer me to some good documentation on how to do this?
> > >
> > > Thanks in advance!!
> > >
> > > Tim
> > >
>
Best way to learn SQL Mobile?
I am an experienced web developer using PHP and MySql have experience with VB.
What is the best way for me to learn programming pocket pc's? Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server.
Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it.
Thanks in advance.
Mark
Hi Mark,
The SQL Mobile is ideal for offline scenarios. You can find SQL Mobile related resource on MDSN. I am providing the links below
SQL Mobile page on MSDN - http://msdn.microsoft.com/mobility/sqlmobile/default.aspx
SQL Mobile page from SQL Server home: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx
SQL Mobile Books Online - http://msdn2.microsoft.com/en-us/library/ms173053.aspx
For advanced topics like replication with Microsoft SQL Server backend databases you can visit the following links
Connectivity with Microsoft SQL Server - http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx
HOL - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp
Manish
|||I'm working on somthing simular too. I want to connect to a mysql server on the web.What do you use to connect to the mysql server?
The only thing I found for CF is MySQLDirect...
could you please let me know.
Dennis|||
I think I use the same one, it is made by Core Lab. The download link is below.
http://crlab.com/mysqlnet/download.html
Thanks for the links but I still cannot find a tutorial that demonstrates some simple insert, delete, update and select queries.
Mark
|||Hi Mark,
Below is a specific link to IBuySpy Sample app available on MSDN
http://msdn2.microsoft.com/en-us/library/ms174006.aspx
IBuySpy Delivery 2005 Sample Application (SQL Server Mobile) - "When you install IBuySpy Delivery, you install modified versions of the IBuySpy database and Web application, and the code specific to the IBuySpy Delivery 2005 smart device application."
Hope this helps
Regards
Manish
|||Thanks for all this help Manish, but I think your going to hate me now. I am starting to think that I am either stupid, a complete novice or more likley both.
The sample app you gave me is overly complicated and requires MS Server 2005 to be installed on my computer. I have no intension of doing this as I don't need it. I just need a sample of an extreamely simple application that has its own database and doesn't sync with anything, it is stand alone.
I simply need to know how to select data from the database and store it in an array(?) or something similar, and to send sql command to the database. I ask to store the results of a quey in an array because every example app I have found shows the data as a datagrid, which is ugly and not suitable for my current project.
ie. With PHP I would explain the above like so.
1. Connect to database using a connect string.
2. get results of a query using something like : $queryResults = getQueryResults("SELECT * FROM table")
3. Use a loop to read the $queryResults array. Read the date using : $queryResults[0]['name'] <-- this would give you the stored value in the first row and the in the field 'name'.
Can development for the pocket pc be this easy? I have developed app's for the Palm OS and naver had as much trouble as this. Why is it so overly complicated?
Thanks for your patience and help.
Mark
Best way to learn SQL Mobile?
I am an experienced web developer using PHP and MySql have experience with VB.
What is the best way for me to learn programming pocket pc's? Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server.
Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it.
Thanks in advance.
Mark
Hi Mark,
The SQL Mobile is ideal for offline scenarios. You can find SQL Mobile related resource on MDSN. I am providing the links below
SQL Mobile page on MSDN - http://msdn.microsoft.com/mobility/sqlmobile/default.aspx
SQL Mobile page from SQL Server home: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx
SQL Mobile Books Online - http://msdn2.microsoft.com/en-us/library/ms173053.aspx
For advanced topics like replication with Microsoft SQL Server backend databases you can visit the following links
Connectivity with Microsoft SQL Server - http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx
HOL - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp
Manish
|||I'm working on somthing simular too. I want to connect to a mysql server on the web.What do you use to connect to the mysql server?
The only thing I found for CF is MySQLDirect...
could you please let me know.
Dennis|||
I think I use the same one, it is made by Core Lab. The download link is below.
http://crlab.com/mysqlnet/download.html
Thanks for the links but I still cannot find a tutorial that demonstrates some simple insert, delete, update and select queries.
Mark
|||Hi Mark,
Below is a specific link to IBuySpy Sample app available on MSDN
http://msdn2.microsoft.com/en-us/library/ms174006.aspx
IBuySpy Delivery 2005 Sample Application (SQL Server Mobile) - "When you install IBuySpy Delivery, you install modified versions of the IBuySpy database and Web application, and the code specific to the IBuySpy Delivery 2005 smart device application."
Hope this helps
Regards
Manish
|||Thanks for all this help Manish, but I think your going to hate me now. I am starting to think that I am either stupid, a complete novice or more likley both.
The sample app you gave me is overly complicated and requires MS Server 2005 to be installed on my computer. I have no intension of doing this as I don't need it. I just need a sample of an extreamely simple application that has its own database and doesn't sync with anything, it is stand alone.
I simply need to know how to select data from the database and store it in an array(?) or something similar, and to send sql command to the database. I ask to store the results of a quey in an array because every example app I have found shows the data as a datagrid, which is ugly and not suitable for my current project.
ie. With PHP I would explain the above like so.
1. Connect to database using a connect string.
2. get results of a query using something like : $queryResults = getQueryResults("SELECT * FROM table")
3. Use a loop to read the $queryResults array. Read the date using : $queryResults[0]['name'] <-- this would give you the stored value in the first row and the in the field 'name'.
Can development for the pocket pc be this easy? I have developed app's for the Palm OS and naver had as much trouble as this. Why is it so overly complicated?
Thanks for your patience and help.
Mark
Subscribe to:
Posts (Atom)