Do you know why I am keep getting this exception? DataAccessException: Unable to intercept method XYZ. sql server does not exist or access denied.
I check the sql is running and access via sql analyzer is also correct... I am not sure about my config files. <pre> at IBatisNet.DataAccess.Configuration.DaoProxy.Intercept(IInvocation invocation, Object[] arguments) at ProxyInterfaceResourceSqlMapDao_IResourceDao_IDao_ISerializable.GetResource(Int32 ) at Appsecure.Test.Persistence.ResourceDaoTest.TestGetResourceDao() in c:\development\appsecure\src\appsecure\appsecure.test\persistence\resourcedaotest.cs:line 31 --DataAccessException at IBatisNet.DataMapper.SqlMapSession.OpenConnection() at IBatisNet.DataMapper.SqlMapper.OpenConnection() at IBatisNet.DataAccess.DaoSessionHandlers.SqlMapDaoSession.OpenConnection() at IBatisNet.DataAccess.DaoManager.OpenConnection() at IBatisNet.DataAccess.Configuration.DaoProxy.Intercept(IInvocation invocation, Object[] arguments) --DataMapperException at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at IBatisNet.DataMapper.SqlMapSession.OpenConnection() <?xml version="1.0" encoding="utf-8"?> <sqlMapConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd"> <settings> <setting useStatementNamespaces="false"/> <setting cacheModelsEnabled="true"/> </settings> <sqlMaps> <sqlMap resource="${path}/Persistence/Map/Resource.xml"/> </sqlMaps> </sqlMapConfig> </pre> <pre> <?xml version="1.0" encoding="utf-8" ?> <settings> <!-- User application and configured property settings go here.--> <!-- Example: <add key="settingName" value="settingValue"/> --> <add key="path" value="../../../XYZ.Core" /> <add key="userid" value="XYZ" /> <add key="password" value="password" /> <add key="database" value="XYZDB" /> <add key="datasource" value="(local)\NetSDK;" /> <add key="provider" value="sqlServer1.1" /> </settings> </pre> -------------------------- <pre> <?xml version="1.0" encoding="utf-8"?> <daoConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="DaoConfig.xsd"> <!-- Optional if resource --> <providers embedded="providers.config, XYZ.Core"/> <context id="SqlMapDao" default="true"> <properties resource="properties.config"/> <!-- ==== Sql Server : SqlClient configuration =========--> <database> <provider name="sqlServer1.1"/> <dataSource name="Appsecure" connectionString="data source=${datasource};database=${database};user id=${userid};password=${password};"/> </database> <daoSessionHandler id="SqlMap"> <property name="resource" value="${path}/sqlMap.config"/> </daoSessionHandler> <daoFactory> <dao interface="XYZ.Core.Persistence.IResourceDao, XYZ.Core" implementation="XYZ.Core.Persistence.MapperDao.ResourceSqlMapDao, XYZ.Core"/> </daoFactory> </context> </daoConfig> </pre> __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
