I have attempted to set up an ADP connection to a custom ERP systems’s SQL Server DB which uses Custom Data Types throughout all tables. I can see table design and stored proceedure design but can’t see any data in tables or run any stored proceedures against these tables.
I have tested other databases on the same SQL server with the same login account so security is not the issue. The only thing I can find unique about this database is that every field utilizes a custom data type.
ODBC connections to this same SQL server DB tables are sucessfull and all data is visible. I have a feeling it may have to do with “extended properties”…when setting up the ADP connection in the ADP wizard, I am not sure if there is a parameter I can pass to allow the use of these and what the syntax is.
Has anyone else run into this anywhere and if so is there a workaround? I have asked the vendor of the SQL server DB but they did not have any answers and suggested that I ask Microsoft…..enough said on that! I searched all of MSDN etc…with no luck finding anything.
Any insight would be greatly appreciated!