AnsweredAssumed Answered

OLE DB connection to MS SQL 2008 database table

Question asked by adriangomez on Jul 11, 2012
Latest reply on Jul 26, 2012 by KGalliher-esristaff
Dear Sir / Madam,

I am trying to connect ArcCatalog 10.0 via OLE DB Connection.

I can preview all tables in the database except for one stating "The selection cannot be previewed"
This table contains x/y coordinates and if I try to create a feature clase it causes the error below:

There was an error trying to process this table.
An underlying database error occured.
An underlying database error occured.[dbo.xxx.tablename]
Multiple-step OLE DB operation generated errors.  Check each OLE DB status
value, if available.  No work was done.

Is there a log file that would provide more detail as to what ArcCatalog does not like about this table?
Are there any particular MS SQL 2008 column data types that should be avoided?
(table currently has 63 columns of data types int, varchar, datetime, tinyint, bit, numeric, nvarchar and xml)

Any suggestions would be greatfully appreciated.

Kind regards, Adrian

Outcomes