INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Your site is a great idea. I should have joined your site years ago. Better late than never..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Web Development > Microsoft: ASP.NET Forum

Programmatic connection to SQL compact 4.0

Read More Threads Like This One

5ilversaracen (Programmer)

14 Jul 12 13:33

hi guys
have installed Visual Web Developer 2010 Express along with SQL Compact 4.0 and I'm trying to programmatically connect to a database. Whatever I use as a connection string though seems to throw up errors primarily that the database doesnt exist.

The connection string I get from the Database Explorer is:

Data Source="C:\Documents and Settings\Amos\My Documents\Visual Studio 2010\Projects\MyFaceWebsite\MyFaceWebsite\MyFaceDB.sdf"

If i add a details view the connection in webconfig is:

<add name="ConnectionString" connectionString="Data Source="C:\Documents and Settings\Amos\My Documents\Visual Studio 2010\Projects\MyFaceWebsite\MyFaceWebsite\MyFaceDB.sdf""
providerName="System.Data.SqlServerCe.4.0" />

Does anyone know how to set this connection up programmatically?

Many thanks in advance

jbenson001 (Programmer)

15 Jul 12 11:02

You are not forming the connection string properly. Check this website, it shows how to set up the connection string for multiple servers:
www.connectionstrings.com

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: ASP.NET