Compact Edition not in Data Source List

After I installed the SQL Server Compact Edition, I start a new VS 2005 Basic project. When I try to create a new connection I do not see the Compact Edition in the list of data sources.

I have installed previously SQL Server CE, Everywhere, Mobile, 2005 Mobile but I uninstalled them all.

Can anyone give me an idea why I can't see the Compact Edition as a data source?

Thanks.

Hello

From what you'r saying maybe you need to re-install the SQL Server CE.
I have the same problem but it's because I'm using VB.NET Express Edition.

see ya

Compact Edition DVD Standalone

Is it possible to run SQL Server Compact Edition as a standalone application from a DVD?

i.e. it would not leave anything installed on the users computer after the DVD was ejected.

Hi:

For what it's worth, I am attempting the same thing: developing a product catalog that will enable users to browse products and configure order for printing. As my product is using Framework 2, I will simply have an autorun install the program since I have to check for the existence of the framework anyway.

Please post back your findings.

|||If both .Net CF2 and SQL Server 2005 are installed on the target system, you should be able to deploy the DLLs for SQL CE on the DVD.|||I do not believe there is a dependancy on SQL Server/.NET CF2 for a runtime SQL Server CE application - believe that there is only a dependency on VB6 runtime/.Net 1/1.1 runtime of .Net2.0 runtime (according the language the app has been written in. Plus of course the SQL CE Dlls on the DVD|||Make connection string like this:

"Data Source=".\MyDatabase.sdf";Password="MyPassword";mode="Read Only";SSCE:Temp File Directory = "C:\";"

This will use temporary database on c: disk if there's need to write temp data for queries.

On DVD/CD include these files in root:
Microsoft.SqlServerCe.Client.dll
sqlceca30.dll
sqlcecompact30.dll
sqlceer30EN.dll
sqlceme30.dll
sqlceoledb30.dll
sqlceqp30.dll
sqlcese30.dll
System.Data.SqlServerCe.dll

Now, this works for me, but I have requirement, not to write to C:, but to users temp folder.
Does somebody know how to change connection string to write into temp folder?

Communicating with a SQL Server installed on a remote machine using a web service

I have SQL Server 2005 express installed on my machine, and I was wondering if there is any way to have an asp.net 2.0 web service hosted by a different company be able to send sql commands to the sql server on my machine.

Yes.

It would require that you make your computer somewhat vulnerable to the internet.

You will have to open a port in the firewall.

You will have to deal with Web Services security issues or all kinds of folks 'could' be sending commands to your SQL Server. And if your security isn't 'irontight', one of those commands could even be "FORMAT C:".

So my point is yes, it can be done, I want you to understand that there are a lot of steps necessary to 'do it right'.

|||Thank you for your help with this. I think for now I will hold off on this until I can find time to research the security issues much more thouroughly.

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...I
am not a programmer so I apologize in advance!!!
I can′t dtermine what you mean with command line, if you want the Dos (shell)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:

> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thing,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question...I
> am not a programmer so I apologize in advance!!!

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...I
am not a programmer so I apologize in advance!!!I can´t dtermine what you mean with command line, if you want the Dos (shell)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:
> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thing,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question...I
> am not a programmer so I apologize in advance!!!

Command Prompt

I apologize for asking a stupid question....I have Windows 2003 Server
installed, I am using SQL Server 2000 with all the sp's installed. I have
created db etc by utilizing the Enterprise Manager....I have been using a
SAMS book to learn some things however the very most basic rudimentary thing
,
I have no clue.....
there are many examples that tell you to issue commands...where do I find
the command lines in SQL? Thanks for entertaining my humourous question...
I
am not a programmer so I apologize in advance!!!I can′t dtermine what you mean with command line, if you want the Dos (shel
l)
command line you can use XP_cmdshell and extended procedure to fire commadn
to the database, if you want to fire up some SQL commandsyou should head for
the Query Analyzer whcih is part as a client component of SQL Server or the
command line utility OSQL.exe which can be executed through the commadn line
in dos mode.
HTH, Jens Suessmeyer.
"SQL Brad" wrote:

> I apologize for asking a stupid question....I have Windows 2003 Server
> installed, I am using SQL Server 2000 with all the sp's installed. I have
> created db etc by utilizing the Enterprise Manager....I have been using a
> SAMS book to learn some things however the very most basic rudimentary thi
ng,
> I have no clue.....
> there are many examples that tell you to issue commands...where do I find
> the command lines in SQL? Thanks for entertaining my humourous question..
.I
> am not a programmer so I apologize in advance!!!