Re: Process.Start is eating spaces - 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

Eddy Vluggen

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

Eddy Vluggen

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

Eddy Vluggen

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?