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

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
.

Relevant Pages

  • Re: ADOCE interoperability with SQL Server versions and .mdb
    ... You have a table A in SQL Server DB and want to get a part of it on to ... > Pc with the recordset retrieved from the backend server, ... > records in a table hosted on the Pocket PC using SQLCE and then ...
    (microsoft.public.sqlserver.ce)
  • Re: Access DB on a Pocket PC device
    ... I also found where SQL Mobile is part of VB.2005. ... SQL client on my Pocket PC. ... SSMS gets installed with SQL Server Developer. ...
    (microsoft.public.pocketpc.developer)
  • Sql CE from XP without Sql Server?
    ... Is there any way to communicate from a desktop to the Pocket ... reading and updating the pocket SQL database WITHOUT having Sql Server ...
    (microsoft.public.sqlserver.ce)
  • SQL CE Replication Problem
    ... I have the Microsoft SQL Desktop Engine ... Pocket PC program to syncronize with the desktop pc: ... first of which is "Initializing SQL Server Reconciler has failed". ...
    (microsoft.public.sqlserver.ce)
  • Replication problem
    ... I have the Microsoft SQL Desktop Engine installed on the destop ... and I have the tools from SQL Server 2000 Enterprise edition also installed. ... this code from the Pocket PC program to syncronize with the desktop pc: ...
    (microsoft.public.sqlserver.ce)
Loading