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

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" <boogieloogie@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

.

Relevant Pages

  • Re: "There isnt enough memory to perform this operation"
    ... Our method of dealing with the problem so far is saving a lot and Compact & ... leaving Design mode. ... Run Compact & Repair on one of the copies. ... large app -- about 72 MB of program with tables linked to another Access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Help! When running a VB exe, MS Office 2003 pops up
    ... Installing Office and the other App with different users. ... and it needs to rebuild its Repair and Re-install scripts. ... In all but extreme cases the "fix" is to simply provide the Office CD. ...
    (microsoft.public.vb.general.discussion)
  • Re: Help! When running a VB exe, MS Office 2003 pops up
    ... Installing Office and the other App with different users. ... and it needs to rebuild its Repair and Re-install scripts. ... In all but extreme cases the "fix" is to simply provide the Office CD. ...
    (microsoft.public.vb.general.discussion)
  • Re: private Deploy of SQL CE 3.1
    ... Server Compact and hence I can not ... data provider" catalog items in my platform builder, ... dll sqlceme30.dll was sitting right there in the app directory. ... device uses 3.1 dlls. ...
    (microsoft.public.sqlserver.ce)
  • Re: In need of 5 TS connections
    ... But if there are no unused workstations, the cost of installing ... If the ts is set up to host the user desktops, and the app is installed on ... >>> only thing I had to do was add the TS licensing ...
    (microsoft.public.windows.server.sbs)
Loading