ycherkes / OrcaSql

A C# parser for MDF files. Allows you to read tables, metadata and indexes from MDF files without it being attached to a running SQL Server instance.
http://improve.dk/archive/2011/05/03/introducing-orcamdf.aspx
GNU General Public License v3.0
17 stars 7 forks source link

Exception System.ArgumentException: 'Table does not exist.' #11

Open jogibear9988 opened 19 hours ago

jogibear9988 commented 19 hours ago

I got this exception in "ScanTable" when i tries to load "sysclsobjs"

see:

image

But the Database works in MSSqlserver:

(its in sql 2008 format)

image image
jogibear9988 commented 19 hours ago

I now tried OrcaMDF

I think the sysschobjs table is already read wrong...

image
ycherkes commented 3 hours ago

Hi, I've just tried opening the test dbs https://github.com/ycherkes/OrcaSql/tree/master/src/OrcaSql.RawCore.Tests/TestDatabases Everything works, excepting 2005. For both sysschobjs and sysclsobjs. (I see you probably confised sysschobjs with sysclsobjs) So, I don't have enough data to reproduce the issue.

jogibear9988 commented 3 hours ago

Would the Database help? PROJECT_2.zip

jogibear9988 commented 3 hours ago

with this code I could read the DB in NET:

  var conn2 = new SqlConnection("Server=(LocalDB)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName=D:\\.....\\PROJECT_2.mdf");
  conn2.Open();