Thank you, however when I try to copy Mysql.data from the c:\windows\assembly folder I cannot. I try to right-drag and drop and nothing happens, the cursor does not change and the file is not copied.
Sid. Avian Ambassadors - Flights of Education www.AvianAmbassadors.com The Bird Training Blog Behavior and Training Seminars -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jonathan Pryor Sent: Monday, January 10, 2011 11:39 AM To: [email protected] Subject: Re: [dblinq] Novice needs help As per the exception message, it can't find the MySqlConnection type, because you haven't fully installed it. Specifically, you need to let dbmetal know about it; see: http://code.google.com/p/dblinq2007/wiki/Installation#To_run_DbMetal Specifically, you need to either copy the MySql.Data.dll assembly into the same directory as DbMetal.exe, or edit the DbMetal.exe.config file to reference the correct fully-qualified assembly name. You will also need to follow the instructions in the "To use DbLinq" section. - Jon On Jan 10, 2011, at 12:47 PM, Sid Price wrote: > Thank you for your reply. Here is my attempt to run DbMetal. You will see it fails I would appreciate any help/pointers. > > C:\Data_Root\Temp\DbLinq-0.20.1>dbmetal.exe --provider=Mysql --server=192.168.0.7 --database=in_out --user=sid --password=xxxxxx --code=files\dblinq_mysql.vb > DbLinq Database mapping generator 2008 version 0.20 > for Microsoft (R) .NET Framework version 3.5 > Distributed under the MIT licence (http://linq.to/db/license) > > DbMetal: Could not load databaseConnectionType type 'MySql.Data.MySqlClient.MySq > lConnection, MySql.Data'. Try using the --with-dbconnection=TYPE option. > > Sid. > > Avian Ambassadors - Flights of Education > www.AvianAmbassadors.com > The Bird Training Blog > Behavior and Training Seminars > > From: [email protected] [mailto:[email protected]] On Behalf Of Sadik Eser > Sent: Monday, January 10, 2011 12:46 AM > To: [email protected] > Subject: Re: [dblinq] Novice needs help > > Download dblinq binaries and copy "Mysql.Data.dll" in the same forder with "DbMetal.exe" > > using command line execute DbMetal.exe with the following parameteters, with making necessary replaces. > > DbMetal.exe --provider=Mysql --server=[your server address] --database=[your database name] --user=[mysql user name] --password=[mysql password] --code=[path to vb file] > > add the generated vb file into your project. > create an instance of generated class with "connection string" parameter. > > if you have trouble with using dblinq please also specify the step you have troubled. > > Best regards > Sadık Eser > > > > 2011/1/10 Sid Price <[email protected]> > Hello, > > I am working on a project that needs to work with either a desktop DB > (SQL Express 2008) or a remote DB (MySQL). I have downloaded and > installed the MySQL connector and I am able to connect to a test MySQL > DB. > > I plan on using LINQ for access of the databases and found DBLinq, it > looks like it is what I need to access MySQL using LINQ. However, I am > not a DB expert and I just don't understand what steps I need to take > to get DBLinq working with VS 2008 and VB.NET. I have read the > instructions but really don't understand the steps I need to take. > > Also, when it comes to deploying my application is there anything > special I need to do in order to use DBLinq so that I can offer the > user an option to enter the URL to the NySQL database at runtime. > > Please could someone help me get this set up. > > Many thanks, > Sid. > > -- > You received this message because you are subscribed to the Google Groups "DbLinq" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to [email protected]. > For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups "DbLinq" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to [email protected]. > For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. > > -- > You received this message because you are subscribed to the Google Groups "DbLinq" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to [email protected]. > For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en. -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
<<attachment: winmail.dat>>
