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.
