I'm using the Oradirect/OracleDataSource visual component. I'm connecting to an Oracle 9i server, but I could also work with a Oracle 11g. The component works very good; but when I try to use the SqlCacheDependency it fails.
If I put the oracle esquema name and the table name at the SqlCacheDependency "esquema1:table1" this is the error:
The 'esquema1:table1' SqlDependency attribute for OutputCache directive is invalid.
Detailed error message: Cannot find the 'esquema1' database in the configuration.
If I put just the table name at the sqlcachedependency "table1" this is the error:
The 'table1' SqlDependency attribute for OutputCache directive is invalid.
For SQL Server 7.0 and SQL Server 2000, the valid format is "database:tablename", and table name must conform to the format of regular identifiers in SQL. To specify multiple pairs of values, use the ';' separator between pairs. (To specify ':', '\ or ';', prefix it with the '\ escape character.)
I need help with that. I'm I using something wrong? Do I have to write that diferent? Does the sqlcachedependecy doesn't works with an Oracle Server?
thanks for any help you can give me
OracleDataSource - SqlCacheDependency error
-
fbenavidesd
- Posts: 3
- Joined: Wed 27 May 2009 11:44
OracleDatasource SqlCacheDependency
Thanks for your clarification. But just for be sure that you understand me , the SqlCacheDependency that I'm refering is the one that apears as a option in the Properties Windows of the OracleDatasource Component in Design Time in the Visual Studio 2008, that's why I was thinking that it should work with oracle, or maybe that property shouldn't be available.Shalex wrote:The SqlCacheDependency class is designed to work with SQL Server only.