Cannot connect into SQL Server using C# - C# Discussion Boards

23-Apr-09 6:46

Bey guys,
i have a little problem, so if you can help me ill thank you...
i built a Sql server using Visual Stuido 2008 ( it created me a file name my_database.sdf ). now i am tring to connect to the sql server i have created,

i using the code below:

public void Connect()
        {
            this.han = new SqlConnection(@"Data Source=C:\Users\יהב\Documents\Visual Studio 2008\Projects\ADOtutorial\ADOtutorial\my_database.sdf;Persist Security Info=True;Application Name=ConnectDB");
            Console.WriteLine(this.han.ConnectionString);
            try
            {
                this.han.Open();
            }
            catch (NullReferenceException e)
            {
                Console.WriteLine(e);
            }
            catch (SqlException e)
            {
                Console.WriteLine(e);
            }
        }

this is a code in class, the class using this.han to make theconnection, the connection string i have copied from the connection strind i got from VS when i did motify connection -> advance. but for some resons i cant connect

the error i got:

Data Source=C:\Users\יהב\Documents\Visual Studio 2008\Projects\ADOtutorial\ADOtu
torial\my_database.sdf;Persist Security Info=True;Application Name=ConnectDB
System.Data.SqlClient.SqlException: אירעה שגיאה הקשורה לרשת או שגיאה ספציפית למו
פע במהלך יצירת חיבור ל- SQL Server.  השרת לא נמצא או שאינו נגיש. ודא כי שם המופע
 נכון וכי SQL Server מוגדר לאפשר חיבורים מרוחקים. (provider: ממשקי רשת של SQL, e
rror: 26 - שגיאה באיתור שרת/מופע שצוין)
   ב-  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exceptio
n, Boolean breakConnection)
   ב-  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateOb
ject stateObj)
   ב-  System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInterna
lConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boo
lean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
 owningObject)
   ב-  System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
 serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire
, SqlConnection owningObject)
   ב-  System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String hos
t, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObjec
t, SqlConnectionString connectionOptions, Int64 timerStart)
   ב-  System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnect
ion owningObject, SqlConnectionString connectionOptions, String newPassword, Boo
lean redirectedUserInstance)
   ב-  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIden
tity identity, SqlConnectionString connectionOptions, Object providerInfo, Strin
g newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   ב-  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionO
ptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnectio
n owningConnection)
   ב-  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbCon
nection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   ב-  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection ownin
gObject)
   ב-  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
   ב-  System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owni
ngObject)
   ב-  System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection o
wningConnection)
   ב-  System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection o
uterConnection, DbConnectionFactory connectionFactory)
   ב-  System.Data.SqlClient.SqlConnection.Open()
   ב-  ADOtutorial.Database_Driver.Connect() ב- C:\Users\יהב\Documents\Visual St
udio 2008\Projects\ADOtutorial\ADOtutorial\Database_Driver.cs:שורה 46
Press any key to continue . . .

google translate for the hebrew there:

There was an error related to the network or specific error Lmo <br />
According to the connection during the creation - SQL Server. Server not found or is not accessible. Verify that the instance name <br />
  Correct and that SQL Server is configured to allow remote connections. (provider: Web interface of SQL, e <br />
rror: 26 - Error locating server / instance specified)<br />

hope you can help me, thanks, Yahav Wink | ;)

Gindi Bar Yahav - Web & Software defeloper.

Eddy Vluggen23-Apr-09 6:49

23-Apr-09 6:49

.sdf files are SQL CE databases, not SQL Server. You have created an "embedded" database. The database that you wanted (SQL Server) has the file-extension ".mdf".

What did you use to create the database?

I are troll Smile | :)

Gindi Bar Yahav23-Apr-09 6:58

23-Apr-09 6:58

thanks for the replay, umm i didnt know that this is not a SQL Server... i open new Console APP (to check this, acualy i am building a program to my website in WIN but now i need to learn it first.. i done it before with MYSQL but...)
so~, i clicked on Add new item (in the sulution explorer) and them local database connection.
umm... and them i saw the database in the database explorer and i could edit tables, add tables etc...

if its not mysql, can you explin me where i can find the way to connect to that type of sql server?

Gindi Bar Yahav - Web & Software defeloper.

Eddy Vluggen23-Apr-09 7:18

23-Apr-09 7:18

Do you want:
* SQL Server (Serves lots of people at once)
* SQL CE (Embedded database)
* MySQL (...) ?

The SQLConnection is used for SQL Server, not MySQL. SQL Server might be installed by the VS2008 setup, MySQL is a separate download.

Downloads be here[^], tutorials on SQL Server are here[^].

I are troll Smile | :)

Gindi Bar Yahav23-Apr-09 7:28

23-Apr-09 7:28

thanks you very moch for your help, what i am looking for is a software database so i dont really i need very big database, but ill try to work with SQL server to learn it... the last qustion if you can help me is if you know where i can find database hosting

Gindi Bar Yahav - Web & Software defeloper.

