Anybody tried the NHibernate Query Analyzer http://www.ayende.com/projects/nhiberna ... lyzer.aspx

I cant get it work, it says that he cant connect to the database. I try to change the db connection from sqlite to my ms sql server and the Query Analyzer wont open then.

Thanks!

I've used it, and it worked fine. That was version 0.9 on .NET 1.1, about 6 months ago.

I used it a week or two ago, with NHibernate 1.0 and MS SQL Server, and it worked okay. Getting a "project" set up was a bit confusing, but once I figured that out, it worked fine.

IIRC, The difficulty I had was related to the creation of NHQA internal database (on SQLite)... I wonder why it is not packaged with an empty (local) database.

Do you remember what was it?

This is the error im having:

System.Exception: NHibernate.ADOException: Could not execute query ---> Finisar.SQLite.SQLiteException: no such table: Entity

Entity is part of my project, wich runs with ms sql database.

These are my steps:

> New Project
> Select my project dlls
> Build them
> New Query
> Query: "from Entity"

Thats all, perhaps im missing something.

Thanks in advance

Martin

My issue was related to the loading of NQA; once it is loaded, it means that the database is accessible.

You have to create the table "Entity" in your database, NQA doesn't do this for you...