Entity Developer - Database Explorer - Invalid Objectname

linus · Post by **linus** » Fri 14 Jan 2011 06:15

Hello,

I am trying to model a SQL database (SQL Server 2008R2) using LinqConnect v.2.0.10.0 and Entity Developer v.3.0.65 in VisualStudio 2010.
The DatabaseConnection is configured well (test connection shows "OK") but when I try to list the tables or views or procedures in the Database Explorer, I always receive the error message

Invalid objectname 'MyDatabaseName.information_schema.TABLES'

The same same error occurs when trying to model this database direct in the standalone application EntityDeveloper.

Anybody who can help ?

Thanks in advance,
linus

StanislavK · Post by **StanislavK** » Fri 14 Jan 2011 12:49

Thank you for the report, we have reproduced the problem for databases with case-sensitive collation; please specify if this is the case. We will investigate this issue and inform you about the results as soon as possible.

linus · Post by **linus** » Fri 14 Jan 2011 13:35

Hi,

thanks for the quick response.

The collation selected in the database mentioned above is indeed
Latin1_General_CS_AS.
Thus, it is a case sensitive collation.

Looking forward to hearing from you.

Regards,
linus

StanislavK · Post by **StanislavK** » Fri 21 Jan 2011 16:45

We have fixed the problem. The fix will be available in the nearest build which we plan to release in about a week.

StanislavK · Post by **StanislavK** » Thu 27 Jan 2011 18:09

We have released the new 2.20.11 version of LinqConnect which includes the fix for this issue. The new build can be downloaded from
http://www.devart.com/linqconnect/download.html
(the trial and free versions) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in LinqConnect 2.20.11, please refer to
http://www.devart.com/forums/viewtopic.php?t=20121