Re: Error while opening SQL Server CE database



What namespace are you using? SqlClient or SqlCe? It looks like SqlClient.


____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"rkbnair" <rkbnair@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:21087A5A-2D48-4F05-875E-8D93C1F70D41@xxxxxxxxxxxxxxxx
I get the following error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)



SqlConnection xx = new SqlConnection("Data Source=D:\\My Documents\\Visual
Studio Codename
Orcas\\Projects\\ImagesHandling\\ImagesHandling\\tbl_ge_media_log_CE1.sdf;
Password =Ocean4578!");
xx.Open();


.



Relevant Pages

  • Re: SQL Compact Edition - Connection Pool --> Slow!
    ... You might want to check out my EBook on SQL Server Compact. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ...
    (microsoft.public.sqlserver.ce)
  • Re: Db connexion mode ???
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... the Connection pool is not a factor. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Compact Edition - Connection Pool --> Slow!
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Compact Edition - Connection Pool --> Slow!
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
    (microsoft.public.sqlserver.ce)
  • Re: SLEEPING/AWAITING COMMAND question
    ... Each time a Stored Proc is called, a new connection is opened, ... > uses to connect to the database. ... SQL Server is not doing any connection pooling. ... the first time SqlClient opens a connection to SQL Server. ...
    (comp.databases.ms-sqlserver)