Launch condition to detect SQL CE?

I have written a .NET application that uses SQL Server Compact Edition. It's deployed by a MSI file (setup project in VS - not ClickOnce).

How do I add a SQL CE launch condition to my setup project?

Never mind. I'm now using the bootstrapper and added the SQL CE requirement there.sql

Launch condition to detect SQL CE?

I have written a .NET application that uses SQL Server Compact Edition. It's deployed by a MSI file (setup project in VS - not ClickOnce).

How do I add a SQL CE launch condition to my setup project?

Never mind. I'm now using the bootstrapper and added the SQL CE requirement there.

Late Get error

While doing a demonstration of an alpha application written in VB.NET, I got
an error message complaining of a Late Get. I am presuming that this is a
SQL Server related error, rather than a VB.NET error, but not sure. Any
know what might generally be causing this error message?
I have never seen this error during extensive testing of that form prior to
the demonstration, and tried to recreate it after the demonstration, but to
no avail.
Any thoughts would be appreciated.
Dean SlindeeCan you post the exact error message, plus some demo code. Someone might
have some insight to the problem.
-oj
"Dean Slindee" <slindee@.charter.net> wrote in message
news:hU1Wd.29517$Ep.6413@.fe06.lga...
> While doing a demonstration of an alpha application written in VB.NET, I
> got
> an error message complaining of a Late Get. I am presuming that this is a
> SQL Server related error, rather than a VB.NET error, but not sure. Any
> know what might generally be causing this error message?
> I have never seen this error during extensive testing of that form prior
> to
> the demonstration, and tried to recreate it after the demonstration, but
> to
> no avail.
> Any thoughts would be appreciated.
> Dean Slindee
>

Large Text FIeld: Easy Way to Copy and Paste Into?

I have a column that I want to store the entire contents of an XML
file. For testing purposes before our .Net program is written, I would
like to populate that column in a few rows with some actual
text-representation of XML files. I thought I would just open the XML
file in a text editor (ultraedit) and then paste it in somehow.
Normaly I can go into Enterprise Manager and paste information into
columns from other apps - as long as the column can accept the data, no
problem.
However, there seems to be a limit on how much text I can paste into a
column via Enterprise Manager. It's not based on linefeeds
necessarily, because it handles multiple lines OK, just as long as you
don't try to paste too much.
Is there any other tool that I could use to slam some data quickly into
some columns. Insert statements using Query Analyzer are a pain (not
to mention needing to worry about apostrophes, etc.) - I was looking
for something rather visual and quick.
I tried this QA Lite tool which showed some promise
(http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
be similar there as well...
Any hints?
Thanks,
spedlists@.erstads.com
Try bulk insert.
It's just a matter of setting the end tags for the entries.
There are a few bugs associated with bulk inserting into text column though
so post again if you have problems - it might not be your code.
"Sped" wrote:

> I have a column that I want to store the entire contents of an XML
> file. For testing purposes before our .Net program is written, I would
> like to populate that column in a few rows with some actual
> text-representation of XML files. I thought I would just open the XML
> file in a text editor (ultraedit) and then paste it in somehow.
> Normaly I can go into Enterprise Manager and paste information into
> columns from other apps - as long as the column can accept the data, no
> problem.
> However, there seems to be a limit on how much text I can paste into a
> column via Enterprise Manager. It's not based on linefeeds
> necessarily, because it handles multiple lines OK, just as long as you
> don't try to paste too much.
> Is there any other tool that I could use to slam some data quickly into
> some columns. Insert statements using Query Analyzer are a pain (not
> to mention needing to worry about apostrophes, etc.) - I was looking
> for something rather visual and quick.
> I tried this QA Lite tool which showed some promise
> (http://www.rac4sql.net/qalite_main.asp) - but the limitation seems to
> be similar there as well...
> Any hints?
> Thanks,
> spedlists@.erstads.com
>