Eddy Vluggen23-Apr-09 8:47

23-Apr-09 8:47

Gindi Bar Yahav wrote:
where i can find database hosting

I'd like to recommend ASP Spider[^]. It's the ideal place to try out new ASP.NET/SQL projects, since it is free.

I are troll Smile | :)

SayreCC23-Apr-09 15:41

SayreCC

23-Apr-09 15:41

Hi, add another \ to every \ you have in the connectionstring.

Hope this one can help

Thanks

Gindi Bar Yahav23-Apr-09 22:56

XML Serialisation on Circular Dependency

23-Apr-09 22:56

i have tried it before, it dosent do any change, becuse i added @ before the connection string.

Gindi Bar Yahav - Web & Software defeloper.

EnlilCox23-Apr-09 6:19

EnlilCox

23-Apr-09 6:19

Hi
Say I have 3 classes Book, Page and Chapter. A Book has many Pages, a Page has many chapters.

I wrote it so that Page has a reference back to Book and Chapter has a reference back to Page which I found really useful because I could pass around Page but still get access to the Book object and find out how many other pages there are (as an example).

Of course, this creates a circular dependency which, now that I need to, I can't serialise this with XML.

What should I have done ? Have another object that maintained references to all these objects ? Passed both Book, Page & Chapter around rather than just Chapter ?

If anyone can shed a little light I would be very pleased.

Thanks

Le centriste23-Apr-09 9:10

Le centriste

23-Apr-09 9:10

For serialization, you could decorate the back references properties or public members with the [XmlIgnore] attribute, but that would not solve the deserialization problem.

I suggest you review your design. Could you post the code for your classes, I may be able to give you some pointers.

EnlilCox23-Apr-09 22:13

EnlilCox

23-Apr-09 22:13

Hi, Thanks for replying.
I tried the XmlIgnore route but then realised that there is no AfterSerialisation on XML Serialisation which mean that it wasn't what I wanted.

With classes like this

<br />
    public class Book<br />
    {<br />
        public List<page> Pages { get; set; }<br />
        public string Title { get; set; }<br />
    }<br />
    public class Page<br />
    {<br />
        public Book ParentBook {get;set}<br />
        public List<chapter> Chapters { get; set; }<br />
        public int PageNo { get; set; }<br />
        public Page(Book parent)<br />
        {<br />
            ParentBook = parent;<br />
        }<br />
    }<br />
    public class Chapter<br />
    {<br />
        public Page ParentPage { get; set; }<br />
        public string Heading { get; set; }<br />
        public string Content { get; set; }<br />
        public Chapter (Page parent)<br />
        {<br />
            ParentPage = parent;<br />
        }<br />
    }<br />
</chapter></page>

I can do something like this

<br />
Book b = new Book() { Title = "My Book" };<br />
Page p = new Page(b) { PageNo = 1 };<br />
Chapter c = new Chapter(p) { Heading = "Introduction" };<br />
<br />
RenderChapterNavigation(c);<br />
<br />
private static void RenderChapterNavigation(Chapter c)<br />
{<br />
  if (c.ParentPage.Chapters.Count == 0)<br />
  {<br />
    RenderNoChaptersLink();<br />
  }else{<br />
    RenderChapters(c);<br />
  }<br />
}<br />

(this is not the exact code, but you can see how I can references the other chapters after having just passed in a Chapter object).

Le centriste24-Apr-09 2:30

Le centriste

24-Apr-09 2:30

What kind of XML structure are you expecting?

Re: Unit Testing - WORKED IT OUT

EnlilCox26-Apr-09 23:07

EnlilCox

26-Apr-09 23:07

Hi
I have no preference on the structure but what I wanted was to to have the backward-links from Page to Section and Page to Book reestablished automatically when I deserialised it.

Thanks for your replies

Unit Testing

mark_w_23-Apr-09 5:09

mark_w_

23-Apr-09 5:09

I have a number of test that each submit an object to a Queue (that is declared statically in my Unit test Class) The queue automatically processes each item until there is non left and then fires an event allProcessed.

The problem, is that for each unit test all i test is that it was added to the queue correctally, and i need to let the queue finish processing and at the moment it is getting cut off becasue all the tests finish before the queue processed.

Is there any way to make the test run wait until the allProcessed is fired?

Thanks

mark_w_23-Apr-09 5:15

mark_w_

23-Apr-09 5:15

Just checked in

public static void MyClassCleanup()
{
if(QueueLength!=0)
{
Thread.Sleep(1000);
}

}

Deploying custom fonts at Client Place

ramz_g23-Apr-09 3:24

ramz_g

23-Apr-09 3:24

Hi,

I've developed an application that uses a few font styles that might not be present in all machines... How can I embed these fonts when I deploy my application at the Client's system, assuming that his system does not have those fonts installed... Please suggest...

Thanks in Advance,
ramz_g

Re: Deploying custom fonts at Client Place

Eddy Vluggen23-Apr-09 3:45