By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,699 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,699 IT Pros & Developers. It's quick & easy.

VB.NET (2005); Sqlce ?

P: n/a

ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks
Feb 10 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi,

VB 2005 should come with sql server 2005 mobile the version for sql
server 2005.

Ken
---------------------
"Titeuf" <z.******@chauve.com> wrote in message
news:JV******************@weber.videotron.net...

ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

Feb 10 '06 #2

P: n/a
Titeuf,

What version of VB.Net

Cor
Feb 10 '06 #3

P: n/a
Titeuf,

What version of VB.Net(2005)

Cor
Feb 10 '06 #4

P: n/a

I use last MSDN Visual Studio 2005 (I have no exact version here)
But, I suppose I would reinstal (?)

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:OE**************@TK2MSFTNGP11.phx.gbl...
Titeuf,

What version of VB.Net(2005)

Cor


Feb 10 '06 #5

P: n/a

"Titeuf" <z.******@chauve.com> wrote in message
news:JV******************@weber.videotron.net...

ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

Ok. My probleme is solved.
In fact.
First not use Microsoft Desktop Search for search "System.Data.SqlServerCe"
Just use the old search with Explorer ;-)
After, I found - just Projet/Add Reference with Browse - etc. for others
*.dll

Last, my big problem:
I have problem with System.Data.Sqlce.common.dbConnection
Il juste create a small program and compare *.vbproj file:
*.vbproj (GOOD project)
----------------------------------
<ItemGroup>
<Reference Include="System" />
<Reference Include="System.Data" />
<Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
<Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
<Reference Include="System.Drawing" />
<Reference Include="System.Windows.Forms" />
</ItemGroup>

*.vbproj (BAD)
---------------------
<ItemGroup>
<Reference Include="CustomMarshalers" />
<Reference Include="System" />
<Reference Include="System.Data.Common, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft Visual Studio
8\SmartDevices\SDK\SQL Server\Mobile\v2.0\System.Data.Common.dll</HintPath>
</Reference>
<Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Client\v2.0\System.Data.SqlClient.d ll</HintPath>
</Reference>
<Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Mobile\v3.0\System.Data.SqlServerCe .dll</HintPath>
</Reference>
<Reference Include="System.Drawing" />
<Reference Include="System.Windows.Forms" />
</ItemGroup>

The difference is probably because I start with a project created with VS
2003.
I gess replace the BAD ItemGroup with GOOD ItemGroup
Bingo!
I create database, table etc. with Sqlce

Feb 10 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.