Problem with dotConnector for mySQL

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Zero-G.
Posts: 391
Joined: Sat 09 Dec 2006 12:20

Problem with dotConnector for mySQL

Post by Zero-G. » Mon 10 Nov 2008 16:18

Hey

I use the following code
SQL.GetConnection is a self written Class, and Getconnection is a Public Function, which gives back a Connection

Code: Select all

Private Entity As voptneuModel.voptneuEntities
 Me.Entity = New voptneuModel.voptneuEntities(SQL.GetConnection.ConnectionString)
There I get the following error: (Translated from the german text)
Keyword is not supported: 'user id'.

The StackTrace is:
bei System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
bei System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
bei System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
bei System.Data.EntityClient.EntityConnection..ctor(String connectionString)
bei System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString)
bei System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName)
bei VOPT.voptneuModel.voptneuEntities..ctor(String connectionString) in C:\Users\Intelli Soft\Desktop\VS2005\Vopt LINQ\VOPT\Entities\Datenbank.Designer.vb:Zeile 57.
bei VOPT.usrKundenstamm..ctor() in C:\Users\Intelli Soft\Desktop\VS2005\Vopt LINQ\VOPT\UserControl\usrKundenstamm.vb:Zeile 78.
bei VOPT.VOPTBefehle.Hauptmenü.Kundenstamm() in C:\Users\Intelli Soft\Desktop\VS2005\Vopt LINQ\VOPT\Klasse\VOPTBefehle.vb:Zeile 26.
bei VOPT.frmHauptmenue.ExplorerBar_ItemClick(Object sender, ItemEventArgs e) in C:\Users\Intelli Soft\Desktop\VS2005\Vopt LINQ\VOPT\Formulare\frmHauptmenü.vb:Zeile 30.
bei Janus.Windows.ExplorerBar.ExplorerBar.OnItemClick(ItemEventArgs e)
bei Janus.Windows.ExplorerBar.ExplorerBar.i(ExplorerBarItem )
bei Janus.Windows.ExplorerBar.ExplorerBarItem.InvokeOnClick()
bei Janus.Windows.ExplorerBar.ExplorerBar.OnMouseUp(MouseEventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.Run(ApplicationContext context)
bei Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
bei Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
bei Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
bei VOPT.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:Zeile 81.
bei System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 20 Nov 2008 12:13

The constructor of voptneuModel.voptneuEntities should have the following format:

Code: Select all

"metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=Devart.Data.Oracle;provider connection string="User Id=**;Password=**;Server=**""
, because here is expected Entity Framework connection string, not the dotConnect for MySQL one.

Post Reply