No Records revealed after Database Connection Made

[JesseJoe]

Hi everybody,

I am having issues with accessing records after making a database connection in ArcCatalog. I go and try to preview the table but no records are there.

help!

Jesse
GIS Technician
Town of Sidney, BC, Canada

[MichaelVolz]

Has your database account at least been assigned viewer roles to see data in the SDE database?

[JesseJoe]

My desired database does show up in the Database Connection dialog, after specifying:

DATABASE PLATFORM, INSTANCE, AUTHENTICATION TYPE

What follows when I open the database is a list of tables, everything looks good but when I go and preview the table by right clicking, no records are found.

Yeah, that's my situation....

[MichaelVolz]

What type of database are you connecting to (e.g. Oracle, SQL Server, etc.)?

[JesseJoe]

SQL Srver 2005 database, on Windows Server 2003 R2, with SQL Native Client 2003 R2

[WilliamCraft]

Is it possible that your tables are registered as versioned within ArcSDE?  If so, which transactional version are you connecting to with the ArcSDE connection file from ArcCatalog?  I'm wondering if all of your records might exist in a different version that hasn't yet been reconciled and posted.  For example, you might be connecting to SDE.DEFAULT to view the data in ArcCatalog but perhaps you've inserted your records into a child version called SDE.DEFAULT_CHILD.  As another test if this turns out to not be the issue, can you log into SQL Server Studio Manager and see the records that way?  If you cannot, then your tables might be empty to begin with.

[JesseJoe]

Michael Volz,

I think I am misunderstanding your question about assigned viewer roles due to my inexperience. Can you explain that a little further for me?

thanks

[JesseJoe]

Hi William, I think I am good there regarding versioning. I did a check also whether records exists at the sources, they do. Thanks for the heads-up.

[WilliamCraft]

I think his suggestion might be to ensure that the user you are connecting with in ArcCatalog has been assigned to something like the db_datareader role within the database.  Technically, a user account can exist and connect but have no permissions to see any records.  So, you have a user login set up at the SQL Server instance level and there should be a corresponding user created within the database for that particular login.  In SQL Server Studio Manager, if you can log in as an administrator or the 'sa' account then you can expand the database properties to see the Security section.  Under the user in question, right click to see the properties and then ensure that it has been assigned to at least one role.

[AsrujitSengupta]

You are able to see the table...and I guess, the Schema(Fields) as well..

I think the issue could be with one of the Field names......check for Reserved Keywords for that particular SQL Server version..