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

Closed

SQL Test Connection Exception Error

description

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
Studying

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=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.SqlClrProvider, Version=11.0.0.0, 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 **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR

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

Ogama
Assembly Version: 4.5.5259.36458
Win32 Version: 4.5

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

System.Windows.Forms
Assembly Version: 4.0.0.0
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

System.Drawing
Assembly Version: 4.0.0.0
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

System
Assembly Version: 4.0.0.0
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

System.Core
Assembly Version: 4.0.0.0
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

System.Deployment
Assembly Version: 4.0.0.0
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

System.Configuration
Assembly Version: 4.0.0.0
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

System.Xml
Assembly Version: 4.0.0.0
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

OgamaControls
Assembly Version: 4.5.0.0
Win32 Version: 4.5

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

DirectShowLib-2005
Assembly Version: 2.1.0.0
Win32 Version: 2.1.0.0

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

Accessibility
Assembly Version: 4.0.0.0
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

Tobii.Eyetracking.Sdk
Assembly Version: 3.0.2.0
Win32 Version: 3.0.2.0

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

AxShockwaveFlashObjects
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

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

ShockwaveFlashObjects
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

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

System.Data
Assembly Version: 4.0.0.0
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

Microsoft.SqlServer.ConnectionInfo
Assembly Version: 11.0.0.0
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

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

Microsoft.SqlServer.Smo
Assembly Version: 11.0.0.0
Win32 Version: 11.0.1750.32 ((SQL_PreRelease).111104-1939 )

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

Microsoft.SqlServer.Management.Sdk.Sfc
Assembly Version: 11.0.0.0
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

Microsoft.SqlServer.SqlEnum
Assembly Version: 11.0.0.0
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 system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

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!

comments

uacar wrote Jan 3, 2015 at 6:31 AM

Hi, I have struggling with the same problem.

Can you find a solution for that?

-Ugur

TomasSula wrote Jan 7, 2015 at 10:19 AM

Same problem, any solution?

Thank you
TS

AnnaShvarts wrote Jan 17, 2015 at 7:39 PM

It seems here is a solution https://ogama.codeplex.com/discussions/549272
Thanks to Andrian!