1. setup Sql Server 2005 Yukon Beta & VS .Net 2005 Beta
2. VS 2005 Beta 1 and SQL Server 2005
3. VS 2005 - SQL Server 2005 Integration
4. 2005 Setup Project: Installing SQL Server Express prerequisite with command line parameters
Hi, I've got a setup project which installs SQL Server Express as a prerequisite to my program. The problem is that by default it's installed using the SQLEXPRESS instance name and Windows Authentication login mode. I'd like to have my own instance name and SQL Authentication, which is easily achieved with command line parameters... is there a way to specify that sort of thing? Thanks
5. Connecting Database Engine (SQl server 2005 file .*mdf) for Win CE - CSharp/C#
6. Microsoft SQL Server 2005 Compact Edition in windows ce 6.0
hello I have read much about Microsoft SQL Server 2005 Compact Edition, many delpoy always copy these files to device: sqlce30.dev.CHS.ppc.wce5.armv4i.CABsqlce30.ppc.wce5.armv4i.CAB sqlce30.repl.ppc.wce5.armv4i.CAB but I think "Microsoft SQL Server 2005 Compact Edition" means sqlce3s, and I can not find cab files in windowc ce 6.0? then, how can I deploy applications use Microsoft SQL Server 2005 Compact Edition in windows ce 6.0.
7. VS 2005 & .CE NET 4.20 & SQL Mobile 2005??
8. Error with DISTINCT constraint in SQL CE (not SQL CE 2005)
I am having some problems getting this query to work. When I remove the
DISTINCT constraint the query works great but it does not produce unique
results. When I add the DISTINCT constraint back into the query I get an SQL
CE error telling me that a column name is invalid.
Here is the query (with the DISTINCT constraint):
sqltext = "SELECT DISTINCT PestID,Pest FROM tblPests " & _
"WHERE (CustomerID = " & customerid & " " & _
"OR CustomerID = 1) " & _
"AND Active='Y' " & _
"AND (CustomerChemicalID = " &
spraying.chemicalid1 & " " & _
"OR CustomerChemicalID = " &
spraying.chemicalid2 & " " & _
"OR CustomerChemicalID = " &
spraying.chemicalid3 & ") " & _
"ORDER BY CustomerID DESC, Pest ASC;"
Does anyone have any suggestions on this or know what in the world that I am
doing wrong? I am quite sure it is syntax related.
Thanks in advance,
nb
------------------------------------------
Noble D. Bell
AgForest Partners, Inc.