Re: Help With MS SQL Error: The value's length for key 'data source' exceeds it's limit of '128'.

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" <boogieloogie@xxxxxxxxx> wrote in message news:63e9a34e-4e9e-49e8-abac-dff342f89e0b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jan 21, 9:29 am, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@xxxxxxxxxxxxxx> 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" <boogieloo...@xxxxxxxxx> wrote in message

news:d102ed90-d691-48d9-8381-0e185304a8c0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> On Jan 21, 9:04 am, "Ginny Caughey [MVP]"
> <ginny.caughey.onl...@xxxxxxxxxxxxxx> 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

.

Relevant Pages

  • Re: Help With MS SQL Error: The values length for key data source exceeds its limit of 128.
    ... I'd try installing SQL Compact 3.1: ... If you want to open the SQL Compact sdf file on the desktop, ... > Imports System.Data ...
    (microsoft.public.sqlserver.ce)
  • Best Practices: 2nd instance SQL 2K5 on Active/Passive cluster
    ... Are they're any Best Practices with reference to installing a 2nd ... instance of SQL 2K5 on an Active / Passive cluster running under Win ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to reinstall SBS Monitoring
    ... Uninstall Windows SBS 2003 R2 components". ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to reinstall SBS Monitoring
    ... but it's possible the MSDE instance for the monitoring database did not remove the registration from the registry and when you reinstall it it finds the key and it can't proceed. ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • error while installing a new named instance
    ... I have a test domain which include 2-node SQL 2005 clusters. ... As installing a named instance INS2 it gave error at ... Source File Name: datastore\cachedpropertycollection.cpp ... Error Code: 0x80070002 ...
    (microsoft.public.sqlserver.clustering)