What dialect and driver are you using? I have a feeling you are using the SqlCe instead of the MS SQL.
-Ryan Rinaldi blog: http://ryanrinaldi.com 2009/3/12 steves <[email protected]> > > No, of course I can connect to dabatase trought Server Explorer and > event if I pass that first connection string to SqlConnection > constructor and then open the connection, it works. > > On 12 Bře, 19:17, James Gregory <[email protected]> wrote: > > So you can't even connect to the database through Server Explorer? If so > > then there's a more fundamental issue at hand than just NHibernate. > > > > 2009/3/12 steves <[email protected]> > > > > > > > > > Yes, I tried these connection strings, but it did not work as well. > > > > > This one was generated by Server Exprorer in Visual Studio: > > > "Data Source=.\SQLEXPRESS;Initial Catalog=nhibernate;Integrated > > > Security=True" > > > error: "Additional information: Unknown connection option in > > > connection string: initial catalog." > > > > > than I tried this: > > > "Data Source=.\SQLEXPRESS.nhibernate.dbo;" > > > error: "The database file cannot be found. Check the path to the > > > database. [ Data Source = .\SQLEXPRESS.nhibernate.dbo ]" > > > > > So basicaly I should keep trying until I find some which works? Sounds > > > strange. > > > > > On 12 Bře, 16:23, Dario Quintana <[email protected]> > > > wrote: > > > > There is not such "server" word in those connection strings. Try with > > > "Data > > > > Source" or "Server" > > > > > > On Thu, Mar 12, 2009 at 1:14 PM, steves <[email protected]> > wrote: > > > > > > > I am sorry for a beginner question, but I cannot go trough this. > > > > > > > I have SQL EXPRESS server installed, using .NET 3.5. I have > > > > > downloaded examples via svn at address "http:// > > > > > hibernatingrhinos.googlecode.com/svn/trunk" and tried > "FirstSolution" > > > > > example. > > > > > > > It works well, but it uses local db file. When I tried to change > > > > > connection string for to connect to SQL server, > > > > > I got error "Unknown connection option in connection string: > server." > > > > > If I change connection string somehow, I get similar errors. > > > > > > > My hibernate.cfg.xml file: > > > > > > > <?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.SqlServerCeDriver</ > > > > > property> > > > > > <property > name="connection.connection_string">Server=.\SQLEXPRESS; > > > > > Initial Catalog=NHExample; Integrated Security=SSPI</property> > > > > > <property name="show_sql">true</property> > > > > > </session-factory> > > > > > </hibernate-configuration> > > > > > > > Various connection strings I tried: > > > > > "Server=(local)\SQLEXPRESS; Initial Catalog=NHExample; Integrated > > > > > Security=SSPI" > > > > > "Server=127.0.0.1\SQLEXPRESS; Initial Catalog=NHExample; Integrated > > > > > Security=SSPI" > > > > > etc. > > > > > > -- > > > > Dario Quintanahttp://darioquintana.com.ar > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
