invalid object name information_schema.columns

Sep 27, 2010 at 10:06 PM

Hi All,


I am having trouble getting the latest version of NHibernate Mapping Generator to work with Sql Server 2000 with the connection string in the following format.

Data Source=mySqlServer;Initial Catalog=myDatabase;User Id=myUid;Password=myPwd;

When i try to connect , i get this wierd error "invalid object name information_schema.columns"

Not sure, if this has something to do with the fact that our database was created with case sensitive collation "SQL_Latin1_General_CP1_CS_AS"

Please advise.



Oct 1, 2010 at 10:46 PM

You are correct in saying the issue is caused by your database being case sensitive. There should be a fix soon making all SQL Server queries uppercase.

Nov 10, 2011 at 9:27 AM

I am getting this exception on the current version, so I guess this was not addressed?