Yeah, just re-read your first email. Change the dialect to the MS Sql dialect (full name escapes me right now).
-Ryan Rinaldi blog: http://ryanrinaldi.com 2009/3/12 Ryan Rinaldi <[email protected]> > 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 -~----------~----~----~----~------~----~------~--~---
