Cannot open table in Enterprise Manager after data import

[BonitaRobinson]

Newbie to SQL -

After importing data into the tables of the database, when I try to open the table in Enterprise Manager I receive the following error:

[Query] - Query Designer encountered a Query error: Unspecified error.

I can go to the Query analyzer and access the tables.

Thank you in advance for your help.

 

[wsmall73]

if you are interested in just seeing the data absolutely....

select * from <TABLE> (NOLOCK)


you can use a WHERE statement to further dissect your data.

 

[peter3244]

thread 183-262545 is similiar..

 

[peter3244]

Hi, Had the same problem solved it by reloading MDAC (the setup should be on the SQL Server disk) or you can go to the microsift web site. Note
the MDAC we used was 2.0 the latest however is 2.6.

 

[BonitaRobinson]

Thanks!

I also found out that Microsoft has a patch for this in SP3 for SQL Server 7.0