VB.NET (2005); Sqlce ?

[Titeuf]

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.Sq lServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

[Ken Tucker [MVP]]

Re: VB.NET (2005); Sqlce ?

Hi,

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

Ken
---------------------
"Titeuf" <z.titeuf@chauv e.com> wrote in message
news:JVQGf.1147 $1U6.94170@webe r.videotron.net ...[color=blue]
>
> 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.Sq lServerCe" but not found.
> Where is? Sqlce is not installed by default?
>
> Thanks
>
>[/color]

[Cor Ligthert [MVP]]

Re: VB.NET (2005); Sqlce ?

Titeuf,

What version of VB.Net

Cor

[Cor Ligthert [MVP]]

Re: VB.NET (2005); Sqlce ?

Titeuf,

What version of VB.Net(2005)

Cor

[Titeuf]

Re: VB.NET (2005); Sqlce ?


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

"Cor Ligthert [MVP]" <notmyfirstname @planet.nl> wrote in message
news:OEppBggLGH A.1028@TK2MSFTN GP11.phx.gbl...[color=blue]
> Titeuf,
>
> What version of VB.Net(2005)
>
> Cor
>
>[/color]

[Titeuf]

Re: VB.NET (2005); Sqlce ?


"Titeuf" <z.titeuf@chauv e.com> wrote in message
news:JVQGf.1147 $1U6.94170@webe r.videotron.net ...[color=blue]
>
> 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.Sq lServerCe" but not found.
> Where is? Sqlce is not installed by default?
>
> Thanks[/color]


Ok. My probleme is solved.
In fact.
First not use Microsoft Desktop Search for search "System.Data.Sq lServerCe"
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.Sql ce.common.dbCon nection
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.360 0.0,
Culture=neutral , PublicKeyToken= 3be235df1c8d2ad 3,
processorArchit ecture=MSIL" />
<Reference Include="System .Data.SqlServer Ce, Version=3.0.360 0.0,
Culture=neutral , PublicKeyToken= 3be235df1c8d2ad 3,
processorArchit ecture=MSIL" />
<Reference Include="System .Drawing" />
<Reference Include="System .Windows.Forms" />
</ItemGroup>

*.vbproj (BAD)
---------------------
<ItemGroup>
<Reference Include="Custom Marshalers" />
<Reference Include="System " />
<Reference Include="System .Data.Common, Version=1.0.500 0.0,
Culture=neutral , PublicKeyToken= 969db8053d3322a c">
<SpecificVersio n>False</SpecificVersion >
<HintPath>..\.. \..\..\Program Files\Microsoft Visual Studio
8\SmartDevices\ SDK\SQL Server\Mobile\v 2.0\System.Data .Common.dll</HintPath>
</Reference>
<Reference Include="System .Data.SqlClient , Version=3.0.360 0.0,
Culture=neutral , PublicKeyToken= 3be235df1c8d2ad 3,
processorArchit ecture=MSIL">
<SpecificVersio n>False</SpecificVersion >
<HintPath>..\.. \..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\ Client\v2.0\Sys tem.Data.SqlCli ent.dll</HintPath>
</Reference>
<Reference Include="System .Data.SqlServer Ce, Version=3.0.360 0.0,
Culture=neutral , PublicKeyToken= 3be235df1c8d2ad 3,
processorArchit ecture=MSIL">
<SpecificVersio n>False</SpecificVersion >
<HintPath>..\.. \..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\ Mobile\v3.0\Sys tem.Data.SqlSer verCe.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