Hi For now, move the database in the GUI project and in the hibernate.cfg.xml
Server=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|ExampleWPF.mdf; Database=ExampleWPF;Trusted_Connection=Yes; use this one On Tue, Nov 4, 2008 at 8:40 AM, HelpNH <[EMAIL PROTECTED]> wrote: > > Hi Tuna, > i have got SQLServer but before i got SQLExpress (uninstalled)so i > have only the instance/name of SQLExpress . > DO you think is it a trouble of SQLServer? > Thanks so much for your care. > Bye > > > On Nov 4, 12:05 pm, "Tuna Toksöz" <[EMAIL PROTECTED]> wrote: > > don't you have a SQLServer installed other than SQLExpress? > > SqlExpress can be problematic due to various reason. > > > > On Tue, Nov 4, 2008 at 3:51 AM, HelpNH <[EMAIL PROTECTED]> wrote: > > > > > HI, > > > i attack my file on this webpage > > > > >http://www.badongo.com/fr/file/11950778 > > > > > you can download it so you can understand better. > > > Have a happy time. > > > Bye > > > > > On Nov 4, 8:21 am, HelpNH <[EMAIL PROTECTED]> wrote: > > > > Hi Tuna, > > > > i tried to change the string that you advice me but when i wish add a > > > > contact appear: > > > > > > ________ADOException was unhandled_________ > > > > > > cannot open the connection > > > > > > instead with my configuration i could add a contact and Phone number > > > > but when i clicked > > > > on the button save appear this error: > > > > > > _________GenericADOException was unhandled by user > code_______________ > > > > could not insert: [Domain.Contact][SQL: INSERT INTO ContactTbl (Name) > > > > VALUES (?); select SCOPE_IDENTITY()] > > > > > > I will post my project on the web. > > > > Let me try!!! > > > > Thanks so much for your take care. > > > > I wish you happy day > > > > Bye > > > > > > On Nov 4, 12:42 am, "Tuna Toksöz" <[EMAIL PROTECTED]> wrote: > > > > > > > Eventhough ugly, please try > > > > > > > <property name="connection.connection_string"> > > > > > Data Source=.\SQLEXPRESS;Integrated Security=True;User > > > > > > Instance=True;AttachDBFilename=C:\Users\Administrator\Desktop\ExampleWPF\ExampleWPF\Database\ExampleWPF.mdf;Persist > > > > > Security Info=False > > > > > </property> > > > > > > > I mean the absolute path. > > > > > > > On Mon, Nov 3, 2008 at 7:13 PM, Tuna Toksöz <[EMAIL PROTECTED]> > wrote: > > > > > > I think the problem is with SQL EXpress connection string > > > > > > > > Driver={SQL Native Client};Server=.\SQLExpress; AttachDbFilename= > > > > > > > |DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes; > > > > > > > > connectionstrings.com says > > > > > > > > On Mon, Nov 3, 2008 at 7:00 PM, HelpNH <[EMAIL PROTECTED]> > > > wrote: > > > > > > > >> Hi Tuna, > > > > > >> thanks for your reply so fast, > > > > > >> i tried to change as you advice me but nothing instead if use > this > > > > > >> configuration : > > > > > > > >> <?xml version="1.0" encoding="utf-8" ?> > > > > > >> <hibernate-configuration > > > > > >> xmlns="urn:nhibernate-configuration-2.2"> > > > > > >> <session-factory> > > > > > > > >> <property name="connection.provider"> > > > > > NHibernate.Connection.DriverConnectionProvider > > > > > >> </property> > > > > > >> <property name="dialect"> > > > > > >> NHibernate.Dialect.MsSql2005Dialect > > > > > >> </property> > > > > > >> <property name="connection.driver_class"> > > > > > >> NHibernate.Driver.SqlClientDriver > > > > > >> </property> > > > > > > > >> <property name="connection.connection_string"> > > > > > >> Data > Source=ERUSYAKO\SQLEXPRESS;Integrated > > > > > >> Security=True; initial > > > > > >> catalog=ExampleWPF > > > > > >> </property> > > > > > > > >> <property > name="use_proxy_validator">false</property> > > > > > >> </session-factory> > > > > > >> </hibernate-configuration> > > > > > > > >> i can debug the project but when i wish save a contact appear > this > > > > > >> error: > > > > > > > >> GenericADOException was unhandled by user code_______________ > > > > > >> could not insert: [Domain.Contact][SQL: INSERT INTO ContactTbl > > > (Name) > > > > > >> VALUES (?); select SCOPE_IDENTITY()] > > > > > > > >> so i dont know where i must put my hand:(. > > > > > >> Thanks again > > > > > >> I wish you happy time > > > > > >> Bye > > > > > > > >> On Nov 3, 11:40 pm, "Tuna Toksöz" <[EMAIL PROTECTED]> wrote: > > > > > >> > Ah, it is probably easy. > > > > > > > >> > In hobermate.cfg.xml change the line with following. > > > > > > > >> > <property name="connection.connection_string"> > > > > > >> > Server=(local);initial > > > catalog=nhibernate;Integrated > > > > > >> > Security=SSPI > > > > > >> > </property> > > > > > > > >> > and set the dialect to following > > > > > > > >> > <property > > > > > >> > name="dialect">NHibernate.Dialect.MsSql2005Dialect</property> > > > > > > > >> > in case the driver is different, use > > > > > > > >> > <property > > > > > > name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property> > > > > > > > >> > On Mon, Nov 3, 2008 at 6:36 PM, HelpNH <[EMAIL PROTECTED] > > > > > wrote: > > > > > > > >> > > Hi, > > > > > >> > > yes sorry from the project SimpleDemo of Mr.Quicoli, > > > > > >> > > i rewrite that project (that's to learn and study Nhibernate > > > With > > > > > >> > > WPF) when i set up the file "Hibernate.cfg.xml" , > > > > > >> > > "Contact.hbm.xml" and "Phone.hbm.xml" to connect the Sql > Server > > > with > > > > > >> > > the NHibernate i receive an error... > > > > > >> > > My Purpose is connect that project with Sql Server changing > the > > > > > >> > > original project files(it's for Firebird) of mappings with > the > > > new > > > > > >> > > but i receive only errors: > > > > > >> > > Do you have some idea where i can wrong? > > > > > >> > > Thanks so much for the reply. > > > > > >> > > Have a happy time. > > > > > >> > > BYE > > > > > > > >> > > On Nov 3, 11:25 pm, "Tuna Toksöz" <[EMAIL PROTECTED]> > wrote: > > > > > >> > > > Can you rephrase what you are trying to do, i am lost a > > > little. > > > > > > > >> > > > On Mon, Nov 3, 2008 at 5:22 PM, HelpNH < > [EMAIL PROTECTED] > > > > > > > >> wrote: > > > > > > > >> > > > > Hi , > > > > > >> > > > > i 'm searching to work out my mistake but nothing , > > > > > >> > > > > do you have some eye to correct my view? > > > > > >> > > > > Thanks so much > > > > > >> > > > > I wish you happy time. > > > > > >> > > > > Bye > > > > > > > >> > > > > On Nov 1, 10:29 am, HelpNH <[EMAIL PROTECTED]> > wrote: > > > > > >> > > > > > HI Sean , > > > > > >> > > > > > i tried to change in the mapping <generator > > > class="identity" /> > > > > > >> but > > > > > >> > > > > > when i debug the project > > > > > >> > > > > > and i wish add a new contact appear this the follow: > > > > > > > >> > > > > > _______ADOException was unhandled_________ > > > > > >> > > > > > could not execute query > > > > > >> > > > > > [ SELECT this_.Id_Contact as Id1_1_1_, this_.Name as > > > Name1_1_, > > > > > >> > > > > > phones2_.Id_Contact as Id4_3_, phones2_.Id_Phone as > > > Id1_3_, > > > > > >> > > > > > phones2_.Id_Phone as Id1_0_0_, phones2_.PhoneType as > > > > > >> PhoneType0_0_, > > > > > >> > > > > > phones2_.PhoneNumber as PhoneNum3_0_0_ FROM ContactTbl > > > this_ > > > > > >> left > > > > > >> > > > > > outer join PhoneTbl phones2_ on > > > > > >> this_.Id_Contact=phones2_.Id_Contact > > > > > >> > > > > > WHERE this_.Id_Contact = ? ] > > > > > >> > > > > > Positional parameters: #0>0 > > > > > >> > > > > > [SQL: SELECT this_.Id_Contact as Id1_1_1_, this_.Name > as > > > > > >> Name1_1_, > > > > > >> > > > > > phones2_.Id_Contact as Id4_3_, phones2_.Id_Phone as > > > Id1_3_, > > > > > >> > > > > > phones2_.Id_Phone as Id1_0_0_, phones2_.PhoneType as > > > > > >> PhoneType0_0_, > > > > > >> > > > > > phones2_.PhoneNumber as PhoneNum3_0_0_ FROM ContactTbl > > > this_ > > > > > >> left > > > > > >> > > > > > outer join PhoneTbl phones2_ on > > > > > >> this_.Id_Contact=phones2_.Id_Contact > > > > > >> > > > > > WHERE this_.Id_Contact = ?] > > > > > > > >> > > > > > i don't know why ,however i add into the database ID > as > > > Identity > > > > > >> > > > > > Specification = yes after in the subMenu there are > > > Identity > > > > > >> Increment > > > > > >> > > > > > = 1 ; Identity Seed = 1; > > > > > > > >> > > > > > Where i wrong :(??? > > > > > >> > > > > > Thanks > > > > > >> > > > > > Have a happy day. > > > > > >> > > > > > Bye > > > > > > > >> > > > > > On Oct 31, 6:35 pm, "Sean Carpenter" < > > > [EMAIL PROTECTED]> > > > > > >> wrote: > > > > > > > >> > > > > > > The issue is that the "sequence" ID generator is not > > > supported > > > > > >> on > > > > > >> > > MS > > > > > >> > > > > SQL > > > > > >> > > > > > > Server. You could change the mapping to <generator > > > > > >> > > class="identity" /> > > > > > >> > > > > to > > > > > >> > > > > > > have it work on SQL Server. Other ID generator > > > strategies > > > > > >> work on > > > > > >> > > SQL > > > > > >> > > > > > > Server as well, but "identity" is similar to > "sequence" > > > and > > > > > >> will > > > > > >> > > work > > > > > >> > > > > fine > > > > > >> > > > > > > for testing. > > > > > >> > > > > > > Sean Carpenter > > > > > > > >> > > > > > > On Thu, Oct 30, 2008 at 10:22 PM, HelpNH < > > > > > >> [EMAIL PROTECTED]> > > > > > >> > > > > wrote: > > > > > > > >> > > > > > > > On Oct 30, 7:22 pm, "Fabio Maulo" < > > > [EMAIL PROTECTED]> > > > > > >> wrote: > > > > > >> > > > > > > > > Hi HelpNH (aka pinkfloyd_mn)Here is a useful > link to > > > > > >> configure > > > > > >> > > NH: > > > > >http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-applicat. > > > > > >> > > .. > > > > > > > >> > > > > > > > > 2008/10/30 HelpNH <[EMAIL PROTECTED]> > > > > > > > >> > > > > > > > Hi Fabio , > > > > > >> > > > > > > > your link is useful and clear,good... > > > > > >> > > > > > > > but i have some trouble to mapping the project of > > > Quicoli > > > > > >> with > > > > > >> > > SQL > > > > > >> > > > > > > > Server . > > > > > >> > > > > > > > I studied that project to learn some feature about > > > > > >> NHibernate > > > > > >> > > with > > > > > >> > > > > WPF > > > > > >> > > > > > > > i rewrite the project > > > > > >> > > > > > > > but when i change the mapping file and > Configuration > > > file of > > > > > >> > > > > > > > NHibernate to connect the project > > > > > >> > > > > > > > with the database i begin to meet > difficulties....now > > > i will > > > > > >> post > > > > > >> > > the > > > > > >> > > > > > > > mapping files and Hibernate.cfg.xml that > > > > > >> > > > > > > > i created to connect with SQL Server. > > > > > > > >> > > > > > > > I Show what i done: > > > > > > > >> > > > > > > > This is the original <Hibernate.cfg.xml> of > Quicoli's > > > > > >> project: > > > > > > > >> > > > > > > > <?xml version="1.0" encoding="utf-8" ?> > > > > ... > > > > read more » > > > -- Tuna Toksöz Typos included to enhance the readers attention! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
