This project has moved. For the latest updates, please go here.


SQL Test Connection Exception Error


Hi Dr. Adrian Voßkühler,
Appreciative of the expertise, time, and enthusiasm you contribute the maintaining the OGAMA code and answering user questions.

I've just begun experimenting with eye-gaze and mouse tracking analysis, and wearable biometric tech to use in a study of executive functioning and focus as it relates to behavioral economic decisions in the context of three control groups:
Yoga & Meditation
Aerobic Activity

I was excited to find OGAMA as it seems like an ideal solution for studying task-oriented behavior on the computer, and am eager to run test trials to see if it will allow the appropriate data to be acquired for the study.

My Machine:
HP DV6t-2000
Processor: Intel i7
OS: Windows Home Premium 64-Bit
Program Dependencies: .NET 4.5.1 Installed

I just downloaded Microsoft SQL Express 2014 and installed it with the server name as SQLEXPRESS successfully.

Upon running the program for the first time, there was an error message indicating tobiisdk.dll was missing.
The following thread was found:
missing tobiisdk ddl prevents startup.
Bonjour was installed after reading the thread. And somehow the issue seems to have been ameliorated.

Upon running the test configuration wizard, when "SQLEXPRESS" is specified and the Test Connection button is pressed, the program generated an exception error that follows this paragraph.
Just after clicking quit, OGAMA also gave an exception area that is attached in text form.

Expert assistance at resolving this issue will be greatly appreciated.

Windows Exception Error

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.SqlClrProvider, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.SqlServer.Management.Common.ConnectionManager.CallerHavePermissionToUseSQLCLR()
at Microsoft.SqlServer.Management.Common.ConnectionManager..ctor(SqlConnection sqlConnectionObject)
at Microsoft.SqlServer.Management.Common.ServerConnection..ctor(SqlConnection sqlConnection)
at Ogama.MainWindow.Dialogs.ExperimentSettingsDialog.TestSQLServerConnection(Boolean showMessage)
at Ogama.MainWindow.Dialogs.ExperimentSettingsDialog.btnTestSQLConnection_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

************** Loaded Assemblies **************
Assembly Version:
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

Assembly Version: 4.5.5259.36458
Win32 Version: 4.5

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Ogama.exe

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Assembly Version:
Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

Assembly Version:
Win32 Version: 4.0.30319.34244 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

Assembly Version:
Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Assembly Version:
Win32 Version: 4.5

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/OgamaControls.DLL

Assembly Version:
Win32 Version:

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/DirectShowLib-2005.DLL

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

Assembly Version:
Win32 Version:

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Tobii.Eyetracking.Sdk.DLL

Assembly Version:
Win32 Version:

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/AxShockwaveFlashObjects.DLL

Assembly Version:
Win32 Version:

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/ShockwaveFlashObjects.DLL

Assembly Version:
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

Assembly Version:
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Microsoft.SqlServer.ConnectionInfo.DLL

Assembly Version:
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Microsoft.SqlServer.Smo.DLL

Assembly Version:
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Microsoft.SqlServer.Management.Sdk.Sfc.DLL

Assembly Version:
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

CodeBase: file:///C:/Program%20Files%20(x86)/OGAMA%204.5/Microsoft.SqlServer.SqlEnum.DLL

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the section.
The application must also be compiled with debugging

For example:

< jitDebugging="true" />

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

file attachments

Closed May 15, 2015 at 4:36 PM by AVosskuehler
There were so many Problems with the SQL Server that i decided to move to sqlite database Connection with Ogama V5. Please try this Version and hopefully there are less Problems with the database Connection!


uacar wrote Jan 3, 2015 at 6:31 AM

Hi, I have struggling with the same problem.

Can you find a solution for that?


TomasSula wrote Jan 7, 2015 at 10:19 AM

Same problem, any solution?

Thank you

AnnaShvarts wrote Jan 17, 2015 at 7:39 PM

It seems here is a solution
Thanks to Andrian!