Thank you. I did a repair of the connector, Mysql.data.dll is in c:\windows\assembly, but DbMagic still produces the same result. Also, I am able to open a connection to my database in a test program in VS2008:
Dim strConn As String = "server=192.168.0.7;User
Id=sid;pwd=xxxxx;database=mysql;Persist Security Info=True"
Dim oConn As New MySql.Data.MySqlClient.MySqlConnection(strConn)
oConn.Open()
oConn.Close()
This works fine so that tells me the connector is installed correctly, is
that right?
Sid.
Avian Ambassadors - Flights of Education
www.AvianAmbassadors.com
<http://avianambassadors.com/BirdTraining/> The Bird Training Blog
<http://www.behaviorandtraining.com/> Behavior and Training Seminars
From: [email protected] [mailto:[email protected]] On Behalf Of
Sadik Eser
Sent: Monday, January 10, 2011 11:13 AM
To: [email protected]
Subject: Re: [dblinq] Novice needs help
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]
<mailto: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]
<mailto: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]
<mailto: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.
--
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>>
