sqlmetal issue with mysql - DbLinq

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion sqlmetal issue with mysql
Received-SPF: pass (google.com: domain of jamesdarbysh...@gmail.com designates 209.85.213.178 as permitted sender) client-ip=209.85.213.178;
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=BsOKGAhjVE22zQZdEs+kWgqygerIRreV4CDjbZ2E3cywISmety17d6H5TWBEOBo6DA
         GO82vkV1U7GIH3i2NDlwxCkH5GBWc/VeFTp3idN3G/EXWaZpzUG/5jWnOo3iGKqsmdFP
         jhCZOamzCzSO/qa2P2ODLyJDRYWsbXS1eDRdU=
MIME-Version: 1.0
In-Reply-To: <0cf3b1cf-4012-4072-9619-94aaf37a3...@l25g2000prn.googlegroups.com>
References: <0cf3b1cf-4012-4072-9619-94aaf37a3...@l25g2000prn.googlegroups.com>
Date: Wed, 22 Sep 2010 20:32:52 +1000
Message-ID: <AANLkTimHLLjHPWPabFT+WMx7pYgyL2Rm0XHejpO_1...@mail.gmail.com>
Subject: Re: [dblinq] sqlmetal issue with mysql
From: James Darbyshire <jamesdarbysh...@gmail.com>
To: dblinq@googlegroups.com
Content-Type: multipart/alternative; boundary=00151750ea0a077c5e0490d6ab54

--00151750ea0a077c5e0490d6ab54
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Is this with the mono bundled dblinq or the download at google code?

Regards,

James Darbyshire

Sent from my Samsung Droid=99

On 22/09/2010 1:33 PM, "El" <ellory...@dasarchitekt.com> wrote:

Hi,

I'm testing out Linq to MySql.  I downloaded the latest MySQL
Connector/Net from the MySQL site.  I have a simple mysql database
with 1 table in the schema.

When I executed the command below:

sqlmetal /provider:MySql  /server:localhost /database:MySqlSampleDb /
user:hansel /password:rpt4wr5 /pluralize /code=3Dmysqlsampledb.cs

I get this as the output and I don't get any file.

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)

>>> Reading schema from MySQL database
sqlmetal: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

I have the latest Mysql.Data.dll in my GAC.  I even copied the file in
the local directory where I run sqlmetal.  I saw some links that
suggested adding the /databaseConnectionProvider.  So I did and change
it as below.  I also added the debug option to get the stack trace.

sqlmetal /provider:MySql /
databaseConnectionProvider=3D"MySql.Data.MySqlConnection, MySql.Data" /
server:localhost /database:MySqlSampleDb /user:hansel /
password:rpt4wr5 /debug /pluralize /code=3Dmysqlsampledb.cs

This is what I got...

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)

>>> Reading schema from DBML file
'/databaseConnectionProvider=3DMySql.Data.MySqlConnection, MySql.Data'
sqlmetal: Could not find file "/
databaseConnectionProvider=3DMySql.Data.MySqlConnection, MySql.Data".

I even copied the DLL locally and installed it in the GAC.  Below is
the trace output with /debug:

sqlmetal: System.IO.FileNotFoundException: Could not find file "/
databaseConnectionProvider=3DMySql.Data.MySqlConnection, MySql.Data".
File name: '/databaseConnectionProvider=3DMySql.Data.MySqlConnection,
MySql.Data'
 at System.IO.FileStream..ctor (System.String path, FileMode mode,
FileAccess access, FileShare share, Int32 bufferSize, Boolean
anonymous, FileOptions options) [0x00000] in <filename unknown>:0
 at System.IO.FileStream..ctor (System.String path, FileMode mode,
FileAccess access, FileShare share) [0x00000] in <filename unknown>:0
 at (wrapper remoting-invoke-with-check) System.IO.FileStream:.ctor
(string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare)
 at System.IO.File.OpenRead (System.String path) [0x00000] in
<filename unknown>:0
 at DbMetal.Generator.Implementation.Processor.ReadSchema
(DbMetal.Parameters parameters, System.String filename) [0x00000] in
<filename unknown>:0
 at DbMetal.Generator.Implementation.Processor.ReadSchema
(DbMetal.Parameters parameters, ISchemaLoader& schemaLoader) [0x00000]
in <filename unknown>:0
 at DbMetal.Generator.Implementation.Processor.ProcessSchema
(DbMetal.Parameters parameters) [0x00000] in <filename unknown>:0

I don't know what else to try.  Any help appreciated.

--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to dblinq@googlegroups.com.
To unsubscribe from this group, send email to
dblinq+unsubscribe@googlegroups.com <dblinq%2Bunsubscribe@googlegroups.com>=
.
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=3Den.

--00151750ea0a077c5e0490d6ab54
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

