reinstall mysql .net connector and ensure that, Mysql.Data.dll exists in c:\windows\assembly folder or the same folder with dbmetal.exe
2011/1/10 Sid Price <[email protected]> > 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 <http://avianambassadors.com/BirdTraining/> > > Behavior and Training Seminars <http://www.behaviorandtraining.com/> > > > > *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]<dblinq%[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]<dblinq%[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]<dblinq%[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.
