Market Discussions

The real revolution on EMMA will happen when it will drop that massive failure called MS SQL server. It's only good at filling in hard disks, creating security holes, requiring massively huge patches and eating lots of memory.

Oh, and best of all, at making it an hell to maintain / remote assist the softwares that use it.

Just put out an update that upgrades the database to the latest static data dump from CCP - Thanks once again to Lost Hamster for converting it to work with EMMA.

Also, just read about the new 3rd party licenses (https://forums.eveonline.com/default.aspx?g=posts&t=84730&find=unread) and it seems that 3rd party developers will still not be allowed to charge real money for their work.
Understandable but somewhat frustrating from my point of view.

I'm going to carry on working on EMMA 2.0 because I've enjoyed if and I've learnt a lot doing it. However, I will have less motivation to spend time on it so it's not going to be around any time soon - I'm expecting at least 6 months to a year. If ever.

Still, the CREST stuff looks very interesting so by the time I get that far down the line it may well require a complete redesign to make use of the new cool stuff anyway. :)

Thanks, will take a look and see what I missed.

Greetings fellow Warlords:



I have many problems. And yes, I’m getting counseling. But perhaps you can help as well.


Why is C:\Documents and Settings\user\Application Data\EMMA\logging\Exceptionlog.txt
Actually file:///C:/Documents%20and%20Settings/user/Application%20Data/EMMA/logging/Exceptionlog.txt

Inner Exception: A network-related or “instance-specific error” occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What is an “instance-specific error?”

How do I find out what instance name is? Or if it is correct?

How do I configure SQL server to allow remote conflicts?

Why did I go to “SQL Server Configuration and enable everything in Protocols for MSSQLSERVER? (and why didn’t it work?)

And last but not least, how do I fix the problem so that I can log on?

Thanks,

Peri

Ok so with a fresh install of EMMA and SQL2008 I'm getting a connection error.

=====================================================================================
EXCEPTION REPORT
=====================================================================================
4/28/2012 10:18:01 PM Critical - EveMarketMonitorApp.Common.EMMAException - Error connecting to database
Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
at EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
=====================================================================================
EXCEPTION REPORT
=====================================================================================
4/28/2012 10:18:01 PM Critical - EveMarketMonitorApp.Common.EMMAException - EMMA is unable to connect to the database.

Yet another Exception report, but I have deleted the SQLEXPRESS file and still nothing, added it to the SQL Server Management Studio Database (Recovery Pending) Even changed the string line in EveMarketMonitorApp.exe.config with my pc name . Getting frustrated, Help Please. Thank you


=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/12/2012 9:43:17 AM Error - EveMarketMonitorApp.Common.EMMAException - Problem detecting SQL installation
Inner Exception:
Stack Trace: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at System.Management.ManagementObjectCollection.get_Count()
at EveMarketMonitorApp.Common.SQLExpressChecks.GetSQLVersion()
at EveMarketMonitorApp.GUIElements.Main.isSQLExpressInstalled()

name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString"
connectionString="Data Source=PC Name;AttachDbFilename="|DataDirectory|\Data\EMMA Database.mdf";Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient
name="EveMarketMonitorApp.Properties.Settings.ebs_DATADUMPConnectionString"
connectionString="Data Source=PC Name;AttachDbFilename=|DataDirectory|\Data\EveData.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient

If you are sure that the SQL is running then, change the EveMarketMonitorApp.exe.config
Look for the entry: setting name="SkipExpressCheck"
And change it to: True

I wanted to copy the whole config file, however It seems the new forum do not like the sign, < >

Sorry, just hadn't checked anything for a few days, will get it sorted.

Go to where you installed (probably somthing like C:\program files\emma) and open 'EveMarketMonitorApp.exe.config' in notepad.

Find this setting: setting name="SkipConnectionCheck"

and change the value to 'True'
That will skip the checks, not sure if the rest of the system will work or not if you have unusually high latency

The only thing that comes to mind wouldb a firewall that blocks ping messages