have an .sdf database (MS SQL 2005 Compact)  that was created on a
pocket pc. It now resides on the desktop. I wanted to open it and edit
it on the desktop. I am developing with Vb.2005.

I use the same connection string syntax that I use on the Pocket PC
but I get the error:

'The value's length for key 'data source' exceeds it's limit of
'128'.' from the code:

DESKTOP CODE: - Does not work
 Dim saveconn As New SqlConnection("Data Source =" &
Application.StartupPath & "\Projects\" &
lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
        saveconn.Open()


PocketPC CODE: - Does work
 Dim saveconn As New SqlCEConnection("Data Source = My Documents
\Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
& lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
        saveconn.Open()

So I do not understand my error. How do I do this? I have MS SQL
Server 2005 and MS SQL Server Express (which is what I want to use)

I use the following imports:

Imports System.Data
Imports System.Data.Common.DbConnection
Imports System.Data.SqlClient
Imports System.Data.SqlDbType
Imports System.Data.SqlTypes

I am new to this so please be patient with this ole dog!

:L
Please help

Thanks

PBLack

Loogie,

If you want to open the SQL Compact sdf file on the desktop, you need to use 
the System.Data.SqlServerCe namespace for the desktop instead of SqlClient, 
which is for SQL Server.

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:f92c3722-5ce0-4a17-95ef-4883bd2b26a7@i7g2000prf.googlegroups.com...
> have an .sdf database (MS SQL 2005 Compact)  that was created on a
> pocket pc. It now resides on the desktop. I wanted to open it and edit
> it on the desktop. I am developing with Vb.2005.
>
> I use the same connection string syntax that I use on the Pocket PC
> but I get the error:
>
> 'The value's length for key 'data source' exceeds it's limit of
> '128'.' from the code:
>
> DESKTOP CODE: - Does not work
> Dim saveconn As New SqlConnection("Data Source =" &
> Application.StartupPath & "\Projects\" &
> lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
> lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
>        saveconn.Open()
>
>
> PocketPC CODE: - Does work
> Dim saveconn As New SqlCEConnection("Data Source = My Documents
> \Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
> & lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
>        saveconn.Open()
>
> So I do not understand my error. How do I do this? I have MS SQL
> Server 2005 and MS SQL Server Express (which is what I want to use)
>
> I use the following imports:
>
> Imports System.Data
> Imports System.Data.Common.DbConnection
> Imports System.Data.SqlClient
> Imports System.Data.SqlDbType
> Imports System.Data.SqlTypes
>
> I am new to this so please be patient with this ole dog!
>
> :L
> Please help
>
> Thanks
>
> PBLack

On Jan 21, 8:22 am, "Ginny Caughey [MVP]"
 wrote:
> Loogie,
>
> If you want to open the SQL Compact sdf file on the desktop, you need to use
> the System.Data.SqlServerCe namespace for the desktop instead of SqlClient,
> which is for SQL Server.
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>
> "Loogie"  wrote in message
>
> news:f92c3722-5ce0-4a17-95ef-4883bd2b26a7@i7g2000prf.googlegroups.com...
>
> > have an .sdf database (MS SQL 2005 Compact)  that was created on a
> > pocket pc. It now resides on the desktop. I wanted to open it and edit
> > it on the desktop. I am developing with Vb.2005.
>
> > I use the same connection string syntax that I use on the Pocket PC
> > but I get the error:
>
> > 'The value's length for key 'data source' exceeds it's limit of
> > '128'.' from the code:
>
> > DESKTOP CODE: - Does not work
> > Dim saveconn As New SqlConnection("Data Source =" &
> > Application.StartupPath & "\Projects\" &
> > lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
> > lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> >        saveconn.Open()
>
> > PocketPC CODE: - Does work
> > Dim saveconn As New SqlCEConnection("Data Source = My Documents
> > \Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
> > & lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> >        saveconn.Open()
>
> > So I do not understand my error. How do I do this? I have MS SQL
> > Server 2005 and MS SQL Server Express (which is what I want to use)
>
> > I use the following imports:
>
> > Imports System.Data
> > Imports System.Data.Common.DbConnection
> > Imports System.Data.SqlClient
> > Imports System.Data.SqlDbType
> > Imports System.Data.SqlTypes
>
> > I am new to this so please be patient with this ole dog!
>
> > :L
> > Please help
>
> > Thanks
>
> > PBLack

I tried that but It says there are no members when I add the SQL Ce
Client. Can you explain how I do that

Thanks

:L

On Jan 21, 8:22 am, "Ginny Caughey [MVP]"
 wrote:
> Loogie,
>
> If you want to open the SQL Compact sdf file on the desktop, you need to use
> the System.Data.SqlServerCe namespace for the desktop instead of SqlClient,
> which is for SQL Server.
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>
> "Loogie"  wrote in message
>
> news:f92c3722-5ce0-4a17-95ef-4883bd2b26a7@i7g2000prf.googlegroups.com...
>
> > have an .sdf database (MS SQL 2005 Compact)  that was created on a
> > pocket pc. It now resides on the desktop. I wanted to open it and edit
> > it on the desktop. I am developing with Vb.2005.
>
> > I use the same connection string syntax that I use on the Pocket PC
> > but I get the error:
>
> > 'The value's length for key 'data source' exceeds it's limit of
> > '128'.' from the code:
>
> > DESKTOP CODE: - Does not work
> > Dim saveconn As New SqlConnection("Data Source =" &
> > Application.StartupPath & "\Projects\" &
> > lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
> > lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> >        saveconn.Open()
>
> > PocketPC CODE: - Does work
> > Dim saveconn As New SqlCEConnection("Data Source = My Documents
> > \Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
> > & lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> >        saveconn.Open()
>
> > So I do not understand my error. How do I do this? I have MS SQL
> > Server 2005 and MS SQL Server Express (which is what I want to use)
>
> > I use the following imports:
>
> > Imports System.Data
> > Imports System.Data.Common.DbConnection
> > Imports System.Data.SqlClient
> > Imports System.Data.SqlDbType
> > Imports System.Data.SqlTypes
>
> > I am new to this so please be patient with this ole dog!
>
> > :L
> > Please help
>
> > Thanks
>
> > PBLack

I should further explain that when I click the 'Add References'
button, System.Data.SqlServerCe is not there so I can not get it to
work. I tried to find a download of System.Data.SqlServerCe 9.0.242.0
as I saw in another post that this was the current one. But I am not
even sure that is the problem because I think I have my install
current. I am on XP SP2.

This has been bugging me for a day now and I need to get past it.

Any help appreciated

Thanks

:L

On Jan 21, 8:49 am, Loogie  wrote:
> On Jan 21, 8:22 am, "Ginny Caughey [MVP]"
>
>
>
>  wrote:
> > Loogie,
>
> > If you want to open the SQL Compact sdf file on the desktop, you need to use
> > the System.Data.SqlServerCe namespace for the desktop instead of SqlClient,
> > which is for SQL Server.
>
> > --
> > Ginny Caughey
> > Device Application Development MVPwww.wasteworks.com
> > Software for Solid Waste Management
>
> > "Loogie"  wrote in message
>
> >news:f92c3722-5ce0-4a17-95ef-4883bd2b26a7@i7g2000prf.googlegroups.com...
>
> > > have an .sdf database (MS SQL 2005 Compact)  that was created on a
> > > pocket pc. It now resides on the desktop. I wanted to open it and edit
> > > it on the desktop. I am developing with Vb.2005.
>
> > > I use the same connection string syntax that I use on the Pocket PC
> > > but I get the error:
>
> > > 'The value's length for key 'data source' exceeds it's limit of
> > > '128'.' from the code:
>
> > > DESKTOP CODE: - Does not work
> > > Dim saveconn As New SqlConnection("Data Source =" &
> > > Application.StartupPath & "\Projects\" &
> > > lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
> > > lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> > >        saveconn.Open()
>
> > > PocketPC CODE: - Does work
> > > Dim saveconn As New SqlCEConnection("Data Source = My Documents
> > > \Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
> > > & lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
> > >        saveconn.Open()
>
> > > So I do not understand my error. How do I do this? I have MS SQL
> > > Server 2005 and MS SQL Server Express (which is what I want to use)
>
> > > I use the following imports:
>
> > > Imports System.Data
> > > Imports System.Data.Common.DbConnection
> > > Imports System.Data.SqlClient
> > > Imports System.Data.SqlDbType
> > > Imports System.Data.SqlTypes
>
> > > I am new to this so please be patient with this ole dog!
>
> > > :L
> > > Please help
>
> > > Thanks
>
> > > PBLack
>
> I should further explain that when I click the 'Add References'
> button, System.Data.SqlServerCe is not there so I can not get it to
> work. I tried to find a download of System.Data.SqlServerCe 9.0.242.0
> as I saw in another post that this was the current one. But I am not
> even sure that is the problem because I think I have my install
> current. I am on XP SP2.
>
> This has been bugging me for a day now and I need to get past it.
>
> Any help appreciated
>
> Thanks
>
> :L

I found it on my computer but the version is 3.0.5300.0 So now I have
to find the right one. I looked in Microsoft but could not find it. Do
you have a link?

Thanks

:L

It sounds like you don't have the desktop components for SQLce installed for 
some reason. I'd try installing SQL Compact 3.1:
http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en

Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), that you 
won't be able to access it on the desktop other than by using a 3rd party 
product. Which version of the Compact Framework does your app use?

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:d3508ea1-bba9-4cf2-8da1-bcc5249d7d87@x69g2000hsx.googlegroups.com...
> On Jan 21, 8:22 am, "Ginny Caughey [MVP]"
>  wrote:
>> Loogie,
>>
>> If you want to open the SQL Compact sdf file on the desktop, you need to 
>> use
>> the System.Data.SqlServerCe namespace for the desktop instead of 
>> SqlClient,
>> which is for SQL Server.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVPwww.wasteworks.com
>> Software for Solid Waste Management
>>
>> "Loogie"  wrote in message
>>
>> news:f92c3722-5ce0-4a17-95ef-4883bd2b26a7@i7g2000prf.googlegroups.com...
>>
>> > have an .sdf database (MS SQL 2005 Compact)  that was created on a
>> > pocket pc. It now resides on the desktop. I wanted to open it and edit
>> > it on the desktop. I am developing with Vb.2005.
>>
>> > I use the same connection string syntax that I use on the Pocket PC
>> > but I get the error:
>>
>> > 'The value's length for key 'data source' exceeds it's limit of
>> > '128'.' from the code:
>>
>> > DESKTOP CODE: - Does not work
>> > Dim saveconn As New SqlConnection("Data Source =" &
>> > Application.StartupPath & "\Projects\" &
>> > lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\" &
>> > lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
>> >        saveconn.Open()
>>
>> > PocketPC CODE: - Does work
>> > Dim saveconn As New SqlCEConnection("Data Source = My Documents
>> > \Projects\" & lvProj.Items(lvProj.SelectedIndices(0)).Text & "\Tally\"
>> > & lvProj.Items(lvProj.SelectedIndices(0)).Text & ".sdf")
>> >        saveconn.Open()
>>
>> > So I do not understand my error. How do I do this? I have MS SQL
>> > Server 2005 and MS SQL Server Express (which is what I want to use)
>>
>> > I use the following imports:
>>
>> > Imports System.Data
>> > Imports System.Data.Common.DbConnection
>> > Imports System.Data.SqlClient
>> > Imports System.Data.SqlDbType
>> > Imports System.Data.SqlTypes
>>
>> > I am new to this so please be patient with this ole dog!
>>
>> > :L
>> > Please help
>>
>> > Thanks
>>
>> > PBLack
>
> I should further explain that when I click the 'Add References'
> button, System.Data.SqlServerCe is not there so I can not get it to
> work. I tried to find a download of System.Data.SqlServerCe 9.0.242.0
> as I saw in another post that this was the current one. But I am not
> even sure that is the problem because I think I have my install
> current. I am on XP SP2.
>
> This has been bugging me for a day now and I need to get past it.
>
> Any help appreciated
>
> Thanks
>
> :L

On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
 wrote:
> It sounds like you don't have the desktop components for SQLce installed for
> some reason. I'd try installing SQL Compact 3.1:http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa...
>
> Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), that you
> won't be able to access it on the desktop other than by using a 3rd party
> product. Which version of the Compact Framework does your app use?
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>

I already have SQL Compact 3.1 installed so I assume I have a version
3 sdf. How do I tell for sure? Just to be sure that I had the SQL 3.1
compact installed, I downloaded and installed it again from the link
you gave. It asked if I wanted to remove or repair, so I clicked
repair and it did. Next I went back into my app code and there is
still no reference available.

This is driving me crazy.

:L

I have never used VB 2005 and have only use Visual Studio 2005/ 2008, etc. 
So I don't know if that is the source of your problem. Usually the reason 
you can't add a reference is that you are targeting the wrong platform. For 
example, you are building a desktop app here, right?

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:d102ed90-d691-48d9-8381-0e185304a8c0@v46g2000hsv.googlegroups.com...
> On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
>  wrote:
>> It sounds like you don't have the desktop components for SQLce installed 
>> for
>> some reason. I'd try installing SQL Compact 
>> 3.1:http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa...
>>
>> Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), that 
>> you
>> won't be able to access it on the desktop other than by using a 3rd party
>> product. Which version of the Compact Framework does your app use?
>>
>> --
>> Ginny Caughey
>> Device Application Development MVPwww.wasteworks.com
>> Software for Solid Waste Management
>>
>
> I already have SQL Compact 3.1 installed so I assume I have a version
> 3 sdf. How do I tell for sure? Just to be sure that I had the SQL 3.1
> compact installed, I downloaded and installed it again from the link
> you gave. It asked if I wanted to remove or repair, so I clicked
> repair and it did. Next I went back into my app code and there is
> still no reference available.
>
> This is driving me crazy.
>
> :L

On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
 wrote:
> It sounds like you don't have the desktop components for SQLce installed for
> some reason. I'd try installing SQL Compact 3.1:http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa...
>
> Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), that you
> won't be able to access it on the desktop other than by using a 3rd party
> product. Which version of the Compact Framework does your app use?
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management

I manually added a reference by clicking 'add existing item' and
navigating to and choosing: System.Data.SqlServerCe.dll located in
\Microsoft SQL Server Compact Edition
\v3.1\System.Data.SqlServerCe.dll

This did not help. Still can not get a reference that works.

This is driving me nuts!

:L

On Jan 21, 9:29 am, "Ginny Caughey [MVP]"
 wrote:
> I have never used VB 2005 and have only use Visual Studio 2005/ 2008, etc.
> So I don't know if that is the source of your problem. Usually the reason
> you can't add a reference is that you are targeting the wrong platform. For
> example, you are building a desktop app here, right?
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>
> "Loogie"  wrote in message
>
> news:d102ed90-d691-48d9-8381-0e185304a8c0@v46g2000hsv.googlegroups.com...
>
> > On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
> >  wrote:
> >> It sounds like you don't have the desktop components for SQLce installed
> >> for
> >> some reason. I'd try installing SQL Compact
> >> 3.1:http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa...
>
> >> Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), that
> >> you
> >> won't be able to access it on the desktop other than by using a 3rd party
> >> product. Which version of the Compact Framework does your app use?
>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVPwww.wasteworks.com
> >> Software for Solid Waste Management
>
> > I already have SQL Compact 3.1 installed so I assume I have a version
> > 3 sdf. How do I tell for sure? Just to be sure that I had the SQL 3.1
> > compact installed, I downloaded and installed it again from the link
> > you gave. It asked if I wanted to remove or repair, so I clicked
> > repair and it did. Next I went back into my app code and there is
> > still no reference available.
>
> > This is driving me crazy.
>
> > :L

Yes I am developing a desktop ap. You are correct. And let me clarify.
I have VS Studio 2005 SP1 installed and am writing my app in VB.Net. I
should have been more clear. Sorry for that.

:L

Loogie,

You should be able to just use the Add Reference dialog to add the correct 
desktop reference then. Since this isn't working for you, probably 
reinstalling SQL Compact is the next thing to try.

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:63e9a34e-4e9e-49e8-abac-dff342f89e0b@21g2000hsj.googlegroups.com...
> On Jan 21, 9:29 am, "Ginny Caughey [MVP]"
>  wrote:
>> I have never used VB 2005 and have only use Visual Studio 2005/ 2008, 
>> etc.
>> So I don't know if that is the source of your problem. Usually the reason
>> you can't add a reference is that you are targeting the wrong platform. 
>> For
>> example, you are building a desktop app here, right?
>>
>> --
>> Ginny Caughey
>> Device Application Development MVPwww.wasteworks.com
>> Software for Solid Waste Management
>>
>> "Loogie"  wrote in message
>>
>> news:d102ed90-d691-48d9-8381-0e185304a8c0@v46g2000hsv.googlegroups.com...
>>
>> > On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
>> >  wrote:
>> >> It sounds like you don't have the desktop components for SQLce 
>> >> installed
>> >> for
>> >> some reason. I'd try installing SQL Compact
>> >> 3.1:http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa...
>>
>> >> Note that if your sdf file is SQLce 2.0 and not 3 (you didn't say), 
>> >> that
>> >> you
>> >> won't be able to access it on the desktop other than by using a 3rd 
>> >> party
>> >> product. Which version of the Compact Framework does your app use?
>>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVPwww.wasteworks.com
>> >> Software for Solid Waste Management
>>
>> > I already have SQL Compact 3.1 installed so I assume I have a version
>> > 3 sdf. How do I tell for sure? Just to be sure that I had the SQL 3.1
>> > compact installed, I downloaded and installed it again from the link
>> > you gave. It asked if I wanted to remove or repair, so I clicked
>> > repair and it did. Next I went back into my app code and there is
>> > still no reference available.
>>
>> > This is driving me crazy.
>>
>> > :L
>
> Yes I am developing a desktop ap. You are correct. And let me clarify.
> I have VS Studio 2005 SP1 installed and am writing my app in VB.Net. I
> should have been more clear. Sorry for that.
>
> :L

On Jan 21, 10:29 am, "Ginny Caughey [MVP]"
 wrote:
> Loogie,
>
> You should be able to just use the Add Reference dialog to add the correct
> desktop reference then. Since this isn't working for you, probably
> reinstalling SQL Compact is the next thing to try.
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>

Hi Again

I don't know what to do. I have done as you have suggested and still
nothing. I don't know what it going on because it is there for my
Pocket PC Aps just not for my Desktop Aps. Windows update does not
suggest anything else...yet it does not work. Even when I add the file
manually through 'Add Existing Item' it is not recognized.

I am at wits end with this. I have had this problem for over 48 hours
now and am dead in the water with my project unless someone can come
up with a suggestion that would get this working for me.

:L

Did you try uninstalling and reinstalling SQL Compact? You are targetting 
Compact Framework 2.0, right?

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:71263419-3d48-4abb-86e2-8cbbf78ddefb@n22g2000prh.googlegroups.com...
> On Jan 21, 10:29 am, "Ginny Caughey [MVP]"
>  wrote:
>> Loogie,
>>
>> You should be able to just use the Add Reference dialog to add the 
>> correct
>> desktop reference then. Since this isn't working for you, probably
>> reinstalling SQL Compact is the next thing to try.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVPwww.wasteworks.com
>> Software for Solid Waste Management
>>
>
> Hi Again
>
> I don't know what to do. I have done as you have suggested and still
> nothing. I don't know what it going on because it is there for my
> Pocket PC Aps just not for my Desktop Aps. Windows update does not
> suggest anything else...yet it does not work. Even when I add the file
> manually through 'Add Existing Item' it is not recognized.
>
> I am at wits end with this. I have had this problem for over 48 hours
> now and am dead in the water with my project unless someone can come
> up with a suggestion that would get this working for me.
>
> :L
>

Oops - desktop should be targetting .NET 2.0.

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Ginny Caughey [MVP]"  wrote in message 
news:D5F002A0-8B30-4CE2-B8AD-3E38A4ACDC7C@microsoft.com...
> Did you try uninstalling and reinstalling SQL Compact? You are targetting 
> Compact Framework 2.0, right?
>
> -- 
> Ginny Caughey
> Device Application Development MVP
> www.wasteworks.com
> Software for Solid Waste Management
>
>
>
> "Loogie"  wrote in message 
> news:71263419-3d48-4abb-86e2-8cbbf78ddefb@n22g2000prh.googlegroups.com...
>> On Jan 21, 10:29 am, "Ginny Caughey [MVP]"
>>  wrote:
>>> Loogie,
>>>
>>> You should be able to just use the Add Reference dialog to add the 
>>> correct
>>> desktop reference then. Since this isn't working for you, probably
>>> reinstalling SQL Compact is the next thing to try.
>>>
>>> --
>>> Ginny Caughey
>>> Device Application Development MVPwww.wasteworks.com
>>> Software for Solid Waste Management
>>>
>>
>> Hi Again
>>
>> I don't know what to do. I have done as you have suggested and still
>> nothing. I don't know what it going on because it is there for my
>> Pocket PC Aps just not for my Desktop Aps. Windows update does not
>> suggest anything else...yet it does not work. Even when I add the file
>> manually through 'Add Existing Item' it is not recognized.
>>
>> I am at wits end with this. I have had this problem for over 48 hours
>> now and am dead in the water with my project unless someone can come
>> up with a suggestion that would get this working for me.
>>
>> :L
>>
>

On Jan 21, 1:48 pm, "Ginny Caughey [MVP]"
 wrote:
> Did you try uninstalling and reinstalling SQL Compact? You are targetting
> Compact Framework 2.0, right?
>
> --
> Ginny Caughey
> Device Application Development MVPwww.wasteworks.com
> Software for Solid Waste Management
>
> "Loogie"  wrote in message
>
> news:71263419-3d48-4abb-86e2-8cbbf78ddefb@n22g2000prh.googlegroups.com...
>
> > On Jan 21, 10:29 am, "Ginny Caughey [MVP]"
> >  wrote:
> >> Loogie,
>
> >> You should be able to just use the Add Reference dialog to add the
> >> correct
> >> desktop reference then. Since this isn't working for you, probably
> >> reinstalling SQL Compact is the next thing to try.
>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVPwww.wasteworks.com
> >> Software for Solid Waste Management
>

Ginny

I finally got it. I installed XP Service Pack 3 and there it was. Not
sure what SP 3 had to do with it but I am not going to complain. At
least now I can get back to work.

Also, thank you for taking time to help me out with this. It is people
like you that make the world a better place. Your commitment to
helping others is commendable!

:L

Glad to help. I especially like problems that have solutions. ;-)

-- 
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management



"Loogie"  wrote in message 
news:f5428e94-29db-4f60-a3be-c9a36439a865@s13g2000prd.googlegroups.com...
> On Jan 21, 1:48 pm, "Ginny Caughey [MVP]"
>  wrote:
>> Did you try uninstalling and reinstalling SQL Compact? You are targetting
>> Compact Framework 2.0, right?
>>
>> --
>> Ginny Caughey
>> Device Application Development MVPwww.wasteworks.com
>> Software for Solid Waste Management
>>
>> "Loogie"  wrote in message
>>
>> news:71263419-3d48-4abb-86e2-8cbbf78ddefb@n22g2000prh.googlegroups.com...
>>
>> > On Jan 21, 10:29 am, "Ginny Caughey [MVP]"
>> >  wrote:
>> >> Loogie,
>>
>> >> You should be able to just use the Add Reference dialog to add the
>> >> correct
>> >> desktop reference then. Since this isn't working for you, probably
>> >> reinstalling SQL Compact is the next thing to try.
>>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVPwww.wasteworks.com
>> >> Software for Solid Waste Management
>>
>
> Ginny
>
> I finally got it. I installed XP Service Pack 3 and there it was. Not
> sure what SP 3 had to do with it but I am not going to complain. At
> least now I can get back to work.
>
> Also, thank you for taking time to help me out with this. It is people
> like you that make the world a better place. Your commitment to
> helping others is commendable!
>
> :L
>

I have the same problem with version 3.1. I am not using .Net but instead 
using OLEDB with a Native application. If I have a column greater than one 
127 nvarchar I cannot do a select on it. I can insert into it ok and can do 
a select via the SQL Management tools ok. I tired installing 3.5 but have 
been unable to register the sqlceoledb35.dll as the registration fails even 
though it is installed and all looks correct. On another computer I did 
register it but get unknown error messages when trying to connect.

Anyone got any ideas short of using .Net?