This question is locked. New answers and comments are not allowed.
I have a Web Service used to send and receive data with phones. Using vs2013 and MSSQL. Using the default ORM connection manager. I'm getting a random error about not being able to connect to the database. I have added debugging info to make sure I'm passing the correct server, user and password. I multiple databases and I build the connection string.
Below is a sample of how I connect:
using (msModel mgr=new msModel(connString)){...
I though it was too many connections made so I reduced the pool to 6 and idle connections to 3 - no help.
I have replaced username and password with XXX
Cannot open database "ms_gl4988a" requested by
the login. The login failed.
Login failed for user 'XXX'.
at OpenAccessRuntime.ExceptionWrapper.Throw()
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet
props)
at OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props)
at OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String
usr, String password, Boolean open)
at OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider)
at Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider)
at Telerik.OpenAccess.OpenAccessContextBase.GetScope()
at Telerik.OpenAccess.OpenAccessContext.GetAllCore[T]()
at Telerik.OpenAccess.OpenAccessContext.GetAll[T]()
at Mainstreet.GlasAve9.Configuration.getConfigData(String ccode)
at Mainstreet.GlasAve9.Configuration.IsConfigOn(String ccode)
at Mainstreet.GlasAve9.PosMobile.PosMobile.putInvoice2(List`1 invoices, LoginInfo
loginInfo)
My connection:MultipleActiveResultSets=true;Pooling=false;Enlist=false;data
source=vmsql6\mainstreet9;initial catalog=ms_gl4988a;persist security
info=True;Integrated security=false;User
ID=XXX;password=XXX;multipleactiveresultsets=True;application
name=Mobile V2
Telerik.OpenAccess.Runtime...
TIA - Bill
Below is a sample of how I connect:
using (msModel mgr=new msModel(connString)){...
I though it was too many connections made so I reduced the pool to 6 and idle connections to 3 - no help.
I have replaced username and password with XXX
Cannot open database "ms_gl4988a" requested by
the login. The login failed.
Login failed for user 'XXX'.
at OpenAccessRuntime.ExceptionWrapper.Throw()
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet
props)
at OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props)
at OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String
usr, String password, Boolean open)
at OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider)
at Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider)
at Telerik.OpenAccess.OpenAccessContextBase.GetScope()
at Telerik.OpenAccess.OpenAccessContext.GetAllCore[T]()
at Telerik.OpenAccess.OpenAccessContext.GetAll[T]()
at Mainstreet.GlasAve9.Configuration.getConfigData(String ccode)
at Mainstreet.GlasAve9.Configuration.IsConfigOn(String ccode)
at Mainstreet.GlasAve9.PosMobile.PosMobile.putInvoice2(List`1 invoices, LoginInfo
loginInfo)
My connection:MultipleActiveResultSets=true;Pooling=false;Enlist=false;data
source=vmsql6\mainstreet9;initial catalog=ms_gl4988a;persist security
info=True;Integrated security=false;User
ID=XXX;password=XXX;multipleactiveresultsets=True;application
name=Mobile V2
Telerik.OpenAccess.Runtime...
TIA - Bill