I am having a problem connecting to SQL Express with vb.net.

The error message I am getting is:

"{"Keyword not supported: '.\sqlexpress;attachdbfilename'."}"

Has anyone had this problem or has a sample connection string for SQL Express?

Could you provide some more details? The exception you get, the connection string, NH configuration?

The app.config settings are as follows:

<configSections>
<section name="nhibernate" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</configSections>
<nhibernate>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2005Dialect"/>
<add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver"/>
<add key="hibernate.connection.connection_string" value=".\SQLEXPRESS;AttachDbFilename=TestDB.mdf;Integrated Security=True;User Instance=True"/>
</nhibernate>

My very simplified code is as follows:


Dim tran As NHibernate.ITransaction
Dim cfg As Configuration = New Configuration
factory = cfg.BuildSessionFactory

session = factory.OpenSession()
tran = session.Transaction

tran.Begin()

session.Save(Me)
tran.Commit()


I am getting an error at the "tran = session.Transaction" line

Please Help

Your connection string is not well-formed. You need "Data Source=.\SQLEXPRESS" or "Server=.\SQLEXPRESS".

Karl,

Can you be a bit clearer?

Do you mean add a new key?

Thanks

Make the connection string this:

or this:

Thanks Karl... That worked perfectly