Sql server Ce connection.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server CE » Sql server Ce connection.

Sql server Ce connection.

Rate Topic

Display Mode

Topic Options

Author

Message

Neeta Patil

Posted Monday, July 09, 2007 7:51 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 03, 2011 11:32 PM
Points: 156, Visits: 63

Can anyone please help me ... its urgent....

I am working with PDA application but not able to connect to .sdf file. I am using following connection string

SqlCeConnection con = new SqlCeConnection("Data Source =.\\TestDB.sdf; Password =testdb;");

but it is giving me error like: --

The database file cannot be found. Check the path to the database. [ File name = .\TestDB.sdf ]

Please tell me where I am going wrong.

Thanks in advance.

Post #379986

Sugesh Kumar

Posted Monday, July 09, 2007 7:54 AM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:18 AM
Points: 3,461, Visits: 346

DataSource should be the name of the server and Initial Catalog will be the name of the database in the connection string. The database will have your mdf, ldf and sdf files ir so. You can't directly read the contents of the file.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Post #379988

Neeta Patil

Posted Monday, July 09, 2007 8:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 03, 2011 11:32 PM
Points: 156, Visits: 63

Hey Sugesh,

Nice to see your reply. Thanks a lot.

But I want to connect to mobile database...which is in .sdf file format..

Can you please explain more about it.

Regards,

Neeta

Post #379997

Rajesh Patil

Posted Tuesday, April 29, 2008 1:58 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2008 8:31 AM
Points: 15, Visits: 21

The BOL of SQL server CE gives you the method to create the connection string. The only thing happening here is you are not able to give the file to the application. It can be that the BUILD ACTION of the (SDF) file might be set to nothing. change this to content.
Second thing you will have to look into is connection string you are specifying try giving it the folder in which your application is running.
By the way which version of Visual studio are you using.

Rajesh.
MBA-IT (Software Dev. & Mgmt)
SCIT 2007-09

Post #491883

pravingpatil2081

Posted Friday, June 19, 2009 12:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 26, 2011 7:29 AM
Points: 8, Visits: 8

Replace this following

Public conn As New SqlCeConnection("Data Source = \My Documents\test.sdf")

thanxxxxxx

Post #738079

« Prev Topic | Next Topic »

Permissions