<p>Is this with the mono bundled dblinq or the download at google code?</p>
<p>Regards,</p>
<p>James Darbyshire</p>
<p>Sent from my Samsung Droid=99</p>
<p><blockquote type=3D"cite">On 22/09/2010 1:33 PM, &quot;El&quot; &lt;<a h=
ref=3D"mailto:ellory...@dasarchitekt.com">ellory...@dasarchitekt.com</a>&gt=
; wrote:<br><br>Hi,<br>
<br>
I&#39;m testing out Linq to MySql. =A0I downloaded the latest MySQL<br>
Connector/Net from the MySQL site. =A0I have a simple mysql database<br>
with 1 table in the schema.<br>
<br>
When I executed the command below:<br>
<br>
sqlmetal /provider:MySql =A0/server:localhost /database:MySqlSampleDb /<br>
user:hansel /password:rpt4wr5 /pluralize /code=3Dmysqlsampledb.cs<br>
<br>
I get this as the output and I don&#39;t get any file.<br>
<br>
DbLinq Database mapping generator 2008 version 0.20<br>
for Microsoft (R) .NET Framework version 3.5<br>
Distributed under the MIT licence (<a href=3D"http://linq.to/db/license" ta=
rget=3D"_blank">http://linq.to/db/license</a>)<br>
<br>
&gt;&gt;&gt; Reading schema from MySQL database<br>
sqlmetal: Client does not support authentication protocol requested by<br>
server; consider upgrading MySQL client<br>
<br>
I have the latest Mysql.Data.dll in my GAC. =A0I even copied the file in<br=
>
the local directory where I run sqlmetal. =A0I saw some links that<br>
suggested adding the /databaseConnectionProvider. =A0So I did and change<br=
>
it as below. =A0I also added the debug option to get the stack trace.<br>
<br>
sqlmetal /provider:MySql /<br>
databaseConnectionProvider=3D&quot;MySql.Data.MySqlConnection, MySql.Data&q=
uot; /<br>
server:localhost /database:MySqlSampleDb /user:hansel /<br>
password:rpt4wr5 /debug /pluralize /code=3Dmysqlsampledb.cs<br>
<br>
This is what I got...<br>
<br>
DbLinq Database mapping generator 2008 version 0.20<br>
for Microsoft (R) .NET Framework version 3.5<br>
Distributed under the MIT licence (<a href=3D"http://linq.to/db/license" ta=
rget=3D"_blank">http://linq.to/db/license</a>)<br>
<br>
&gt;&gt;&gt; Reading schema from DBML file &#39;/databaseConnectionProvider=
=3DMySql.Data.MySqlConnection, MySql.Data&#39;<br>
sqlmetal: Could not find file &quot;/<br>
databaseConnectionProvider=3DMySql.Data.MySqlConnection, MySql.Data&quot;.<=
br>
<br>
I even copied the DLL locally and installed it in the GAC. =A0Below is<br>
the trace output with /debug:<br>
<br>
sqlmetal: System.IO.FileNotFoundException: Could not find file &quot;/<br>
databaseConnectionProvider=3DMySql.Data.MySqlConnection, MySql.Data&quot;.<=
br>
File name: &#39;/databaseConnectionProvider=3DMySql.Data.MySqlConnection,<b=
r>
MySql.Data&#39;<br>
 =A0at System.IO.FileStream..ctor (System.String path, FileMode mode,<br>
FileAccess access, FileShare share, Int32 bufferSize, Boolean<br>
anonymous, FileOptions options) [0x00000] in &lt;filename unknown&gt;:0<br>
 =A0at System.IO.FileStream..ctor (System.String path, FileMode mode,<br>
FileAccess access, FileShare share) [0x00000] in &lt;filename unknown&gt;:0=
<br>
 =A0at (wrapper remoting-invoke-with-check) System.IO.FileStream:.ctor<br>
(string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare)<br>
 =A0at System.IO.File.OpenRead (System.String path) [0x00000] in<br>
&lt;filename unknown&gt;:0<br>
 =A0at DbMetal.Generator.Implementation.Processor.ReadSchema<br>
(DbMetal.Parameters parameters, System.String filename) [0x00000] in<br>
&lt;filename unknown&gt;:0<br>
 =A0at DbMetal.Generator.Implementation.Processor.ReadSchema<br>
(DbMetal.Parameters parameters, ISchemaLoader&amp; schemaLoader) [0x00000]<=
br>
in &lt;filename unknown&gt;:0<br>
 =A0at DbMetal.Generator.Implementation.Processor.ProcessSchema<br>
(DbMetal.Parameters parameters) [0x00000] in &lt;filename unknown&gt;:0<br>
<br>
I don&#39;t know what else to try. =A0Any help appreciated.<br>
<font color=3D"#888888"><br>
--<br>
You received this message because you are subscribed to the Google Groups &=
quot;DbLinq&quot; group.<br>
To post to this group, send email to <a href=3D"mailto:dblinq@googlegroups.=
com">dblinq@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:dblinq%2Bun=
subscribe@googlegroups.com">dblinq+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/dblinq?hl=3Den" target=3D"_blank">http://groups.google.com/group/dblin=
q?hl=3Den</a>.<br>
<br>
</font></blockquote></p>

--00151750ea0a077c5e0490d6ab54--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
