Home All Groups Group Topic Archive Search About

Can VS2003 vb .net app connect to SQL Server 2005 Everywhere?

Author
6 Jul 2006 3:46 PM
dotnet user
I have Visual Studio 2003 VB .net application that currently access MS Access
database. Does anybody know that if it is possible for these applications
connect to SQL Server 2005 Everywhere thru adonet? Since VS2003 is using .net
framework 1.1, and SQL Server 2005 everywhere uses .net framework 2.0, is
this possible?
Thanks

Author
6 Jul 2006 6:34 PM
William (Bill) Vaughn
Once you install the SQL Everywhere SDK you need to add a reference to the
SQLEv DLLs and Import the SQLCE library. This is NOT ADO.NET but similar in
many regards. SQLEv is not dependent on any version of the Framework.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote
"dotnet user" <dotnet u***@discussions.microsoft.com> wrote in message
news:3E02296A-A112-4975-A0BD-1DFBDFF62B5B@microsoft.com...
>I have Visual Studio 2003 VB .net application that currently access MS
>Access
> database. Does anybody know that if it is possible for these applications
> connect to SQL Server 2005 Everywhere thru adonet? Since VS2003 is using
> .net
> framework 1.1, and SQL Server 2005 everywhere uses .net framework 2.0, is
> this possible?
> Thanks
Author
6 Jul 2006 7:52 PM
dotnet user
Thanks for the tips.
1. Can you be specific about which dlls in particular?
I can only get VS2003 to import the reference:  Microsoft SQL Server 2005
Everywhere Edition (shows up as SSCE). 

2.Is there a link somewhere on Microsoft web site that has example on this?
Author
7 Jul 2006 4:05 PM
William (Bill) Vaughn
Tell ya what... I'll work up a whitepaper today and post it on my blog. It
should be there this evening sometime.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote
"dotnet user" <dotnetu***@discussions.microsoft.com> wrote in message
news:D6A00926-1839-45FA-AC8F-0EBAA229EC2F@microsoft.com...
> Thanks for the tips.
> 1. Can you be specific about which dlls in particular?
> I can only get VS2003 to import the reference:  Microsoft SQL Server 2005
> Everywhere Edition (shows up as SSCE).
>
> 2.Is there a link somewhere on Microsoft web site that has example on
> this?
>
>
Author
7 Jul 2006 9:04 PM
William (Bill) Vaughn
Actually, I've decided to create a new chapter with this content. I'll post
the setup parts to my blog once it's a bit further along.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote
"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:eNpm98doGHA.3452@TK2MSFTNGP05.phx.gbl...
> Tell ya what... I'll work up a whitepaper today and post it on my blog. It
> should be there this evening sometime.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "dotnet user" <dotnetu***@discussions.microsoft.com> wrote in message
> news:D6A00926-1839-45FA-AC8F-0EBAA229EC2F@microsoft.com...
>> Thanks for the tips.
>> 1. Can you be specific about which dlls in particular?
>> I can only get VS2003 to import the reference:  Microsoft SQL Server 2005
>> Everywhere Edition (shows up as SSCE).
>>
>> 2.Is there a link somewhere on Microsoft web site that has example on
>> this?
>>
>>
>
>

AddThis Social Bookmark Button